topic Under Programming 1: Essential, the existing coding for importing excel file "EP101d01.SAS is wrong? in Programming 1 and 2

Under Programming 1: Essential, the existing coding for importing excel file "EP101d01.SAS is wrong?

Jennyzhu2 — Mon, 11 May 2020 17:10:46 GMT

When I ran the coding in section 1 to import excel data under EP101d01.sas, I got error message " The physical file was not found". The existing coding for path is "pro import datafile = "PATHFILE/storm.xlsx". I checked createdataPG1-oda.sas which I set up data in SAS studio, I found that "PATHFILE" doesn't exist at all. So I changed "DATAFILE" into "&Path/Storm.xlsx". It works now. Could you double check the coding under EP101d01.sas to see whether it is correct or not? Am I right to change the coding as above? I'm a new learner on SAS.

Thank you

Re: Under Programming 1: Essential, the existing coding for importing excel file "EP101d01.SAS

Cynthia_sas — Mon, 11 May 2020 19:52:41 GMT

Hi:
Yes, there is an issue with that program, thanks for pointing it out. We are reviewing it.

If your %LET statement in SETUP.SAS includes the data subfolder (which is correct for SAS OnDemand), then you needed to take the /data out of the datafile= part of the code.

S:\workshop is the classroom path for the file and in that environment, we use a slightly different path for classroom students. However, for SAS OnDemand for Academics, you should make sure that your %LET statement includes the /data subfolder and that your model syntax does not have a second reference to /data.

Thanks for bringing this typo to our attention.
Cynthia

Re: Under Programming 1: Essential, the existing coding for importing excel file "EP101d01.SAS

Jennyzhu2 — Mon, 11 May 2020 19:59:54 GMT

Thank you Cynthia for your speedy feedback. It seems section 3 and 4 have coding errors as well under EP101d01.SAS ( SAS OnDemand for Academics). Somebody saved different coding after lunch. Could you please check it?

Re: Under Programming 1: Essential, the existing coding for importing excel file "EP101d01.SAS

Cynthia_sas — Mon, 11 May 2020 22:24:29 GMT

Hi, we are reviewing the code and making changes. I am testing that program after I do the setup. I show the file name as just P102d01.sas -- as shown below:

It's probably better to watch the videos and wait for the class zip file and/or instructions to be corrected though. We'll need to re-check all the instructions, not just the OnDemand ones.
Thanks,
Cynthia

Re: Under Programming 1: Essential, the existing coding for importing excel file "EP101d01.SAS

Jennyzhu2 — Tue, 12 May 2020 00:06:14 GMT

Thank you so much Cynthia! I will wait for the fix to be done. Could you please let me know once it is done? Many Thanks.