12-24-2015 11:08 AM - edited 01-04-2016 09:24 AM
I know this question has been asked a million times, but none of the solutions I found helped me. I am very new to SAS, so please bear with me.
Here is my situation. I have a file located at C:\Users\myaccount\Documents\IO\temp.csv
When I use the "File > Open > Data" menu, I can successfully open that file in SAS. I can then right click on it an choose Import Data and see the data itself. If I right click on the file in the Process Flow box (top left) and choose properties, the path it shows me is, obviously, C:\Users\myaccount\Documents\IO\temp.csv
But, when I run a program as follows, I get the error "Physical file does not exist".
DATA temp; INFILE 'C:\Users\myaccount\Documents\IO\temp.csv'; INPUT ID AGE; RUN;
Any help is highly appreicated.
12-24-2015 03:40 PM
01-04-2016 09:24 AM
01-04-2016 12:13 PM
1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='ReadFile'; 4 %LET _CLIENTPROJECTPATH='C:\Users\ACCOUNT\Documents\IO\Project.egp'; 5 %LET _CLIENTPROJECTNAME='Project.egp'; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 13 STYLE=HtmlBlue 14 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/6.1/Styles/HtmlBlue.css") 15 NOGTITLE 16 NOGFOOTNOTE 17 GPATH=&sasworklocation 18 ENCODING=UTF8 19 options(rolap="on") 20 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 21 22 GOPTIONS ACCESSIBLE; 23 DATA temp; 24 INFILE 'C:\Users\ACCOUNT\Documents\IO\temp.csv'; 25 INPUT ID AGE; 26 RUN; ERROR: Physical file does not exist, C:\Users\ACCOUNT\Documents\IO\temp.csv. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TEMP may be incomplete. When this step was stopped there were 0 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 27 28 GOPTIONS NOACCESSIBLE; 29 %LET _CLIENTTASKLABEL=; 30 %LET _CLIENTPROJECTPATH=; 31 %LET _CLIENTPROJECTNAME=; 32 %LET _SASPROGRAMFILE=; 33 34 ;*';*";*/;quit;run; 35 ODS _ALL_ CLOSE; 36 37 38 QUIT; RUN; 39
01-04-2016 12:18 PM
01-04-2016 04:14 PM
The server location is a subdomain on my company's domain. I don't have access to it except via Citrix.
But, when I go on SAS and click File > Open, I can see the file system on that server. That is exactly where I stored the file.
For privacy reason I cannot share screenshots, but I can follow the steps that you might suggest to investigate the problem.
01-04-2016 04:18 PM
01-04-2016 04:20 PM
01-04-2016 04:21 PM
01-04-2016 12:18 PM
This sounds like your SAS session is running on some other machine, that does not see your file system on the PC where you are running SAS Enterprise Guide.
Use your RightMouseButton on the SAS Server you run the code, go to properties, this will show you the machine name and other information related to your SAS Server.
Have a look at this blog entry http://blogs.sas.com/content/sasdummy/2012/12/06/copy-files-in-sas-eg/ by @ChrisHemedinger this will allow you to copy files from your local machine to the SAS Server where your SAS code is executing
01-04-2016 04:07 PM
Need further help from the community? Please ask a new question.