BookmarkSubscribeRSS Feed
teleous0
Fluorite | Level 6

Hello,

I am using SAS Studio 9.2 I have uploaded the practice problems that appear in The Little SAS Book (TLSB).

 

* Section 3.11*/
/* Program */
* Change all 9s to missing values;
DATA songs;
INFILE 'c:\MyRawData\KBRK.dat';
INPUT City $ 1-15 Age wj kt tr filp ttr;
ARRAY song (5) wj kt tr filp ttr;
DO i = 1 TO 5;
IF song(i) = 9 THEN song(i) = .;
END;
RUN;
PROC PRINT DATA = songs;
TITLE 'KBRK Song Survey';
RUN;

 

In this instance, I am referencing problem 3-11 (above) though I’ve encountered it with every problem I’ve sampled jus to make sure.

 

The ‘infile statement’ directs me to the c: drive.  When I click on the file’s ‘Properties’ and cut and paste the exact location of the file for the infile statement, a second infile statement appears along with five errors in the log (condensed below) and two expected warnings.

ERROR 23-2: Invalid option name C, MyRawDATA, KBRK, Song, and Survey)

When I run the problem as it appears, I get a single error message

ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/c:\MyRawData\KBRK.dat.’

 I am not including the six notes here but have attached the logs of both programs. Thank you in advance for your help.

2 REPLIES 2
ballardw
Super User

The "Physical File does not exist" message tells you where SAS looked for your data. The mixture of /  and \ in that message tells me that your SAS is likely a server and can not see your harddrive. You have to make sure you read (and write) to locations the server sees which may involve working with either your ID or SAS admin to set permissions and identify your hard drive to the SAS session as a source. Note that the paths will likey look different.

 

 

teleous0
Fluorite | Level 6
Thank you so very much. Here is a "virtual" frozen Reese's Cup  (one of life's little luxuries) for your help.

Sent from my Verizon Wireless 4G LTE Droid

sas-innovate-2024.png

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.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 898 views
  • 0 likes
  • 2 in conversation