topic import csv issue in SAS Programming

import csv issue

alexim — Wed, 23 Jan 2019 16:43:47 GMT

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

Re: import csv issue

Reeza — Wed, 23 Jan 2019 17:00:47 GMT

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.

Re: import csv issue

alexim — Wed, 23 Jan 2019 17:14:11 GMT

Success!!! Thanks Reeza for the speedy response.

thanks,
Alexim

Re: import csv issue

AMSAS — Wed, 23 Jan 2019 17:24:50 GMT

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