topic Re: SAS University Studio import data size issue in SAS Studio

SAS University Studio import data size issue

Xingr_92 — Wed, 29 Aug 2018 18:34:23 GMT

Hi,

I am trying to import BRFSS dataset into SAS Studio. Since 2015 dataset is 1.17GB, I was not sure whether SAS Studio University would be able to take the dataset.

LIBNAME BRFSS '/folders/myfolders/BRFSS';
FILENAME IN1 '/folders/myfolders/BRFSS/LLCP2015.XPT ';
PROC XCOPY IN=IN1 OUT=BRFSS IMPORT;
RUN;

After tried several times, the physical file on my harddisk is 1.17GB locally but the size is 0 bytes in SAS Studio when I checked the properties.

Please advise me how to resolve this issue so that the data can be successfully loaded into the library. The Screenshots would provide additional information.

Thanks a lot!

Best,

Re: SAS University Studio import data size issue

ballardw — Wed, 29 Aug 2018 17:55:07 GMT

Which file are you attempting to import?

Is the first block of code just an example you are following or what?

It looks like you may have accidently overwritten you file using it as the destination for something and need to get another copy of the original file.

Re: SAS University Studio import data size issue

Kurt_Bremser — Wed, 29 Aug 2018 17:56:23 GMT

If you set up UE correctly, it should be /folders/myfolder (note the missing trailing s).

Re: SAS University Studio import data size issue

Reeza — Wed, 29 Aug 2018 18:10:50 GMT

Your file type is ssp? What type of information are you expecting in that file. Not that google is always reliable but its indicating this would be an image file not a text or open file type.

Re: SAS University Studio import data size issue

Xingr_92 — Wed, 29 Aug 2018 18:30:50 GMT

Hi,

Sorry I did not enclose the correct code I want to use.

The actual screenshot after I ran the code is attached as follows:

and the code is

LIBNAME BRFSS'/folders/myfolders/BRFSS';
FILENAME IN1 '/folders/myfolders/BRFSS/LLCP2015.XPT';
PROC XCOPY IN=IN1 OUT=BRFSS IMPORT;
RUN;

Hope that information helps you to offer support.

Best,

Re: SAS University Studio import data size issue

Reeza — Wed, 29 Aug 2018 18:43:14 GMT

I’m going to guess the path is wrong. Go to the servers file and folder pane. Find your XPT file and right click, select properties. It will have the path there.

Re: SAS University Studio import data size issue

Xingr_92 — Wed, 29 Aug 2018 18:48:28 GMT

This is the file property I have in SAS Studio. I copied the file path via pulling out the property. However, interestingly, the size of my file is not correct. It should be 1.17GB instead of 0 bytes.

Re: SAS University Studio import data size issue

Reeza — Wed, 29 Aug 2018 19:31:20 GMT

Then I think the comment someone made earlier may be true. You may have inadvertently erased the file. Can you recreate it and try again?