|
Size: 1234
Comment: Initial commit
|
← Revision 18 as of 2023-06-13 05:00:25 ⇥
Size: 2443
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| = Datetime = | = SPSS Data Types = |
| Line 3: | Line 3: |
| == A warning about data input == | SPSS exposes numeric and string data types. |
| Line 5: | Line 5: |
| SPSS tries to be clever about reading data. | Certain specialized forms of data are handled by formats that impact visualization and export, not storage. The primary example of this is date and time data. |
| Line 7: | Line 7: |
| 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"` |
<<TableOfContents>> |
| Line 12: | Line 9: |
| 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"` |
---- |
| Line 20: | Line 13: |
| == Datetime formats == | == Numeric Data == |
| Line 22: | Line 15: |
| ||'''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` || || |
Numeric data is stored as double-precision floating point. Generally, numeric data uses either a numeric format (`Fw.d` where `w` is the field width and `d` is the number of visible decimal places) or a restricted numeric format (`Nw`) for displaying data. See [[SPSS/DataFormats#Print_Formats|here]] for further information. The default format, which will be applied to any implicitly declared variables, is `F8.2`. === Date and Time Data === Dates are stored as the number of seconds from midnight, October 14, 1582 to midnight on the specified date. Generally the `DATE10` format is used for displaying data. Datetimes are stored as the number of seconds to the specified time on the specified date. Generally the `DATETIME20` format is used for displaying data. Times are stored as the number of seconds. This ''can'' be imagined as the number of seconds from midnight to the specified time, but that is not a ''necessary'' construct. Generally the `TIME8` format is used for displaying data. Keep in mind that 1 day = 60 (seconds) * 60 (minutes) * 24 (hours) = 86400 seconds. For more information about date and time formats, see [[SPSS/DataFormats#Print_Formats|here]]. See [[SPSS/DatetimeFunctions|here]] for the built-in library of date and time functions. ---- == String Data == String data is stored at a fixed length. A string variable can only be explicitly declared, as by the [[SPSS/String|STRING]] command. Generally, string data uses the string format (`Aw` where `w` is the field width) for displaying data. See [[SPSS/DataFormats#Print_Formats|here]] for further information. See [[SPSS/StringFunctions|here]] for the built-in library of string functions. === String Literals === String literals are declared by wrapping a string value in quotes, either single (`'`) or double (`"`). Quote marks within strings can be handled in one of two ways: either use the opposite quote mark to wrap the string, or escape the quote mark by doubling it. {{{ variable label var1 "Say ""Hello!""". variable label var2 'Don''t say "Goodbye!"'. }}} |
SPSS Data Types
SPSS exposes numeric and string data types.
Certain specialized forms of data are handled by formats that impact visualization and export, not storage. The primary example of this is date and time data.
Numeric Data
Numeric data is stored as double-precision floating point.
Generally, numeric data uses either a numeric format (Fw.d where w is the field width and d is the number of visible decimal places) or a restricted numeric format (Nw) for displaying data. See here for further information. The default format, which will be applied to any implicitly declared variables, is F8.2.
Date and Time Data
Dates are stored as the number of seconds from midnight, October 14, 1582 to midnight on the specified date. Generally the DATE10 format is used for displaying data.
Datetimes are stored as the number of seconds to the specified time on the specified date. Generally the DATETIME20 format is used for displaying data.
Times are stored as the number of seconds. This can be imagined as the number of seconds from midnight to the specified time, but that is not a necessary construct. Generally the TIME8 format is used for displaying data.
Keep in mind that 1 day = 60 (seconds) * 60 (minutes) * 24 (hours) = 86400 seconds.
For more information about date and time formats, see here.
See here for the built-in library of date and time functions.
String Data
String data is stored at a fixed length.
A string variable can only be explicitly declared, as by the STRING command.
Generally, string data uses the string format (Aw where w is the field width) for displaying data. See here for further information.
See here for the built-in library of string functions.
String Literals
String literals are declared by wrapping a string value in quotes, either single (') or double (").
Quote marks within strings can be handled in one of two ways: either use the opposite quote mark to wrap the string, or escape the quote mark by doubling it.
variable label var1 "Say ""Hello!""". variable label var2 'Don''t say "Goodbye!"'.