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