topic Case Statement or other type breakout? in SAS Programming

Case Statement or other type breakout?

IgawaKei29 — Thu, 29 Nov 2018 15:00:14 GMT

So I have two fields, name and type and I am trying to figure how to break this out into more distinct columns.

Name has just different names of users

Type has different colors.

So what I am trying to do is:

Name Count of Red Count of Blue Count of Green
Matt 4 1 2
Ben 2 3 0
Frank 6 4 1

Re: Case Statement or other type breakout?

RW9 — Thu, 29 Nov 2018 15:16:03 GMT

Proc freq your starting data, then transpose the output from the proc freq. Post test data in the form of a datastep if you want actually working code, I am not here to type in test data.

Re: Case Statement or other type breakout?

Kurt_Bremser — Thu, 29 Nov 2018 15:22:20 GMT

You can do that with proc freq and proc transpose:

data have;
input name $ type $;
cards;
Matt Red
Matt Red
Matt Red
Matt Red
Matt Blue
Matt Green
Matt Green
;
run;

proc freq data=have;
by name;
table type/  out=inter nocum nocol nopercent;
run;

proc transpose data=inter out=want (drop=_name_ _label_) prefix=count_of_;
by name;
id type;
var count;
run;

proc print data=want noobs;
run;

Result:

         count_     count_     count_
name    of_Blue    of_Green    of_Red

Matt       1           2          4

Re: Case Statement or other type breakout?

ballardw — Thu, 29 Nov 2018 16:38:06 GMT

Do you want a data set (used by computer for other processes) or report (people read it);

One report

Proc tabulate data=have;

class name color;

table name,

color

;

run;

Re: Case Statement or other type breakout?

IgawaKei29 — Thu, 29 Nov 2018 18:06:43 GMT

I appreciate all the responses on this. Not used proc transpose a whole lot so this was interesting to see work.