topic Re: SAS Programming Lesson 2 in Programming 1 and 2

SAS Programming Lesson 2

B1010 — Thu, 29 Jun 2023 02:24:24 GMT

Open p102a07.sas from the activities folder and perform the following tasks:

If necessary, update the path of the course files in the LIBNAME statement.
Complete the PROC CONTENTS step to read the parks table in the NP library.
Run the program. Navigate to your list of libraries and expand the NP library. Confirm that three tables are included: Parks, Species, and Visits.
Examine the log. Which column names were modified to follow SAS naming conventions?

Uncomment the final LIBNAME statement and run it to clear the NP library.

How should this code look?

JosvanderVelden — Thu, 29 Jun 2023 09:12:49 GMT

That depends on the sas environment you are using to train. Are you using SAS Studio from SAS OnDemand for Academics? Or another environment?

B1010 — Thu, 29 Jun 2023 11:03:24 GMT

Sas studio for academics

tom_grant — Thu, 29 Jun 2023 12:07:21 GMT

Your libname statement should be:

libname np xlsx "~/EPG1V2/data/np_info.xlsx";

The ~ points to your Files(Home) folder.

Then you can select the PARKS worksheet for the proc contents using np.parks.

Reeza — Thu, 29 Jun 2023 14:45:59 GMT

Did you open the p102a07.sas file which has the template code for you?