DELIMITER= or SEPARATOR= data field delimiters = " ", fixed fields

It is often convenient to organize your data with delimiters, such as commas, semi-colons or spaces, rather than in fixed column positions. However, often the delimiter (a Tab, space or comma) only takes one column position. In which case, it may be easier to include it in the CODES= or use MFORMS= or FORMAT=.

 

To check that your data file has decoded properly, look at RFILE=

 

To do this, specify the following command DELIMITER= value (or SEPARATOR= value). This value is the separator.

 

Examples: DELIMITER= " "  fixed-field values

 DELIMITER= ","  comma-separated values CSV. The , must be ","

 DELIMITER=BLANK blank-separated values

or DELIMITER=SPACE space-separated values

 DELIMITER=TAB tab-separated values

 DELIMITER=";"  semi-colon separated values. The ; must be ";", otherwise it is treated as a comment.

 

When decoding delimited values, leading and trailing blanks, and leading and trailing quotation marks, " " and ' ' in each value field are ignored. Responses are left-aligned, and sized according to XWIDE=.

 

For NAME1= and ITEM1=, specify the value number in the data line, starting with 1 as the leftmost value. FORMAT= does not apply to this data design.

 

Combine your person name and demographic information into one field that is to be referenced by NAME1=.

 

Example 1 of a data line:

 

; the following is ONE data line:

 

 "01"; 02; "01"; "01"; "01"; 00; 02; 00; "01"; 02; 02; 02; 02; 00; 02; "01"; "01"; 02; 02 ; 00; 02; "01"; 00; 02; 00; ROSSNER, MARC DANIEL

 

;which decodes as:

 

01020101010002000102020202000201010202000201000200ROSSNER, MARC DANIEL

 

 ITEM1=1     ; item responses start in first field

 NI=25       ; there are 25 responses, i.e., 25 response fields

 NAME1=26    ; the person name is in the 26th field

 DELIMITER = ";" ; the field delimiters are semi-colons

 XWIDE=2     ; values are right-aligned, 2 characters wide.

 CODES=000102 ; the valid codes.

 NAMLEN=20   ; override standard person name length of 30 characters.

 

Example 2 of a data line:

 

; the following is ONE data line:

 

ROSSNER - MARC DANIEL, "01", 02 , "01", "01", "01", 00, 02, 00, "01", 02, 02, 02, 02, 00, 02, "01", "01", 02, 02, 00, 02, "01", 00, 02, 00

 

;which decodes as:

 

01020101010002000102020202000201010202000201000200ROSSNER - MARC DANIEL

 

 ITEM1=2     ; item responses start in second field

 NI=25       ; there are 25 responses, i.e., 25 response fields

 NAME1=1     ; the person name is in the 1st field

 DELIMITER = "," ; the field delimiters are commas (so no commas in names)

 XWIDE=2     ; values are right-aligned, 2 characters wide.

 CODES=000102 ; the valid codes

 NAMLEN=20   ; override standard person name length of 30 characters.

 

Example: Here is the data file, "Book1.txt"

 fred,1,0,1,0

 george,0,1,0,1

 

 Here is the control file:

 name1=1 ; first field

 item1=2 ; second field

 ni=4  ; 4 fields

 data=book1.txt

 codes=01

 delimiter = ","

 &END

 looking

 viewing

 peeking

 seeking

 END LABELS

 

 Here is the reformatted file from the Edit Pull-Down menu: View Delimiter File:

 1010fred

 0101george

 

Suggestion:

If you data file can be conveniently organized in columns:

 fred  ,1,0,1,0

 george,0,1,0,1

 

then process the data file as fixed width fields

 NAME1 = 1 ; start of person label "fred"

 NAMELENGTH = 6 ; up to first comma

 ITEM1 = 8  ; first column of numbers

 XWIDE = 2 ; number + comma

 CODES = "0,1,0 1 " ; the data codes "0 1 " are for the last codes on the line.

 

this will then analyze the data as a standard fixed-column rectangular data matrix.