topic Re: Evaluate a variable name to a table or to a variable class in SAS Programming

Evaluate a variable name to a table or to a variable class

carles — Tue, 29 Oct 2019 12:33:24 GMT

Hi !,

I am trying to find a way in SAS to evaluate whether a certain varname is a variable or a table.

Ideas ?,

let's asume I have the following examples:

data example1; 
Name = "Charles";
Surname = "Robinson";
run;

%let example2 = 201906 201704;

How can I get that &example1 is a table somehow or check that &example2 is a variable ?

I will use that inside a macro as:

if (&example= table) {then X}

else if ((&example= variabe ){then Y );

else{Z}

Thank you so much in advanced for your time and consideration,

Re: Evaluate a variable name to a table or to a variable class

Kurt_Bremser — Tue, 29 Oct 2019 12:26:02 GMT

Example2 can't be either, as it is not a valid SAS name.

If you have something that constitutes a valid SAS name, you can check it against dictionary.tables and dictionary.columns. Mind that this will only find occurrences in currently assigned libraries.

Re: Evaluate a variable name to a table or to a variable class

Astounding — Tue, 29 Oct 2019 12:35:56 GMT

SAS allows the same variable name to appear in many tables.

It also allows the same name to be both the name of a table and the name of a variable.

These are common situations, not at all unusual.

Will your plan still work?

Re: Evaluate a variable name to a table or to a variable class

carles — Tue, 29 Oct 2019 13:13:03 GMT

Yes, it is to pass it through a macro and just say whether it is a table or a variable.

Re: Evaluate a variable name to a table or to a variable class

Astounding — Tue, 29 Oct 2019 13:16:57 GMT

So if the macro determines that it is the name of two tables, as well as the name of a variable in five other tables, will that work?

Re: Evaluate a variable name to a table or to a variable class

carles — Tue, 29 Oct 2019 13:19:19 GMT

Yes

Re: Evaluate a variable name to a table or to a variable class

Kurt_Bremser — Tue, 29 Oct 2019 13:24:01 GMT

@carles wrote:

Yes, it is to pass it through a macro and just say whether it is a table or a variable.

It can be BOTH at the same time. See this example for library SASHELP:

proc sql;
select name label='Name', count(*) as count
from (
select distinct(upcase(name)) as name
from dictionary.columns
where libname = 'SASHELP'
union all
select distinct memname as name
from dictionary.tables
where libname = 'SASHELP'
)
group by name
having count > 1;
quit;

Result:

Name                                 count
------------------------------------------
CLASS                                    2
COMPANY                                  2
FEEDER                                   2
HOLIDAY                                  2
TABLE                                    2
THICK                                    2

All these appear both as variable and dataset name.

Re: Evaluate a variable name to a table or to a variable class

Astounding — Tue, 29 Oct 2019 14:43:30 GMT

So @Kurt_Bremser has already provided all the tools you would need to use. Here is an overview.

Your program will need to have issued LIBNAME statements are all the folders that need to be searched. Otherwise, SAS has no way of knowing where to look to find tables and variables.

Query DICTIONARY.TABLES to find table names. Query DICTIONARY.COLUMNS to find variable names. In both cases, you need to modify the WHERE conditions in Kurt's examples to look for just the one name that you are hoping to categorize.

You still have to figure out how to proceed if the name is both a table name and a variable name.