DataStep and Proc SQL

deleted_user — Tue, 24 Feb 2009 11:43:19 GMT

Hi All,

I have a dataset with approx 30 variables and I want to find out number of unique observation count for each variable

For ex:

data sample;
input empid sal name$;
cards;
101 1000 aaa
102 2000 bbb
103 2000 ccc
104 1000 ddd
run;

proc sql;
create table count as
select count(distinct(empid)) as count_eid,
count(distinct(sal)) as count_sal,
count(distinct(name)) as count_name
from sample;
quit;

the above query results to
4, 2 and 4

My problem is i want to automate the query rather than writing all the 30 variables in select query.

so, please reply me ASAP.

Re: DataStep and Proc SQL

data_null__ — Tue, 24 Feb 2009 14:33:05 GMT

Using PROC FREQ the syntax will be more concise.

[pre]
ods select Freq.NLevels;
ods output Freq.NLevels=Nlevels;
proc freq data=sample levels;
run;
ods select all;
Proc print;
run;
[/pre]

topic Re: DataStep and Proc SQL in SAS Programming

DataStep and Proc SQL

Re: DataStep and Proc SQL