Hi All, I'm trying to write a SAS which is 'Comma' separated file and not properly alligned. In third & fifith records (or lines) there is a extra comma in the City (Ma,dison & flo,rida). When i execute the below code, under 'GENDER' city name 'dison' & 'rida' values getting updated. Can anyone please help me how to write the code to get the correct values under correct column? data address2; infile datalines dsd; length city $10; input name $ age city $ gender $; datalines; Steve,32,Monona,M Tom,44,Milwaukee,M Deb,23,Ma,dison,F bob,24,Texas,M Harry,43,flo,rida,M run;
... View more