topic Re: Programming 1: Essentials - creating libraries PG1 and NP in Programming 1 and 2

Programming 1: Essentials - creating libraries PG1 and NP

rhjordan1 — Thu, 15 Jun 2023 19:09:09 GMT

I am trying to create libraries PG1 and NP in SAS Enterprise as specified in lesson 2. Even though I ran the autoexec files without modifying them, when I create a program under autoexec and run the code

libname pg1 "%path";

I don't see any "pg1" under Servers --> SASApp --> Libraries.

Also, when I create a program under process flow and run the code

libname np xlsx "%path/np_info.xlsx";

I can see NP under the list of libraries, but it does not allow me to click on it and I can't see any tables in it. When I try to do proc contents on np.Parks it says "file NP.Parks.Data does not exist." Please help.

Re: Programming 1: Essentials - creating libraries PG1 and NP

Reeza — Thu, 15 Jun 2023 20:28:00 GMT

It should be &path (not %) and the path variable also needs to be defined above, so make sure to include that line in your code as well. If you're still having issues, post the code including the %let path= portion and your log.

Re: Programming 1: Essentials - creating libraries PG1 and NP

rhjordan1 — Thu, 15 Jun 2023 20:33:11 GMT

Thank you!! Sometimes you just need a second set of eyes...

Re: Programming 1: Essentials - creating libraries PG1 and NP

ballardw — Thu, 15 Jun 2023 20:35:16 GMT

What does your LOG show?

An example of my output with similar code:

102  libname junk "%outpath";
WARNING: Apparent invocation of macro OUTPATH not resolved.

That message indicates there should have been executed in the current session some code somewhat like to define a macro call

%mend outpath;
<some statements go here>
%mend;

So your session would need something starting %mend path; and execute the code through the %mend; statement.

Are you sure that you are supposed to use %path? I would more often expect to see a macro variable &path defined with a %let statement somewhere.

You should show the LOG that results from executing those Libname statements.