How can you print the variable type for selected variables?

Reply
Regular Contributor
Posts: 199

How can you print the variable type for selected variables?

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!

Super Contributor
Posts: 490

Re: How can you print the variable type for selected variables?

Yes, VTYPE do this. What is your point?

Super User
Posts: 19,093

Re: How can you print the variable type for selected variables?

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;
Super User
Posts: 5,362

Re: How can you print the variable type for selected variables?

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;

Ask a Question
Discussion stats
  • 3 replies
  • 305 views
  • 2 likes
  • 4 in conversation