topic Re: making a table out of 4 variables together. in SAS Programming

making a table out of 4 variables together.

harsh0404 — Tue, 10 Sep 2019 20:16:03 GMT

I am looking to transform this table type into the second one type.. (this is just to visualize, so i havent written all the age groups in the second table type)

Re: making a table out of 4 variables together.

Jagadishkatam — Tue, 10 Sep 2019 21:05:47 GMT

please try transpose

proc sort data=have;
by decile age_group;
run;

proc transpose data=have out=want;
by decile ;
id age_group;
var rev1;
run;

Re: making a table out of 4 variables together.

ballardw — Tue, 10 Sep 2019 22:19:16 GMT

Do you need a dataset used by other bits of a program, which has some technical issues with your variable names, or a report that people read?

One report might look like:

proc report data=have;
   columns decile agegroup,(rev1 rev2);
   define decile /group;
   define agegroup/across;
run;

I won't say it is impossible to put the rev1 and rev2 at the bottom but that would generally be a poor idea in something that has a lot of rows

Re: making a table out of 4 variables together.

Reeza — Tue, 10 Sep 2019 22:34:08 GMT

PROC TABULATE.

FYI - you're less likely to get code solutions that actually work if you post data as pictures because it means typing out your data. Posting your data as text is preferable for everyone. And it's faster.