I think a mixed of dsd and colon modifier along with LRECL will help you solve the problem. Here is what I have written for you for the dataset you mentioned. I think you can read any address line with a embeded comma with this code. Please let me know if you have any questions. data mydata; infile "C:\mydata.csv" dlm = "," /*Specifying the delimeter*/ dsd /*reading any missing value within line*/ missover /*Reading missing value at the end of the line*/ LRECL= 32760 /*changing the default length to 32K*/ firstobs=2 /*reading the data lines only*/ ; input name :$30. /*specifiying colon modifier for reading data with comma*/ address :$30. phone :$30.; run;
... View more