topic How to import SAS7BDAT data into SAS Studio in SAS Studio

How to import SAS7BDAT data into SAS Studio

saipriya92 — Wed, 27 Nov 2019 18:45:39 GMT

Hi There,

i have a file .sas7bdat and have a folder called sasuser.v94. my .sas7bdat file is in this sasuser.v94 but i dont know how to import this file into SAS studio.

this is the code and the log that I have written till now. Please help.

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 70         
 71         LIBNAME INT 'C:\Users\manya\Documents\SASUniversityEdition\myfolders\sasuser.v94\programs\SAS Exercise
 71       ! (1).SAMPLE1_DRUGS.SAS7BDAT';
 NOTE: Library INT does not exist.
 72         
 73         
 74         
 75         
 76         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 87

LIBNAME INT 'C:\Users\manya\Documents\SASUniversityEdition\myfolders\sasuser.v94\programs\SAS Exercise (1).SAMPLE1_DRUGS.SAS7BDAT';

Re: How to import SAS7BDAT data into SAS Studio

Reeza — Wed, 27 Nov 2019 18:47:55 GMT

Find the file in the Servers Files and Folders pane. Right click it, select properties and get the path. Use that path in your code.

SAS UE runs on a virtual machine, a computer within your computer. The VM cannot see your main drives unless you tell it to, which you did during set up by creating myfolders. However, the VM is not windows, it's Unix, and the paths are different.

PS. ALL CAPS is yelling in internet speak and considered rude, please avoid it unless you're trying to yell questions at everyone. It's also harder to read.

@saipriya92 wrote:

Hi There,

i have a file .sas7bdat and have a folder called sasuser.v94. my .sas7bdat file is in this sasuser.v94 but i dont know how to import this file into SAS studio.

this is the code and the log that I have written till now. Please help.
 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 70         
 71         LIBNAME INT 'C:\Users\manya\Documents\SASUniversityEdition\myfolders\sasuser.v94\programs\SAS Exercise
 71       ! (1).SAMPLE1_DRUGS.SAS7BDAT';
 NOTE: Library INT does not exist.
 72         
 73         
 74         
 75         
 76         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 87         
LIBNAME INT 'C:\Users\manya\Documents\SASUniversityEdition\myfolders\sasuser.v94\programs\SAS Exercise (1).SAMPLE1_DRUGS.SAS7BDAT';

Re: How to import SAS7BDAT data into SAS Studio

JackHamilton — Wed, 27 Nov 2019 18:58:06 GMT

For a standard SAS library, the pathname does not include the filename. You need (and can specify) only the directory name.

So omit the "SAMPLE1_DRUGS.SAS7BDAT" in the libname statement.

Personally, I don't think it's good practice to have special characters like ')' in a directory name, and I also don't think it's a good idea to store programs and and data under the sasuser.v94 directory.

If this code is running inside SAS University Edition, the pathname should be relative to the myfolders directory and use Unix naming conventions. I can't tell whether you are running the code in SAS University Edition, or trying to get the data out of a SAS University Edition directory using a different version of SAS.

Re: How to import SAS7BDAT data into SAS Studio

saipriya92 — Wed, 27 Nov 2019 18:59:12 GMT

I dont understand your solution. This is the screenshot of my screen in SAS studio and where my files are on my laptop. its attached in the attachments

Re: How to import SAS7BDAT data into SAS Studio

saipriya92 — Wed, 27 Nov 2019 19:00:56 GMT

how can i check if this is SAS studio university edition ?

Re: How to import SAS7BDAT data into SAS Studio

saipriya92 — Wed, 27 Nov 2019 19:09:39 GMT

I have the SAS on demand for academics studio

Re: How to import SAS7BDAT data into SAS Studio

Reeza — Wed, 27 Nov 2019 19:31:44 GMT

Are you logging into the online website? Your URL in the browser is odamid..... or does it start with 17 or localhost?

Did you install anything? Your path literally says SAS University Edition, why did you put that in your path?

I think you're using SAS University Edition.

I'll post a link in a minute that has screenshots of what you need but I can't open attachments so please post your images directly into the forum.

@saipriya92 wrote:

I have the SAS on demand for academics studio

Re: How to import SAS7BDAT data into SAS Studio

Reeza — Wed, 27 Nov 2019 19:47:40 GMT

https://video.sas.com/detail/videos/sas-analytics-u/video/4664335810001/accessing-your-existing-data-in-sas-university-edition:-download-version?autoStart=true

The first part is about importing a text file and after it shows how to import a sas7bdat file, so watch the whole thing or forward it.