topic Re: Proc Tabulate: 1 Variable and Present as Row in SAS Procedures

Proc Tabulate: 1 Variable and Present as Row

apple — Tue, 01 Dec 2015 06:17:17 GMT

Using SAS 7.1.

I only have 1 variable, but instead of presenting in column, I want in ROWS. How do I do that?

Thanks!

Re: Proc Tabulate: 1 Variable and Present as Row

kannand — Tue, 01 Dec 2015 06:27:32 GMT

Would it be possible to share some of your data as sample and tell us how you expect the output to look like?

Re: Proc Tabulate: 1 Variable and Present as Row

apple — Tue, 01 Dec 2015 07:26:00 GMT

Hi,

THank you for the reply.

I have attached a sample.

I could do a transpose paste in excel, but as I have many tables it becomes tedious. Hence would prefer that SAS generate the tables as ROWS.

THank you

Re: Proc Tabulate: 1 Variable and Present as Row

kannand — Tue, 01 Dec 2015 08:31:19 GMT

Here is something you may clone to your specific needs.... This is just one way of getting the output you desire... a bit lengthy but simple code....

data have;
input v1:$5. v2:$5. v3:$5. v4:$5.;
datalines;
Tom Peter Henry Jack 
100 101 102 103
;
run;

data name;
 set have;
 if _n_ = 1;
run;
proc transpose data=name out=names(drop=_name_);
  var v1 v2 v3 v4;
run;
data id;
 set have;
 if _n_ = 2;
run;
proc transpose data=id out=ids(drop=_name_);
  var v1 v2 v3 v4;
run;
data final;
 set names(rename=(col1=name));
 set ids(rename=(col1=id));
run;
proc print data=final;
run;

It produces the following output for your reference...

Obs	name	id
1	Tom	100
2	Peter	101
3	Henry	102
4	Jack	103

Hope this helps...!!! Good Luck...!!!