Differences between revisions 1 and 3 (spanning 2 versions)

SPSS Formats

SPSS supports numeric variables and strings, with conversion options and some automatic conversion functionality. There are several formats on top of numerics that impact visualization, not storage.

Datetime

A warning about data input

SPSS tries to be clever about reading data.

Under the format TIME, all of these are read in as "01:02", even though the format is a minimum of 5-wide:

"1:2"
"01 2"
"01:02"

Under the format DATE, all of these are read in as "28-OCT-90":

"28-OCT-90"
"28/10/1990"
"28.OCT.90"
"28 October, 1990"

Datetime formats

Format	Appears as...	Note
DATETIME20	`dd-MMM-yyyy hh:mm:ss`	`MMM` is as JAN, not 001
DATETIME18	`dd-MMM-yyyy hh:mm`	`MMM` is as JAN, not 001
DATE11	`dd-MMM-yyyy`	`MMM` is as JAN, not 001
DATE7	`dd-MMM-yy`	`MMM` is as JAN, not 001
TIME8	`hh:mm:ss`
TIME5	`hh:mm`
ADATE10	`mm/dd/yyyy`
ADATE8	`mm/dd/yy`
EDATE10	`dd.mm.yyyy`
EDATE8	`dd.mm.yy`

Numerics

Formats only truncate the displayed value, or the value translated into data files. SPSS always retains data to original precision.

Given 123.45...

Format	Using...	Appears as...
Fw	F8	123
Fw.d	F8.1	123.4
Nw	N8	00000123
Nw.d	N8.1	000123.4

Strings

String variables are only formatted to a length. The format is specified as AN where N is the width.

CategoryRicottone

-  ⇤ ← Revision 1 as of 2019-12-08 06:36:29 → 
  Size: 1234
  Editor: DominicRicottone
  Comment: Initial commit
+   ← Revision 3 as of 2020-01-23 14:33:11 → ⇥
  Size: 2085
  Editor: DominicRicottone
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
-= Datetime =
+= SPSS Formats =
SPSS supports numeric variables and strings, with conversion options and some automatic conversion functionality. There are several formats on top of numerics that impact visualization, not storage.
-Line 3:
+Line 4:
-== A warning about data input ==
+----



== Datetime ==

=== A warning about data input ===
-Line 20:
+Line 27:
-== Datetime formats ==
+=== Datetime formats ===
-Line 34:
+Line 41:
+----



== Numerics ==

Formats only truncate the displayed value, or the value translated into data files. SPSS always retains data to original precision.

Given 123.45...

||'''Format''' ||'''Using...''' ||'''Appears as...''' ||
||Fw           ||F8             ||123                 ||
||Fw.d         ||F8.1           ||123.4               ||
||Nw           ||N8             ||00000123            ||
||Nw.d         ||N8.1           ||000123.4            ||

----



== Strings ==

String variables are only formatted to a length. The format is specified as `AN` where `N` is the width.