proc dataset / proc contents

Steelers_In_DC — Thu, 09 Apr 2015 20:53:48 GMT

I am currently using this: proc datasets lib=tran1214 nolist;contents data=_all_ noprint out=MDJ.tran1214;quit;run;

I can search the output to find a table that has one or several variables that I need to use. There is one table that has a corrupted table so it will not work. I would like to do something like this (this does not work)

proc datasets lib=wbdw nolist;

contents data = ABS_02PORTFOLIO_CONVERSION ;

contents data = ACLS_CONCENTRATION_FACT ;

contents data = ACLS_CUSTOMER_DIMENSION ;

contents data = ACLS_LOAN_DIMENSION ;

contents data = AGENDA_ACTIVITY_DIM ;

contents data = AGENDA_ATTEND_FACT ;

contents data = AGENDA_CONTACT_FACT ;

currently I'm taking this output with several hundred tables and putting it into excel to search for variables. Is there a way to list multiple datasets rather than _all_?

I'm using the output to feed into this:

proc sql;

create table WANT as

select DISTINCT MEMNAME

from &check_lib

where

/*MEMNAME in (select distinct MEMNAME from &check_lib where upcase(NAME)="ACCT_PARTICIPATED_AMT") AND*/

/*MEMNAME in (select distinct MEMNAME from &check_lib where upcase(NAME)="ACCT_CUST_INTEREST_BAL_AMT") AND*/

/*MEMNAME in (select distinct MEMNAME from &check_lib where upcase(NAME)="ACCT_FEE_CURRENT_PAYOFF_AMT") AND*/

/*memname in (select distinct MEMNAME from &check_lib where upcase(NAME) contains "DEFAULT_DATE_END") AND*/

MEMNAME in (select distinct MEMNAME from &check_lib where upcase(NAME) contains "PD");

quit;

I've tried a few things with no viable solutions, any help will be appreciated.

Thanks in advance.

Re: proc dataset / proc contents

ballardw — Thu, 09 Apr 2015 21:14:14 GMT

You want to use your SQL on the special SAS DICTIONARY.COLUMNS.

Use this to see the description:

proc sql;

describe table dictionary.columns;

quit;

and then something search the dictionary table to find the memnames with the columns you need. Specify the LIBNAME='YOURLIBGOESHERE' in the where clause.

you could drop all of the UPCASE functions as the LIBNAME, MEMNAME and NAME variables are all upper case in the dictionary tables.

Re: proc dataset / proc contents

Doc_Duke — Thu, 09 Apr 2015 21:17:03 GMT

Just delete the corrupted table.

Re: proc dataset / proc contents

Steelers_In_DC — Fri, 10 Apr 2015 01:18:18 GMT

Thanks

topic proc dataset / proc contents in SAS Procedures

proc dataset / proc contents

Re: proc dataset / proc contents

Re: proc dataset / proc contents

Re: proc dataset / proc contents