topic Re: Programming 1 - Lesson 1: errors when running p101a03 in Programming 1 and 2

Programming 1 - Lesson 1: errors when running p101a03

lietchi — Wed, 30 Jan 2019 12:20:22 GMT

In lesson 1, they ask us to "Open p101a03.sas from the activities folder and perform the following tasks".

When executing the 4th task (running the program), I get several error messages.

Does anyone have any ideas on how to solve this problem?

FYI, I'm using SAS Entreprise Guide version 7.13. I watched the video on how to do the data setup, I think I did everything right.

Re: Programming 1 - Lesson 1: errors when running p101a03

PremS — Wed, 30 Jan 2019 12:30:03 GMT

Hmm, that is peculiar, I don't see why it didn't work for you.

If you open the SASHELP.CARS table (looks like it's already opened in the Class_Work process flow in the top left), do you see any rows of data? Could you include a photo of the rows of data in the table?

Re: Programming 1 - Lesson 1: errors when running p101a03

lietchi — Wed, 30 Jan 2019 12:37:36 GMT

I hope I'm looking in the right place, but the table looks very empty!

Could the issue be in the SASHELP library itself?

Re: Programming 1 - Lesson 1: errors when running p101a03

PremS — Wed, 30 Jan 2019 13:16:18 GMT

Yeah, it looks like there's an issue with the table in the library. Most SAS users don't have the appropriate permissions to edit files in the SASHELP library, but somehow that table was overwritten. Hopefully someone else has some insight on this.

The activity you ran should have worked fine, so you can take comfort that you did nothing wrong. There are some activities or videos in the class that use the CARS, CLASS, or SHOES tables in the SASHELP library. Are the CLASS or SHOES tables empty as well?

Almost all of the activities, demonstrations, and practices use the international storm data, so I wouldn't worry too much if you wanted to look at - but not run - the handful of activities that use the CARS table. In Chapter 1, these tables are used to showcase introductory concepts and syntax in a few activities.

Re: Programming 1 - Lesson 1: errors when running p101a03

lietchi — Wed, 30 Jan 2019 13:41:54 GMT

Thanks for the clarification, being a total newbie I had no idea if I had done something wrong or not!

I checked and the CLASS and SHOES tables seem fine. I'll improvise my way around the CARS table

Re: Programming 1 - Lesson 1: errors when running p101a03

ballardw — Wed, 30 Jan 2019 15:52:27 GMT

There is a big clue in the note about 0 observations in the SASHELP.CARS . That means for some reason the data set apparently has had all of the observations removed somehow on your install and possibly most of the variables.

Re: Programming 1 - Lesson 1: errors when running p101a03

Reeza — Wed, 30 Jan 2019 15:53:17 GMT

Is that the first error in the program? If not, show the first error.

Also, you can check if cars exist using:

proc content data=sashelp.cars;run;

Re: Programming 1 - Lesson 1: errors when running p101a03

lietchi — Thu, 31 Jan 2019 08:21:43 GMT

I spoke to the SAS reference person in our organisation and apparently someone accidentally deleted almost all of the contents of the CARS table on our server.

Re: Programming 1 - Lesson 1: errors when running p101a03

Reeza — Thu, 31 Jan 2019 16:06:13 GMT

Fun, but relatively easy to fix at least.

@lietchi wrote:

I spoke to the SAS reference person in our organisation and apparently someone accidentally deleted almost all of the contents of the CARS table on our server.