topic Re: CSV file to SAS import issues in SAS Programming

CSV file to SAS import issues

Wub_SAS — Tue, 16 May 2023 23:00:54 GMT

Hi, I need to import a csv data (sample observations and variables attached) to SAS. I am using the below code and imported the data but couldn't solve a few issues I am having:

1. SAS read many of the character variables as single length (screenshot of the out put attached) which I couldn't increase applying informat, attrib or length functions.

2. Although the dataset is created with all the above issues, I am still getting error message in the log saying: "ERROR: Import unsuccessful. See SAS Log for details."

proc import datafile="C:\Sample3.csv"
dbms=csv  
out=Sample3; 
getnames=yes;
run;

Re: CSV file to SAS import issues

Reeza — Tue, 16 May 2023 20:31:39 GMT

This includes your actual data, did you intend to include that?

Re: CSV file to SAS import issues

ballardw — Tue, 16 May 2023 21:19:51 GMT

By default Proc Import only examines 20 rows of data to set properties. If a "column" doesn't have any values in the first 20 rows then SAS sets a width of 1 and makes the column character.

Use the GUESSINROWS statement to tell SAS how many rows to read to set properties.

proc import datafile="C:\Sample3.csv"
dbms=csv  
out=Sample3; 
getnames=yes;
guessingrows=max;
run;

Better if you have a an actual description of the file contents is to use that information to write a data step.

Import will attempt to treat a field with all digits as a numeric value which means that significant leading zeroes, such as appear in account information in many sources, get discarded. When Proc Import "reads" different data files that should have the same properties you can get different lengths and sometimes variable types which leads to problems when combining data sets.

Re: CSV file to SAS import issues

Tom — Tue, 16 May 2023 21:51:43 GMT

Make to to tell SAS to check the WHOLE file before determining the type/length to GUESS for the variables.

Add this statement to the PROC IMPORT step.

guessingrows=max;

For your data step you are telling SAS to use COMMA as the delimiter.

data WORK.SAMPLE3;
  infile datalines dsd truncover;

But your in-line data lines do NOT have commas as the delimiter.

In fact they don't appear to have any delimiter. If the delimiter is a TAB then DO NOT use in-line data. Normal SAS will replace the tabs with spaces when you submit the code. Or is the data in fixed column locations instead? In that case you need to use a different style of INPUT statement.

Re: CSV file to SAS import issues

Wub_SAS — Tue, 16 May 2023 22:20:52 GMT

Thank you @Reeza. No, I picked the wrong dataset. I contacted asked to get help for this post to be deleted so that can re-post with the correct sample dataset.

Re: CSV file to SAS import issues

Reeza — Tue, 16 May 2023 23:01:30 GMT

I've deleted your code/data. You can feel free to edit your posts yourself, click the three lines beside the post and edit.

Re: CSV file to SAS import issues

Wub_SAS — Wed, 17 May 2023 00:25:31 GMT

Thank you for the help! @Reeza.

Re: CSV file to SAS import issues

Wub_SAS — Wed, 17 May 2023 00:26:33 GMT

Thanks a lot! That was very helpful.

Re: CSV file to SAS import issues

ChrisHemedinger — Wed, 17 May 2023 14:31:30 GMT

Posters can edit their own posts for a short time, after which they need to ask for moderator help. This helps to keep the integrity of the question after others reply.

Re: CSV file to SAS import issues

Wub_SAS — Wed, 17 May 2023 22:18:49 GMT

Ok, thank you for the note @ChrisHemedinger; that will be helpful for future posts.