topic Re: Determining variable counts in SAS Procedures

Determining variable counts

saza — Sun, 10 Apr 2022 13:28:31 GMT

I was asked

How many character variables are there in the DEMOMED dataset?
What percent of subjects have hemophilia B (HTYPE)? (5 points)
What is the latest date of registration (REG_DATE)?

and unsure if there is a way to do this in one code rather than manually counting or calculating. For number one I calculated 5 by hand looking at the variables but stuck on the last two bc sas says the dataset is too large?

proc freq data= DEMOMED ;

   where htype = 'Hemophilia B';

run;

Re: Determining variable counts

Kurt_Bremser — Sun, 10 Apr 2022 13:39:18 GMT

To do the first with code, query DICTIONARY.COLUMNS in PROC SQL.

For the second, try

proc freq data=demomed;
tables htype;
run;

For the third, see

proc sql;
select max(reg_date)
from demomed;
quit;