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

Unable to find files in SAS myfolders

Reply
New Contributor
Posts: 4

Unable to find files in SAS myfolders

Hello all,

 

I started using/learning SAS today. Under my folders I dropped a couple of files but I am unable to fetch them using SAS. When I select Import New Data I only find sasuser.v94. I am not sure where I messed up. /Users/adityanarayanboral/Documents/SASUniversityEdition/myfolders this is the pathname displayed on my Mac. I tried with /folders/myfolders, moved around the folders but in vain. Import data is still blank. 

 

Any help will be appreciated.

 

Thanks a lot in advance,

Aditya.

Super User
Posts: 23,980

Re: Unable to find files in SAS myfolders

1. Did you set up the myfolders connection in Oracle VirtualBox or VMWare?

2. What happens when you assign a libname to myfolders?

 

libname test '/folders/myfolders/';

3. Does a code import work?

 

proc import out=myData datafile='/folders/myfolders/temp.csv' dbms=csv replace; run;

@aboral wrote:

Hello all,

 

I started using/learning SAS today. Under my folders I dropped a couple of files but I am unable to fetch them using SAS. When I select Import New Data I only find sasuser.v94. I am not sure where I messed up. /Users/adityanarayanboral/Documents/SASUniversityEdition/myfolders this is the pathname displayed on my Mac. I tried with /folders/myfolders, moved around the folders but in vain. Import data is still blank. 

 

Any help will be appreciated.

 

Thanks a lot in advance,

Aditya.


 

New Contributor
Posts: 4

Re: Unable to find files in SAS myfolders

Hello Reeza,

 

1. It is setup in the Virtualbox.

 

2. libname aditya "/folders/myfolders/"; this works but

 libname aditya "/folders/myfolders/Sas Class"; does not and throws an error.

 

3. proc import datafile="/folders/myfolders/SAS Class/Car_sales.csv"
out= work.Car_sales1
dbms=csv;
run;

 

this code gives me the following error:

 

 
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 proc import datafile="/folders/myfolders/SAS Class/Car_sales.csv"
74 out= work.Car_sales1
75 dbms=csv;

@Reeza wrote:

1. Did you set up the myfolders connection in Oracle VirtualBox or VMWare?

2. What happens when you assign a libname to myfolders?

 

libname test '/folders/myfolders/';

3. Does a code import work?

 

proc import out=myData datafile='/folders/myfolders/temp.csv' dbms=csv replace; run;

@aboral wrote:

Hello all,

 

I started using/learning SAS today. Under my folders I dropped a couple of files but I am unable to fetch them using SAS. When I select Import New Data I only find sasuser.v94. I am not sure where I messed up. /Users/adityanarayanboral/Documents/SASUniversityEdition/myfolders this is the pathname displayed on my Mac. I tried with /folders/myfolders, moved around the folders but in vain. Import data is still blank. 

 

Any help will be appreciated.

 

Thanks a lot in advance,

Aditya.


 


76 run;
 
NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to
WORK.PARMS.PARMS.SLIST.
ERROR: Physical file does not exist, /folders/myfolders/SAS Class/Car_sales.csv.
ERROR: Import unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds
 
77
78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
91
 
Aditya.
Super User
Posts: 23,980

Re: Unable to find files in SAS myfolders

Go to the Servers Files and Folders pane in SAS Studio.

Click through to find your file

Right click the file and select properties

Copy the path and use that in your code. 

 

SAS UE is on Unix so it's case sensitive if that matters.

New Contributor
Posts: 4

Re: Unable to find files in SAS myfolders

I had tried this, and thats where my doubt lies. The folders aren't visible there. The only folder I have below my folders is sassier.v94. Is it possible that the software wasn't downloaded properly?

Super User
Posts: 23,980

Re: Unable to find files in SAS myfolders

No, otherwise you wouldn't even see myfolders or SAS Studio.

 

Check the folder shortcuts. If you named the file incorrectly it's under there instead.

 

If that doesn't work, post a screenshot of 

1. Your VM reference to myfolders in Oracle Virtual Box

2. myfolders in Servers Folders and Files

3. myshortcuts in Servers Folders and Files

 


@aboral wrote:

I had tried this, and thats where my doubt lies. The folders aren't visible there. The only folder I have below my folders is sassier.v94. Is it possible that the software wasn't downloaded properly?


 

New Contributor
Posts: 4

Re: Unable to find files in SAS myfolders

Hello Reeza,

 

I reinstalled both the Virtualbox and SAS University Edition. It works fine now. I think maybe I had missed out something or selected something wrong the last time I tried downloading. I cannot thank you enough for your continued assistance.

 

Regards,

Aditya.

Ask a Question
Discussion stats
  • 6 replies
  • 236 views
  • 0 likes
  • 2 in conversation