topic Re: List all dataset names in a library in SAS Programming

List all dataset names in a library

jmarroyo — Mon, 08 Aug 2016 20:54:19 GMT

Good Day! I am using using SAS Essentials, by Elliot and Woodward, to get my feet wet with SAS. The following code displays a list of the data after importing the file somedata (in the directory it is somedata.sas7bdat):

*******************************************************
* From SAS ESSENTIALS, Jossey Bass/Wiley *
* (C) 2010 Elliott, Alan C. and Woodward, Wayne A. *
*******************************************************;
PROC DATASETS;
CONTENTS DATA= "/folders/myfolders/sasdata/somedata";
RUN;

However, the authors say to display information about all data sets in the sasdata library I should

CONTENTS DATA= "/folders/myfolders/sasdata/somedata._ALL_";but I do

PROC DATASETS;
CONTENTS DATA= "/folders/myfolders/sasdata/sasdata._ALL_";
RUN;

Log is:

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 *******************************************************

57 * From SAS ESSENTIALS, Jossey Bass/Wiley *

59 *******************************************************;

60 PROC DATASETS;

61 CONTENTS DATA= "/folders/myfolders/sasdata/sasdata._ALL_";

ERROR: Extension for physical file name "/folders/myfolders/sasdata/sasdata._ALL_" does not correspond to a valid member type.

NOTE: Enter RUN; to continue or QUIT; to end the procedure.

62 RUN;

NOTE: Statements not processed because of errors noted above.

65 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Any suggestions?

Most appreciative

PS I am using SAS University ed on Windows 7 VM Virtual Box Manager

Re: List all dataset names in a library

Reeza — Mon, 08 Aug 2016 21:16:02 GMT

The book lists notations like in your code, including the portion in blue?

PROC DATASETS;
CONTENTS DATA= "/folders/myfolders/sasdata/somedata";
RUN;

Re: List all dataset names in a library

Reeza — Mon, 08 Aug 2016 21:21:44 GMT

Usually the notation suggestion is LIBNAME._all_

So your code should look like the following, assuming your libname is correct. Note that proc datasets requires a QUIT.

libname mylib '/folders/myfolders/sasdata/sasdata';

PROC DATASETS;
CONTENTS DATA= mylib._all_;
RUN;QUIT;

Re: List all dataset names in a library

jmarroyo — Mon, 08 Aug 2016 21:32:19 GMT

No Sir. I had to modify the original file location because I am using the University Edition, and as you are well aware, I have to put all my files (and subdirectories, ie. sasdata) where they are to be accesible to Virtual box. the original code was:

DATAFILE= C:\SASDATA\SOMEDATA;

Hope this answers your question and most appreciative for any assistance

Re: List all dataset names in a library

Reeza — Mon, 08 Aug 2016 21:33:58 GMT

Not a Sir.

Re: List all dataset names in a library

Reeza — Mon, 08 Aug 2016 21:35:31 GMT

They appear to be using a non-standard convention. I would recommend a different book to learn from.

The Little SAS Book for SAS University Edition is probably a better starting point.

Re: List all dataset names in a library

jmarroyo — Mon, 08 Aug 2016 21:37:20 GMT

Your name is the same as a good friend. My deepest and most sincere apologies!

Re: List all dataset names in a library

jmarroyo — Mon, 08 Aug 2016 21:56:01 GMT

This works. Most appreciative!