topic How do you import a sas7bdat file? in New SAS User

How do you import a sas7bdat file?

lemon1 — Wed, 20 Feb 2019 18:21:23 GMT

I am trying to access data from a sas7bdat file to do some analysis on it. This is the data file: https://github.com/JackStat/6003Data/blob/master/detroit.sas7bdat

I have searched this board for other .sas7bdat file questions and tried to copy their code, but it does not work for me.

Here is the code I have:

libname detData "\\csbs-cfs1.csbs.utah.edu\home_i\u1052325\Downloads\detroit.sas7bdat";
data inventory;
set detData.inventory;
run;

The log says this:

134 libname detData "\\csbs-cfs1.csbs.utah.edu\home_i\u1052325\Downloads\detroit.sas7bdat";
ERROR: Library DETDATA is not in a valid format for access method RANDOM.
ERROR: Error in the LIBNAME statement.
135 data inventory;
136 set detData.inventory;
ERROR: Libref DETDATA is not assigned.
137 run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.INVENTORY may be incomplete. When this step was stopped there were 0
observations and 0 variables.
WARNING: Data set WORK.INVENTORY was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Re: How do you import a sas7bdat file?

Kurt_Bremser — Wed, 20 Feb 2019 19:00:14 GMT

You do not import a .sas7bdat file, as it already is a SAS dataset. You only need to define a libname to the directory where the file is located in order to access it.

Re: How do you import a sas7bdat file?

Astounding — Wed, 20 Feb 2019 19:47:39 GMT

The LIBNAME statement should reference a folder, not a file. Your LIBNAME statement provides too much information:

libname detData "\\csbs-cfs1.csbs.utah.edu\home_i\u1052325\Downloads\detroit.sas7bdat";

Instead, cut it down to the path to the folder that holds the data:

libname detData "\\csbs-cfs1.csbs.utah.edu\home_i\u1052325\Downloads";

After that, you would refer to the SAS data set as:

detData.detroit

So it's a two-part name, that references both the LIBNAME and the name of the .sas7bdat file. In context, perhaps:

data inventory;

set detData.detroit;

run;