BookmarkSubscribeRSS Feed
Xingr_92
Calcite | Level 5

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.

 

Screen Shot 2018-08-29 at 2.33.12 PM.pngScreen Shot 2018-08-29 at 2.33.23 PM.png

 

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,

R

Screen Shot 2018-08-29 at 1.35.44 PM.pngScreen Shot 2018-08-29 at 1.35.58 PM.png

7 REPLIES 7
ballardw
Super User

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.

 

 

Xingr_92
Calcite | Level 5

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:

Screen Shot 2018-08-29 at 2.28.27 PM.png

 

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,

R

Reeza
Super User
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.
Xingr_92
Calcite | Level 5

Screen Shot 2018-08-29 at 2.46.48 PM.png

 

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.

Reeza
Super User
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?
Reeza
Super User

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. 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 1422 views
  • 0 likes
  • 4 in conversation