I am loading data from a txt file into SAS using List Input, it has “,”(comma) as a delimiter. Now, the issue is there is two or more consecutive delimiters and due to this, I am not able to import it correctly. Ideally, these are considered as missing value for variables.
123,Anil,Sales,34567 345,,Admin,23456 456,,,32456
I am using below code to perform this:
Data Test; infile 'C:\Users\rahul\Desktop\test.txt' dlm=','; Input EMP_Code Name$ Dept$ Salary; Run;
Output of above code is as below, which is not correct.
Can you please help me to import this data and have missing values against consecutive delimiters?