topic How to read data set downloaded to SAS 9.4? in New SAS User

How to read data set downloaded to SAS 9.4?

nmy15 — Mon, 03 Dec 2018 00:45:21 GMT

I use SAS 9.4 and am trying to import a file with sas7bdat. I have the file and I've done this before but every time I try to import it, it comes up showing 1 observation and 0 variables. There should be 12 observations and 4 variables. This is what I put in:

LIBNAME quiz "C:\Users\OneDrive\Desktop\BIST0535";
DATA quiz.sbp_2;
RUN;

Now sbp_2 has 12 observations and 4 variables, but this is the answer I got out:

NOTE: The data set QUIZ.SBP_2 has 1 observations and 0 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.03 seconds

but it's the correct file name and everything and I can't figure out why it is erasing my variables. Please Help!

Re: How to read data set downloaded to SAS 9.4?

ChrisBrooks — Mon, 03 Dec 2018 01:25:07 GMT

If you already have a sas7bdat file then that is already a SAS data set - you don't need to "import" it at all.

If you want to copy it to another data set then you need a SET statement; what's happening in your code is that, assuming the original file is called sbp_2 then you're overwriting it with a blank file because of the absence of a SET statement.

Re: How to read data set downloaded to SAS 9.4?

r_behata — Mon, 03 Dec 2018 01:32:19 GMT

Hello @nmy15 welcome to the sas community.

Please follow the instructions in this video on how to read external files into sas.

https://video.sas.com/detail/video/4573016758001/creating-a-sas-table-from-a-csv-file

Re: How to read data set downloaded to SAS 9.4?

Reeza — Mon, 03 Dec 2018 03:31:52 GMT

If you already ran this, you destroyed your data set and first need to recreate it before proceeding. This means re-downloading the file from where you originally got it or restoring it somehow.

Some concepts for you:

1. Libname - think of this as a path to your SAS data sets

A data step should be as follows:

data OutputDataName;
set InputDataName;

run;

Note that since you used the code data quiz.sbp_2 instead of in the SET statement you accidentally overwrote it. So once you actually recreate it you'll be good to go.

libname quiz 'path to folder';

data quiz;
set quiz.sbp_2;
run;

proc print data=quiz;
run;

@nmy15 wrote:

I use SAS 9.4 and am trying to import a file with sas7bdat. I have the file and I've done this before but every time I try to import it, it comes up showing 1 observation and 0 variables. There should be 12 observations and 4 variables. This is what I put in:
LIBNAME quiz "C:\Users\OneDrive\Desktop\BIST0535";
DATA quiz.sbp_2;
RUN;
Now sbp_2 has 12 observations and 4 variables, but this is the answer I got out:
NOTE: The data set QUIZ.SBP_2 has 1 observations and 0 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.03 seconds 
but it's the correct file name and everything and I can't figure out why it is erasing my variables. Please Help!

Re: How to read data set downloaded to SAS 9.4?

nmy15 — Thu, 06 Dec 2018 22:09:43 GMT

Thank you so much!