Date:         Wed, 14 Jul 2010 17:17:35 -0400
Reply-To:     Subscribe Sas-L Jkr <jayakumarreddy@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Subscribe Sas-L Jkr <jayakumarreddy@GMAIL.COM>
Subject:      READ from TXT - INFILE

hi
i have to read a txt file into two columns into SAS.

DATA ICD10.I10cm_desc2010;
 INFILE "F:\projects\0057_Jul10\ICD10Diagnoses GEMs\I10cm_desc2010.txt";
 informat @1 ICD10CM $7. @9 Description $250.;
run;

This is how the text file looks

A000    Cholera due to Vibrio cholerae 01, biovar cholerae
A001    Cholera due to Vibrio cholerae 01, biovar eltor
A009    Cholera, unspecified
A0100   Typhoid fever, unspecified
A0101   Typhoid meningitis
A0102   Typhoid fever with heart involvement

the second column truncates after it encounters a space in the txt file. I
want the entire string to be read into the second column

thanks
JKR