topic Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition in SAS Studio

How do I import ".sas7bdat" file by creating a library in SAS University Edition

shihabur — Fri, 14 Oct 2016 01:20:51 GMT

Hello everyone, SAS beginner here. Using SAS University Edition from a Mac. I am trying to import a file "inventory.sas7bdat" by creating a library. I have used this piece of code in windows while using SAS from server. But not being able to make it work here.

Here's my code:

LIBNAME abcd "/folders/myfolders";
data abcd.inventory;
infile "/folders/myfolders/inventory.sas7bdat";
proc print data = abcd.inventory;

I am getting this error message -

58 infile "/folders/myfolders/inventory.sas7bdat";

ERROR: File is in use, /folders/myfolders/inventory.sas7bdat.

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set ABCD.INVENTORY may be incomplete. When this step was stopped there were 0 observations and 0 variables.

WARNING: Data set ABCD.INVENTORY was not replaced because this step was stopped.

For your information:

- I am using virtual box VM

-i have checked the shared folder and the data file is inside the folder

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

Reeza — Fri, 14 Oct 2016 02:26:30 GMT

You don't import a sas file per se.

You reference it using libname.data_name.

Libname abcd ...

Data inventory; * dataset to be created;

set abcd.inventory; *data being used in data step;

run;

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

Reeza — Fri, 14 Oct 2016 02:27:09 GMT

That code shouldn't have worked regardless of system.

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

shihabur — Fri, 14 Oct 2016 02:39:58 GMT

I ran the code:

Libname abcd '/folders/myfolders';
Data inventory;
set abcd.inventory;
run;

It shows an error message saying "Error: the table work.inventory can not be opened because it does not contain any columns"

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

Reeza — Fri, 14 Oct 2016 02:45:12 GMT

Yeah, your initial attempts may have wrecked your original dataset because you were trying to create that dataset (abcd.invemtory)

Try replacing the dataset and running the code again.

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

Shmuel — Fri, 14 Oct 2016 06:19:22 GMT

What you realy need is:

On windows SAS system run the code:

filename cpt '...enter path and filename';

proc cport data= <libref>.inventory file=cpt; run;

then copy the above file to your MAC and run next code on MAC system:

filenmae cpt ' ... path and filename on MAC ';

proc cimport infile=cpt lib=WORK; run; /* or change work to any libref preffered */

You may need check syntax of PROC CPORT / PROC CIMPORT to addapt to your systems.

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

Kurt_Bremser — Fri, 14 Oct 2016 06:21:16 GMT

From where did you obtain your file inventory.sas7bdat?

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

ballardw — Fri, 14 Oct 2016 15:10:08 GMT

When you used this code:

data abcd.inventory;
infile "/folders/myfolders/inventory.sas7bdat";

both lines refer to the same system file. That was the cause of the

ERROR: File is in use, /folders/myfolders/inventory.sas7bdat.

While SAS will allow the the use of

data abcd.inventory;

SET abcd.inventory;

That is a special case because SAS understands what it is doing with two references to the same data set (I strongly recommend not using that code construct until you have much experience with SAS). With the INFILE statement the file is in effect assumed to be a "foreign" or non-SAS file and actually a text file for reading.

You didn't show the LOG for the proc print statement. Did that execute? What was the result.

You don't show the log for the PROC Print. Did it actually print okay. It should have as the previous DATA step di

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

ballardw — Fri, 14 Oct 2016 15:17:38 GMT

@shihabur wrote:

Libname abcd '/folders/myfolders';
Data inventory;
set abcd.inventory;
run;

It shows an error message saying "Error: the table work.inventory can not be opened because it does not contain any columns"

Note that the log behind the Studio message explains to an extent what happened. You have a basically empty set.

As an example look at this code:

Data work.junk;

run;

Does not reference any external data, does not have any code but will generate the message:

NOTE: The data set WORK.JUNK has 1 observations and 0 variables.

Apparently you either had an empty set to begin with or the file has been corrupted. Time to find a backup.

Also, note that in your first post there is a message that your ABCD library also refers to DATALIB. While there are some reasons for having multiple libraries point to the same location you really shouldn't be attempting any of them at this stage of learning. Use the existing DATALIB or create a subfolder such as /folders/myfolders/project and reference that for your data related to a project. One of the purposes of a library is to organize things that belong together. So you may have all of the datasets related to your inventory project in one library and party planning in a different library.

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

shihabur — Fri, 14 Oct 2016 15:58:33 GMT

I tried it with a different data set which I just downloaded "survey.sas7bdat" and saved it in myFolder. The dataset is fine because I can open it by clicking in SAS UE.

Still getting Error: ERROR: File DEF.SURVEY.DATA does not exist.

Libname def '/folders/myfolders';
Data survey;
set def.survey;
run;

I have even tried using a different path like /folders/myfolders/myData . But no use. Don't know if I am doing something terribly dumb !

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

shihabur — Fri, 14 Oct 2016 16:08:30 GMT

Hi, Thanks for detailed response. I understand that my situation is a similar to where there would be an empty/corrupt file. I just downloaded a different file "survey.sas7bdat" and tried again but only to get same result. I opened the file by clicking and it seems fine as you can see in the attached image.

Secondly, I think I have made this mistake of creating too many libraries, probably i should have sticked to only one instead of creating a new one everytime I am running the code. But could that be reason for my problem ?

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

shihabur — Fri, 14 Oct 2016 16:15:43 GMT

There is a bunch of dataset to practice on. I made sure that they are not corrupted or broken as other people are also using it. In fact I used a completely different data set again just to make sure the problem is not with one file. But getting the same error.

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

ballardw — Fri, 14 Oct 2016 16:30:04 GMT

What code did you run and what do you mean by "same result"? if you ran a data step agains the survey data set DON'T.

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

shihabur — Fri, 14 Oct 2016 17:11:16 GMT

I ran this code:

Libname def '/folders/myFolders';
Data survey;
set def.survey;
run;

And got this error:

ERROR: File DEF.SURVEY.DATA does not exist.

What do I do now ?

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

shihabur — Fri, 14 Oct 2016 17:41:05 GMT

This was correct. It wasn't working because of file path mistake. Now it works fine.

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

Reeza — Fri, 14 Oct 2016 17:41:28 GMT

Assign your library.

library test '/folders/myfolders/';

proc datasets lib=test;

run;quit;

Post the output from the code above please.

Is this a new install of SAS UE?

Can you show the set up of myfolders in your folder as well?

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

shihabur — Fri, 14 Oct 2016 17:43:10 GMT

I have already selected the solution. I was making a file path name mistake. But nonetheless I have learnt from your detailed comment too. Thanks again.

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

shihabur — Fri, 14 Oct 2016 17:49:18 GMT

I installed UE 2 months back. I am attaching the image of how the shared folder looks like now. Turns out as of this moment the correct file path is "/folders/myshortcuts/myFolders"

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

Reeza — Fri, 14 Oct 2016 17:51:33 GMT

This is because you used myFolders vs myfolders. SAS UE is on unix and is case sensitive. If you create the folder (myfolders) as noted in the instructions you're original code would have worked.

In general, SAS UE examples tend to rely on myfolders so I would consider creating that folder and adding it correctly.

Re: How do I import ".sas7bdat" file by creating a library in SAS University Edition

shihabur — Fri, 14 Oct 2016 17:54:15 GMT

I ran the piece of code you asked to run and this is the log.