Hi All, While going through The Little SAS Book, it is mentioned that if we are reading raw data file using list input then in case of character data there shouldn't be any embedded space. My question here is that this limitation is applicable only when the delimiter is blank(default delimiter,In this case we have to use option dsd to read character data with embedded space). I am having a data set where values in raw data file are comma seperated and in character data there is embedded space. But when i am trying to read the data with the following code,it is generating correct output. data sales; infile 'E:\SAS data\Data\base data set\lwprg1\sales.csv' dlm = ','; length Job_Designation $ 20; input ID First_Name $ Last_Name $ Gender $ Salary Job_Designation $ Country $ Birth_Date:Date9. Hire_date:ddmmyy10.; run; Please let me know whether my understanding is correct or not and help me in clearing my confusion. Attaching screenshot of sample raw data file(Embedded space data has been highlighted).
... View more