topic Re: Displaying data by column, not row in SAS Procedures

Displaying data by column, not row

cs — Fri, 02 Nov 2012 19:11:10 GMT

Hi, I'd like to create a table like the following where the variable names/labels are in the first column and associated values are in the second column but I am having a hard time finding coding for this online or in the SAS guides. Any suggestions would be appeciated.

Name	Indiviual A's Name
St Address	Indiviual A's St Address
City	Indiviual A's City
State	Indiviual A's State
Zip Code	Indiviual A's Zip Code
Phone Number	Indiviual A's Phone Number
Email	Indiviual A's Email

Re: Displaying data by column, not row

art297 — Fri, 02 Nov 2012 19:59:38 GMT

If you open a SAS dataset by double clicking on it in the SAS explorer window that will bring up the table using the viewtable program. Once it is open, if you click on view (from the menu bar) you can switch the view from table view to form view.

That may be what you are looking for.

Re: Displaying data by column, not row

cs — Fri, 02 Nov 2012 20:11:26 GMT

Thanks, that's helpful but I need it as output to include in a report. I tried looking at options in proc print but didn't see anything that would display the data like the table above.

Re: Displaying data by column, not row

shivas — Fri, 02 Nov 2012 20:13:24 GMT

Hi,

How about Proc transpose..

data have;

input name $ add $ city $ country $;

cards;

shiva ramnagar delhi india

;

run;

proc transpose data=have out=want;

VAR name add city country;

run;

Thanks,

Shiva

Re: Displaying data by column, not row

art297 — Fri, 02 Nov 2012 21:50:09 GMT

Here is one possibility:

proc sql noprint;

select catx(" ","variable='",name,"';value=",name,";output;")

into :vars separated by " "

from dictionary.columns

where libname="SASHELP" and

memname="CLASS"

;

quit;

data want (keep=variable value);

length variable $32;

length value $32;

set sashelp.class;

&vars.;

run;

proc print data=want;

run;

Re: Displaying data by column, not row

ballardw — Fri, 02 Nov 2012 22:12:46 GMT

Is that data example in a SAS data set? If so, please run proc contents on the data set and show the results.

If it is not in a SAS data set then the question is how to read the file and that can depend on a whole lot of factors such as file type.

Re: Displaying data by column, not row

art297 — Fri, 02 Nov 2012 22:54:55 GMT

One more thought in case the other suggestions don't meet your needs. Take a look at:

http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a002153702.htm

I wasn't even aware of it before you asked your question, but found it via a Google search.

Re: Displaying data by column, not row

Tom — Fri, 02 Nov 2012 23:14:30 GMT

proc fsbrowse data=SASHELP.CLASS label printall ;

run;

Re: Displaying data by column, not row

Howles — Sat, 03 Nov 2012 01:56:05 GMT

There used to be a PROC LABEL (or maybe it was PROC LABELS) intended for printing adhesive labels but also suitable for a task like this. I can't find it now.

Re: Displaying data by column, not row

art297 — Sat, 03 Nov 2012 02:34:00 GMT

: I 'm not aware of such a proc and can't find anything on it. Did you possibly mean proc forms?

see, e.g.: http://support.sas.com/kb/25/335.html

Re: Displaying data by column, not row

Cynthia_sas — Sat, 03 Nov 2012 04:33:53 GMT

I agree with Art, I was remembering PROC FORMS. It will probably only work with LISTING, though. As I remember, you used it to do mailing labels and mounted the forms onto the printer. I think you could tell it how many pages of XXX's to print so the operators could align the label sheets.

Oh, my! What a blast from the past! Computer rooms, operators, line printers & pinfeed forms!

cynthia

Re: Displaying data by column, not row

Reeza — Sat, 03 Nov 2012 05:24:16 GMT

Are you looking for something like the following?

What's your output destination?

DATA NULL;

FILE 'z:\DROPBOX\TEMP.TXT';

SET SASHELP.CLASS;

PUT "Name: " NAME;

PUT "AGE: " AGE;

PUT "WEIGHT: " WEIGHT;

RUN;

Re: Displaying data by column, not row

art297 — Sat, 03 Nov 2012 16:23:35 GMT

One more possibility to add to the list .. one which I'm surprised that didn't suggest: proc report.

The following paper gives step-by-step examples for using both proc forms and proc report:

http://www2.sas.com/proceedings/sugi31/149-31.pdf

Re: Displaying data by column, not row

Cynthia_sas — Sat, 03 Nov 2012 18:27:03 GMT

Art:

I was just so caught up in nostalgia for the old days of pinfeed label forms, I did neglect to mention PROC REPORT. But actually, if the need is NOT for Avery labels, but just for listing the variables in one or two columns -- since PROC REPORT needs a DATA step to manipulate the data, I'd probably just use FILE PRINT ODS within the DATA step program. Not sure whether I'd make a table template or not. But probably not.

Before I went down any of those roads -- PROC FORMS or DATA _NULL_ or PROC REPORT, I would be tempted to make a form in Word with merge fields defined, then I would make a simple CSV file with SAS and do the merge of the CSV file with the Word doc from within Word.

Of course, I'm still blissing out over PROC FORMS memories. That is a good paper, thanks for providing the link.

cynthia

Re: Displaying data by column, not row

art297 — Sat, 03 Nov 2012 19:05:07 GMT

Cynthia: Enjoy the memories. I'll try to bring up some new(old) ones next week so that the nostalgic period can continue. Hmmm .. proc explode, proc spell, proc hier, proc gwhiz, proc nickname, proc extract, proc kba and proc fscalc might be good candidates

Re: Displaying data by column, not row

cs — Sun, 04 Nov 2012 18:04:18 GMT

Thanks for everyone's help. I was able to get the data into my report using proc transpose and proc print.