Learning SAS? Welcome to the exclusive online community for all SAS learners.

SAS Studio

Accepted Solution Solved
Reply
Valued Guide
Posts: 858
Accepted Solution

SAS Studio

I have downloaded the new version of SAS Studio, formerly SAS on demand.  Will I be able to import information from my desktop or any other folder?

Thanks,

Mark


Accepted Solutions
Solution
‎06-10-2014 04:54 PM
SAS Super FREQ
Posts: 683

Re: SAS Studio

Yes you are. Please have a look at the quick start guide (for instance http://support.sas.com/software/products/university-edition/docs/SASUniversityEditionQuickStartVirtu...), it explains about the "myfolders" shared folder. Everything in this folder on your host OS can be accessed from within SAS Studio using "/folders/myfolders"

Also have a look at the FAQ What is a shared folder?

So for instance this folder structure below

Is visible as

The Excel file might be imported using this code:

PROC IMPORT

  DATAFILE="/folders/myfolders/someExcel.xlsx"

  OUT=WORK.MYEXCEL

  DBMS=XLSx

  REPLACE

;

RUN;

proc contents;

run;

View solution in original post


All Replies
Solution
‎06-10-2014 04:54 PM
SAS Super FREQ
Posts: 683

Re: SAS Studio

Yes you are. Please have a look at the quick start guide (for instance http://support.sas.com/software/products/university-edition/docs/SASUniversityEditionQuickStartVirtu...), it explains about the "myfolders" shared folder. Everything in this folder on your host OS can be accessed from within SAS Studio using "/folders/myfolders"

Also have a look at the FAQ What is a shared folder?

So for instance this folder structure below

Is visible as

The Excel file might be imported using this code:

PROC IMPORT

  DATAFILE="/folders/myfolders/someExcel.xlsx"

  OUT=WORK.MYEXCEL

  DBMS=XLSx

  REPLACE

;

RUN;

proc contents;

run;

Valued Guide
Posts: 858

Re: SAS Studio

Here's the log, it' snot working for me so far.  Can you see any clear errors?

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

42 ;

43 PROC IMPORT

44 DATAFILE="/SASUniversityEdition/myfolders/Wipro_May_1st.xlsx"

45 OUT=WORK.MYEXCEL

46 DBMS=XLSx

47 REPLACE

48 ;

49 RUN;

ERROR: The path /SASUniversityEdition/myfolders/Wipro_May_1st.xlsx is invalid because it is not in the list of accessible paths

  when SAS is in the lockdown state.

Valued Guide
Posts: 858

Re: SAS Studio

It is working now.  Thank You Very Much.

New Contributor vg
New Contributor
Posts: 2

Re: SAS Studio

Hello,

I'm getting a similar Lockdown state error.  "...invalid because it is not in the list of accessible paths when SAS is in the lockdown state."

Could you please tell me how yours was fixed?  Thanks!

Valued Guide
Posts: 858

Re: SAS Studio

I'm sorry I don't have the code that I used.  I remember it was a syntax error.  Are you using oracle VM?  I remember there being an issue initially that oracle VM corrected.  If you haven't figured it out shoot me an email and I will import the data again, make it work and give you the steps.  I'm not at my normal computer so I cannot duplicate the process.

markdjohnson77@gmail.com

New Contributor vg
New Contributor
Posts: 2

Re: SAS Studio

I just resolved it.  I was using the wrong file location (it was supposed to be from SAS folder structure).  Thanks though for your prompt response!

Occasional Learner
Posts: 1

Re: SAS Studio

Hello,

 

I am getting the same error. It seems like a directory problem but I'm pretty sure the details are correct. Any ideas?

 

56 filename nparcov3 "/folder/myfolders/NParCov3.sas";
ERROR: The path /folder/myfolders/NParCov3.sas is not in the list of accessible paths when SAS is in the lockdown state.
ERROR: Error in the FILENAME statement.
57

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 2019 views
  • 1 like
  • 4 in conversation