SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
alexim
Fluorite | Level 6

Hi, brand new to SAS UE, I looking for the easiest way to import a data table. I'm using the code snippet Import CSV file. When I run the code my file name is prepended with "/opt/sasinside/SASConfig/Lev1/SASApp/" and I get 

WARNING: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/C:\Users\Alexi\Desktop\Minitab.csv.
 
How do I disable the prepend string?
 
thanks,
Alexim
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
You need to place files in the myfolders you set up at installation and then use the file path:

'/folders/myfolders/minitab.csv'

This is because SAS UE is running on a virtual machine running on your computer that doesn't have access to your full hard drive, only the shared folders that have been set up. Consider it similar to working on a server, not on an application installed on your computer.

View solution in original post

3 REPLIES 3
Reeza
Super User
You need to place files in the myfolders you set up at installation and then use the file path:

'/folders/myfolders/minitab.csv'

This is because SAS UE is running on a virtual machine running on your computer that doesn't have access to your full hard drive, only the shared folders that have been set up. Consider it similar to working on a server, not on an application installed on your computer.
alexim
Fluorite | Level 6
Success!!! Thanks Reeza for the speedy response.

thanks,
Alexim
AMSAS
SAS Super FREQ

Hi Alexim,

 

Did you complete step 3b in the Quick Start Guide?

The CSV file must be put into the physical folder named myfolders on your computer.

 

Once you have your data files in that location, you can access them from SAS Studio.

 

Go to Tasks and Utilities on the right hand side> Utilities> Import Data> Select the file that you want to use from your myfolders folder> change the settings accordingly> and then click Run.

Here's a couple of links to additional resources that may help you:

SAS University Edition: Help Center

SAS Analytics U

Thanks

Andy

sas-innovate-white.png

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 3 replies
  • 878 views
  • 0 likes
  • 3 in conversation