BookmarkSubscribeRSS Feed
Naresh888
Calcite | Level 5
 
100200 (this is number is there in my pdf file)
 
program;
 data test;
 in file "C:\Users\nares\Desktop\Program 1.txt";
 input number;
 run;
 
ERROR: Physical file does not exist, /home/u61142151/C:\Users\nares\Desktop\Program 1.txt.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TEST may be incomplete. When this step was stopped there were 0 observations and 1 variables.
WARNING: Data set WORK.TEST was not replaced because this step was stopped.
2 REPLIES 2
Tom
Super User Tom
Super User

From your error message SAS is running on a Unix machine so there is no way it will be able to see a file on your Windows machine.

 

Move the file to some place on the Unix machine and then reference the file using that location in your INFILE statement.  Since it looks like your home directory is named /home/u61142151/ you could put the file into that directory.

 

 

ballardw
Super User

I am sorely confused. Your question subject is "exporting data from msword to SAS". PDF files are not Word files. Txt files are text and have none of the features of Word so I am confused where exactly Word comes into this.

 

Suggestion for any future questions: when you get an error or other message in the Log you do not understand, copy the text from the log of the procedure or data step code along with all the notes, warnings and errors. On the the forum open a text box and paste that text. Then we can see everything related. The text box is important to maintain the formatting of any diagnostic characters SAS provides and the message windows will reformat text. It also helps to separate such text from general question/comment/description.

 

I say this because the code you show would not have executed enough to tell you the file the doesn't exist because the INFILE statement is one word, not "in file" as you show.

 

 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 536 views
  • 0 likes
  • 3 in conversation