Proc freq

mjack — Fri, 24 May 2013 14:26:11 GMT

Hi Experts,

Using proc freq, how can I achieve the results achieved by the following queries :

proc sql;

select count(distinct(columnname)) from datasetname where columnname > 6 and columnname < 100;

quit;

proc sql;

select columnname, count(*) from datasetname where columnname > 6 and columnname < 100;

quit;

Because when I run above sqls I get 'ERROR: SPDS Sql Passthru Error.'

Pls help...

Re: Proc freq

ballardw — Fri, 24 May 2013 15:01:42 GMT

The proc freq equivalent woud be

proc freq data=datasetname;

where 6 < columnname < 100;

tables columname/ nopercent;

run;

but your problem may be related to the DB connection.