You can use the DSD option in the INFILE statement to correctly read the raw data. The DSD option changes how SAS treats delimiters when list input is used. Specifically,the DSD option sets the default delimiter to a comma treats two consecutive delimiters as a missing value removes quotation marks from values
• You can use the DSD option in the INFILE statement to correctly read the raw data. The DSD option changes how SAS treats delimiters when list input is used. Specifically, the DSD option • sets the default delimiter to a comma • treats two consecutive delimiters as a missing value • removes quotation marks from values
·data perm.survey; infile credit dsd; input Gender Age Bankcard FreqBank Deptcard FreqDept; run; Obs gender age bankcard freqbank deptcard freqdept 1 male 1 8 0 0 2 female 29 3 14 5 10 3 female 34 2 10 3 4 male 35 2 12 4 8 5 female 36 4 16 3 7
• data perm.survey; infile credit dsd; input Gender $ Age Bankcard FreqBank Deptcard FreqDept; run;