topic Re: importing data in SAS Studio

importing data

timgpp — Sun, 11 Sep 2016 01:00:33 GMT

I am trying to import data from a csv file into SAS studio. When I run the program, the notes tell me that there were zero observations and two variables. There are two variables, but there should be 39. What am I doing wrong? I have attached my code, as well as a screen shot of my csv file. Thank you for your help.

data CitynameSTinSAS;
infile "/folders/myfolders/CitynameSTforSAS.csv" dlm="," firstobs=2;
input Temp Met;
run;

Tim Muhich

Re: importing data

Reeza — Sun, 11 Sep 2016 01:07:20 GMT

You need to list your variables in the input statement. Since you only lost two variables that's all it reads.

Re: importing data

timgpp — Sun, 11 Sep 2016 13:10:09 GMT

Thank you for replying. I thought I had listed my variables; I only have two. It is just not bringing the data along with them. What am I missing in that statement to bring all of the temperature and metabolism data along with the variable names?

Thank you again for your time,

Tim

Re: importing data

Shmuel — Sun, 11 Sep 2016 13:37:37 GMT

Adding the option TRUNCOVER in infile statement, may help:

data CitynameSTinSAS;
infile "/folders/myfolders/CitynameSTforSAS.csv" dlm="," firstobs=2 TRUNCOVER;
input Temp Met;
run;

Re: importing data

timgpp — Sun, 11 Sep 2016 13:50:32 GMT

Maybe there is something wrong with my csv file then. When I tried your suggestion Shmuel, I got the following message

Re: importing data

Shmuel — Sun, 11 Sep 2016 14:08:59 GMT

Can you open your CSV file with a text editor and upload a screenshot of it ?

Are you sure that FIRSTOBS should be 2 ?

Re: importing data

Tom — Sun, 11 Sep 2016 14:34:25 GMT

Your error message is saying that there 221 bytes, but no records in file past the first line. Perhaps your data is all on one line?

Try just telling SAS to read the file and show you want is in it.

data _null_;
  infile '/folders/myfolders/CitynamesSTforSAS.csv' ;
  input;
  list;
run;

Then you can look and see what is there.

Perhaps the data is just all on one line?

data want;
  infile '/folders/myfolders/CitynamesSTforSAS.csv' dsd;
  input Temp Met @@;
run;

Re: importing data

Reeza — Sun, 11 Sep 2016 20:27:32 GMT

@timgpp In your first post you included two screenshots of your error message but not a screenshot of your CSV.

Include either the CSV or at the minimum a screenshot for help. It's likely an easy solution.

Re: importing data

timgpp — Tue, 13 Sep 2016 12:29:22 GMT

Thank you all for your help. You were right. It was the CSV file. Only the first line of the Excel sheet saved for some reason ( Thanks Tom for the tip about 221 bytes). I resaved the file as a CSV and it contained all the data. Life is good.