Proc freq

[mjack]

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...

[ballardw]

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.