topic Re: How can you print the variable type for selected variables? in SAS Programming

How can you print the variable type for selected variables?

_maldini_ — Thu, 11 Feb 2016 07:15:01 GMT

I understand that I can check the variable type of ALL the variables in a dataset by using PROC CONTENTS.

But is there a way to print the variable type of selected variables using the VAR and VTYPE statements?

Thanks!

mohamed_zaki — Thu, 11 Feb 2016 08:40:42 GMT

Yes, VTYPE do this. What is your point?

Reeza — Thu, 11 Feb 2016 09:20:34 GMT

You could manually do it, but you can also query SASHELP.VCOLUMN and control your print out.

Take a look at the output from the table and a basic proc sql will work. The comparisons are case sensitive so ensure it matches your data.

proc sql;
select name, type
from sashelp.vcolumn
where libname='SASHELP'
and memname='CLASS'
and upper(name) not in ('NAME', 'AGE');
quit;

Astounding — Thu, 11 Feb 2016 13:47:08 GMT

Since you're familiar with PROC CONTENTS, you could use the tool you already know in this way:

proc contents data=have (keep=some list of variables);

run;