Dear community, I am studying the basic data steps and still have confusion about using dsd, missover, truncover and colon modifier. Could you please be so kind to explain to me what went wrong with my codes when reading in raw data? /* 1 what’s wrong with my codes? */ data Customer1; infile datalines; input ID $9. Name $10. Phone $14. Date mmddyy8. Price dollar8.2; format Date mmddyy10.; datalines; 542857845 Susan (510)893-2541 10/10/08 $2.50 754857485 David (415)785-9685 01/12/05 $12.2 854748578 Catherine (408)254-6523 04/03/07 $1,009 ; /* sample codes provided */ data test1; infile datalines; input SSN $9. Name $11-20 Phone $21-33 +1 Reg MMDDYY8. Amount Dollar8. ; format Reg MMDDYY10. ; datalines; 542857845 Susan (510)893-2541 10/10/08 $2.50 754857485 David (415)785-9685 01/12/05 $12.2 854748578 Catherine (408)254-6523 04/03/07 $1,009 ; run; /* 2 what’s wrong with my codes? */ data Customer2; infile datalines dsd truncover; input Name: $10. ID $9. Phone $14. Date mmddyy8. Price dollar9.2; format Date mmddyy10.; datalines; Susan 542857845 (510)893-2541 10-10-08 $2.50 David 754857485 (415)785-9685 1-12-05 $12.2 Catherine 854748578 (408)254-6523 4-3-07 $1,009 ; Many thanks! best, Lil
... View more