Learning SAS? Welcome to the exclusive online community for all SAS learners.

not getting proc report and infile options

Reply
Occasional Contributor
Posts: 6

not getting proc report and infile options

hi

i recently downloaded sas studio in my laptop. im unable to open my permanent library.

Infile options also not working. Proc report also not showing any changes. 

 

thank you.

 

regards,

prabha

Super User
Posts: 17,863

Re: not getting proc report and infile options

Have you followed the installation instructions and set up your shared drive?

 

If so, please refer to the help center as they have answers to your questions. 

 

https://support.sas.com/software/products/university-edition/faq/main.htm

 

These are common questions so you can also find various solutions in this forum. 

Occasional Contributor
Posts: 6

Re: not getting proc report and infile options

Hi,

Thanks fr reply,

I already given Folder path as per SAS university suggested – below is the reference

 

Please find the attachment word document for more details along wih my SAS progrem Error message

 

 Capture3.JPG

Super User
Super User
Posts: 6,502

Re: not getting proc report and infile options

The error message clearly shows what you did wrong.

 

There is no file name '\folders\myfolders\trails' in the current working directory.  Looks like SAS is passing the backslash to the Unix operating system which will treat them the same as it would any other character.  Remember that on Unix you ned to use normal slash (/) instead on backslash (\) as the separator betwen directory names.

 

I am actually surprised by this as SAS normally will automatically convert between / and \ for you when you use the wrong type of slash in a file name.

 

Also next time copy and paste the TEXT from the log instead of taking a photograph of it.  Not sure why people go to the extra effort to post pictures of text when it is so easier to just copy and paste the actual text itself.  Also when you take a picture you have be careful to not crop the image so that the important information is missing.

Super User
Posts: 17,863

Re: not getting proc report and infile options

As Tom mentioned, don't use attachments. I, for one, try not to download external files. 

 

From Toms comment it sounds like you need to change your slashes.  

SAS Super FREQ
Posts: 8,743

Re: not getting proc report and infile options

Hi:
In addition to all the other suggestions, it looks like you have in incomplete INFILE statement. You cannot point the INFILE statement to a folder, you need to point it to a specific FILENAME, like:
infile '/folders/myfolders/trails/csvfile.csv' dlm=',' dsd;
or infile '/folders/myfolders/trails/somefile.txt' dlm='|';

in the code you posted, you only have:
infile '/folders/myfolders/trails'; which would NOT be correct.

cynthia
Ask a Question
Discussion stats
  • 5 replies
  • 372 views
  • 0 likes
  • 4 in conversation