SAS Programming Lesson 2

[B1010]

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

1. If necessary, update the path of the course files in the LIBNAME statement.
2. Complete the PROC CONTENTS step to read the parks table in the NP library.
3. Run the program. Navigate to your list of libraries and expand the NP library. Confirm that three tables are included: Parks, Species, and Visits.
4. 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]

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]

Sas studio for academics

[tom_grant]

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]

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