topic Re: Load sas7bdat file on sas linus system in New SAS User

Load sas7bdat file on sas linus system

surfsas — Sun, 01 Oct 2023 23:13:50 GMT

Hi,

I am using SAS Linux version for the first time. I am trying to load sas7bdat file in my work library, but it is failing every time. PROC IMPORT is not working, import from File menu also failed.

What is the ideal way to load the file.

Thank you.

Note- The SAS dataset does open/load in SAS Studio.

Re: Load sas7bdat file on sas linus system

SASKiwi — Sun, 01 Oct 2023 23:32:35 GMT

You don't use PROC IMPORT to load a sas7bdat file. It's already a SAS dataset so you don't need to import it, just try reading it:

data want;
  set '/user/myuser/mysasdata.sas7bdat';
run;

Beware, if your sas7bdat file was NOT created on linux you may still have problems reading it.

Re: Load sas7bdat file on sas linus system

ballardw — Sun, 01 Oct 2023 23:37:22 GMT

If the file is has an extension of sas7bdat it is already a SAS data set and should be used directly.

You can make a library pointing to the location the file is stored

libname mylib "root/myfolders/folderwherethebdatfileis";

Open the library and you should see your data set there.

Reference the data set for procedures using MYLIB.datasetname.

Or you can use an explicit path to the file but that gets cumbersome quickly:

proc print data="root/myfolders/folderwherethebdatfileis/nameofbdatefile.sas7bdat";
run;

If the file "doesn't load" in SAS Studio then tell us how you attempted to load it and show us the log from what you attempted.

@surfsas wrote:

Hi,

I am using SAS Linux version for the first time. I am trying to load sas7bdat file in my work library, but it is failing every time. PROC IMPORT is not working, import from File menu also failed.

What is the ideal way to load the file.

Thank you.

Note- The SAS dataset does open/load in SAS Studio.