Your INFILE statement specifies only a relative filename, so the SAS process automatically looks for the file in its working directory, which is the location where the SAS process was started.
In a BI server environment, this is a place in the "configuration tree".
To avoid this, you need to specify an absolute pathname, starting with a / (meaning that the path starts in the root directory and includes all subdirectory names up to where the file resides).
Now, if you work with Enterprise Guide and the file resides locally on your PC, you either need to use the import wizard of EG (which automatically transfers the file to the server before running the import data step), or you need to transfer the file yourself to a suitable location on the server (most often your home directory).
To be more specific in helping you, we need further information about your SAS setup.
If you set up the myfolders properly, you would not see a warning on the SAS Studio start up page, otherwise you see a warning. You should also be able to navigate to it on the left hand Folders menu.
Assuming the above is true, you can change your infile statement as follows:
infile '/folders/myfolders/car.dat';
PS. It has to be myfolders, with the s, and I believe its also case sensitive.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.