topic Re: combining multiple value with distinct value in SAS Enterprise Guide

combining multiple value with distinct value

woo — Fri, 04 Nov 2016 18:49:18 GMT

Hello friends, can someone plz help,

have

var1 var2

user1 sessionXYZ

user1 sessionABC

user1 sessionGYAKFJ

user2 sessionSDFKJ

user3 sessionsfljasfgljk

user3 sessionfvksjfvnsjn

want

user1 has 3 seession running

user2 has 1 session running

user3 has 2 session running

Shmuel — Fri, 04 Nov 2016 19:19:21 GMT

Option 1:

proc freq data=have; by var1; run

you will get the frequency of each user in the dataset;

Option 2:

data want;

set have;

by var1; /* assumed data is sorted */

retain counter ;

if first.var1 then counter = 1; else counter+1

if last.var1 then

/* either */ output;

/* or */ put var1 'has ' counter ' sessions running';

run;

Astounding — Fri, 04 Nov 2016 20:09:10 GMT

If it's the report that you are after, you can extend the idea already suggested:

proc freq data=have;

tables var1 / noprint out=sessions;

run;

data _null_;

set sessions;

file print notitles;

if count > 1 then put var1 'has ' count 'sessions.';

else put var1 'has 1 session.';

run;

ballardw — Fri, 04 Nov 2016 20:18:49 GMT

And a different proc as an option:


proc tabulate data=have;
   class var1;
   table var1='',
         n="Sessions Running"
   ;
run;

woo — Fri, 04 Nov 2016 22:17:24 GMT

thank you all...appreciate your time...