BookmarkSubscribeRSS Feed
_maldini_
Barite | Level 11

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!

3 REPLIES 3
mohamed_zaki
Barite | Level 11

Yes, VTYPE do this. What is your point?

Reeza
Super User

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
PROC Star

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;

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 11528 views
  • 2 likes
  • 4 in conversation