topic Re: SAS Programming 1: Essentials Lessons Lesson 2: Accessing Data Activitty Error in New SAS User

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

MSusenbach — Tue, 23 Jun 2020 22:42:54 GMT

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;

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.

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

ballardw — Tue, 23 Jun 2020 22:50:10 GMT

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.

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

MSusenbach — Tue, 23 Jun 2020 22:57:38 GMT

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.

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

jdeal5 — Mon, 12 Oct 2020 15:15:25 GMT

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...

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

Shark1827 — Thu, 01 Apr 2021 23:23:21 GMT

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.

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

SaiSumanthVanka — Sat, 22 May 2021 19:02:50 GMT

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.