making a table out of 4 variables together.

[harsh0404]

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) 

[Jagadishkatam]

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;

[ballardw · Accepted solution]

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

[Reeza]

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.