are you trying to read it in with quotation marks as part of the value. if yes, you need to use ~ modifier. data want; infile datalines dlm=',' dsd; input PatID : $9. EncounterID :$16. ADate :MMDDYY10. Provider: $16. EncType ~ :$4. PX_Codetype : $2. OrigPX :$7.; format ADate MMDDYY10.; datalines; PATID1,ENC1,11/07/2010,710826,'IP',3813,C4,, PATID1,ENC2,02/08/2011,710826,'IP',3813,C4,, PATID2,ENC1,11/02/2010,710826,'ED',4291,C4,, PATID2,ENC2,12/19/2010,710826,'IP',3813,C4,, PATID2,ENC3,02/27/2011,710826,'IP',3813,C4,, PATID3,ENC1,09/28/2010,710826,'ED',4291,C4,, PATID3,ENC2,11/04/2010,710826,'IP',3813,C4,, PATID3,ENC3,12/19/2010,710826,'AV',3812,C4,, PATID3,ENC4,03/04/2011,710826,'AV',3813,C4,, ; run; proc print ;run;
... View more