Proc freq

Reply
Contributor
Posts: 42

Proc freq

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

Super User
Posts: 10,550

Re: Proc freq

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.

Ask a Question
Discussion stats
  • 1 reply
  • 142 views
  • 0 likes
  • 2 in conversation