SAS Programming 1: Essentials Lessons Lesson 2: Accessing Data Activitty Error

[MSusenbach]

Hello,

I am working through the SAS Programming 1: Essentials Training and I am in lesson 2: Accessing Data and I am trying to complete the first activity.

Write a PROC CONTENTS step to generate a report of the storm_summary.sas7bdat table.

• SAS Studio: Specify the path to your EPG1V2/data folder and the full name of the table.
• Enterprise Guide: Specify &path and the full name of the table.

I checked the answer 

proc contents data="FILEPATH/storm_summary.sas7bdat";
run;

 This is the code I inputted

PROC CONTENTS DATA="C:\Users\admin\SASUniversityEdition\myfolders\EPG1V2\data\storm_summary.sas7bdat";
run;

And this is what I am getting back in the Log 

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

72

73 PROC CONTENTS DATA="C:\Users\admin\SASUniversityEdition\myfolders\EPG1V2\data\storm_summary.sas7bdat";

ERROR: The physical file name "C:\Users\admin\SASUniversityEdition\myfolders\EPG1V2\data\storm_summary.sas7bdat" is too long.

74 run;

I have doubled checked and this is the file path and I cannot figure out what the problem is.

Any Help would be greatly appreciated.

[ballardw · Accepted solution]

It looks like you are using SAS University edition. That does not see the Windows drive as it is a Unix based system that only sees the folders set by the virtual machine you are working in.

The path is probably more like '/folders/myfolder/EPG1V2/data/storm_summary.sas7bdat'

AND is case sensitive. So you may need to check your file paths from inside the SAS session.

[MSusenbach]

Thank you ballardw,

That worked perfect now. I will have to remember that going forward.

Now I can continue on my learning experience.

Much appreciated.

[jdeal5]

Just something I figured out.  I'm sure it is in the literature somewhere, but if you right-click on the folder and go to properties, the complete path to that folder is presented in the location field.  That helped me reduce my typos, some...

[Shark1827]

When using SAS EG, you will be required to use the folder path that was generated while performing the “setting up steps”. You can rerun the autoexec program and fetch the path from results->physical name.

[SaiSumanthVanka]

To find the location in the virtual environment which is the SAS session here, we need to select the file in the servers and folders tab and click on the "file properties" icon above.

The location would be something like '/home/u58******/EPG1V2/data/storm_summary.sas7bdat'. Here u58***** is user id given to each individual.