topic Re: reading from csv to sas dataset in SAS Programming

reading from csv to sas dataset

Aexor — Thu, 03 Feb 2022 11:08:33 GMT

How to read value like this

03/2020 - sunday check 3x75g

This value is present in csv file along with many other variables values. This particular column (values like 03/2020 - sunday check 3x75g) which is as mentioned is coming as blank . Please advise

Re: reading from csv to sas dataset

andreas_lds — Thu, 03 Feb 2022 11:11:13 GMT

Please post a complete line of the csv file using "insert code" and show the code you have used to read the file.

Re: reading from csv to sas dataset

Reeza — Thu, 03 Feb 2022 15:52:47 GMT

You will need to read it in as a single character variable initially and then parse out the components if you'd like.

If you read the file using PROC IMPORT try setting GUESSINGROWS=MAX to force SAS to scan the entire file before it assigns types and that may fix part of the issue for you.
If you're reading in using INPUT/INFILE then you need to ensure the informat is set to character with an appropriate length.