text file: REC_NUM,FIRST_NM,LAST_NM,COMPANY_NM,AGE,GENDER 1,JOHN,SMITH,,36,M 2,JERRY,JONES,,M 3,JASON,JACKSON,COMPANY A,45,M 4,,,"COMPANY C,INC", 5,HOLLY,SAMPSON,,76,F 6,,,COMPANY B,, 7,ALICE,COOPER,, 8,GRACE,JOHNSON,,33,F One of the code attempts: DATA EXAMP ; INFILE "Example File.txt" DELIMITER = ',' DSD TRUNCOVER FIRSTOBS=2 ; INFORMAT RECORD_NUM BEST1.; INFORMAT FIRST_NM $CHAR20.; INFORMAT LAST_NM $CHAR20.; INFORMAT COMPANY_NM $CHAR20.; INFORMAT AGE BEST2.; INFORMAT GENDER $CHAR1.; FORMAT RECORD_NUM BEST1.; FORMAT FIRST_NM $CHAR20.; FORMAT LAST_NM $CHAR20.; FORMAT COMPANY_NM $CHAR20.; FORMAT AGE BEST2.; FORMAT GENDER $CHAR1.; INPUT RECORD_NUM FIRST_NM $ LAST_NM $ COMPANY_NM $ AGE GENDER $ ; NREC =_N_; ERR = _ERROR_; RUN;
... View more