topic Re: Solution needed with both datastep and report procedure in SAS Programming

Solution needed with both datastep and report procedure

West26 — Sun, 22 Jan 2017 19:38:36 GMT

Input:

Needed ouput:

distinct times

21 5

22 4

23 2

West26 — Sun, 22 Jan 2017 19:43:53 GMT

Sorry, I need the total for time too.
Needed ouput:

distinct times

21 5

22 4

23 2
Total 11

Shmuel — Sun, 22 Jan 2017 20:18:43 GMT

data test;

input var;

datalines;

;run;

1) proc freq data=test; table var; run;

2) proc means data=test;

class;

var var;

output out=test1 N=;

run;

I haven't run it so check it carefully.

Astounding — Sun, 22 Jan 2017 21:03:05 GMT

Getting the total should be just for reporting purposes and not part of the data itself. One way:

proc freq data=have;

tables distinct / noprint out=counts (keep=distinct count rename=(count=times));

run;

proc print data=counts;

var distinct times;

sum times;

run;