topic Re: How do I get the variable names to show vertically, not horizontally in a dataset and/or excel output file in SAS Procedures

How do I get the variable names to show vertically, not horizontally in a dataset and/or excel output file

franph — Wed, 15 Jul 2015 00:34:06 GMT

my dataset shows with variable names horizontally across the top and values listed vertically underneath

BD OD CD DD

1 a t 15

1 d t 12

1 c y 13

but I want it to show variable names vertically down the left side and values listed horizontally

BD 1 1 1

OD a d c

CD t t y

DD 15 12 15

I am dealing with a dataset of much more data than the example above and want it displayed this way to fit on an A4 page when printed

In my program I am doing a proc export to excel

thanks

Reeza — Wed, 15 Jul 2015 02:39:44 GMT

Use proc transpose to flip your data before you export it.

franph — Wed, 15 Jul 2015 04:55:18 GMT

thanks for the quick reply, can u show me how to write it using the above example ?

dkb — Wed, 15 Jul 2015 05:36:28 GMT

data have;

input BD OD $ CD $ DD;

datalines;

1 a t 15

1 d t 12

1 c y 13

;

run;

proc transpose data= have

out=want;

var BD OD CD DD;

run;