Missing Excel 'storm' data file in p101d01.sas on SAS studio

Smartsha — Tue, 19 Jan 2021 20:23:16 GMT

When I run SAS file p101d01.sas for the SAS cert prep 9.4 part 1. I receive the following error message

ERROR: Physical file does not exist, /pbr/biconfig/940/Lev1/SASApp/&path/data//storm. How can this be resolved please?

Re: Missing Excel 'storm' data file in p101d01.sas on SAS studio

KathyKiraly — Tue, 19 Jan 2021 20:50:15 GMT

You are using the wrong folder path in your %LET statement. The s:/workshop path is just an example. Your screen shot indicates you are using SAS OnDemand for Academics. You must change the s:/workshop location to match the folder path for your EPG194/data folder. That is the location for all the course data. The surest and easiest way to find the fully-qualified path name is to right-click the EPG194/data folder and select Properties. You will see your folder path in the Location field. For SAS OnDemand, the folder path should be: %let path=/home/your-userid/EPG194/data; and your LIBNAME should be libname pg1 "&path";. Your PROC IMPORT should then have datafile="&path/storm.xlsx". If you still have trouble, please send an email to curriculumconsulting@sas.com

topic Missing Excel 'storm' data file in p101d01.sas on SAS studio in SAS Programming

Missing Excel 'storm' data file in p101d01.sas on SAS studio

Re: Missing Excel 'storm' data file in p101d01.sas on SAS studio