LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 26 Mar 2003 08:39:26 -0800
Reply-To:     "Huang, Ya" <yhuang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Huang, Ya" <yhuang@AMYLIN.COM>
Subject:      Re: Transposing the data
Comments: To: Sam <archana_gs@MAILCITY.COM>
Content-Type: text/plain; charset="iso-8859-1"

Since you want a list, you don't have to go through transpose to get the data set restructured first. You can go straight to reporting. Here I use proc tabulate. Note, since proc tabulate dose not allow the analysis var to be character, I have to use format/informat to convert yn var to numeric and back to character when finally in the table:

proc format; invalue yn y=1 n=0; value yn 1='y' 0='n';

data xx; input Dname $ patient $ yn $ dcode; ynn=input(yn,yn.); cards; A 01 y 1 B 01 n 2 C 01 y 3 D 01 y 4 E 01 n 5 B 04 y 2 C 04 n 3 A 04 n 1 D 04 y 4 E 04 n 5 ;

options nocenter formchar='|----|+|---';

proc tabulate; class patient dname; var ynn; table patient='', dname=''*ynn=''*sum=''*f=yn. /rts=10; run; -------------- -------------------- | |A|B|C|D|E| |--------+-+-+-+-+-| |01 |y|n|y|y|n| |--------+-+-+-+-+-| |04 |n|y|n|y|n| --------------------

HTH

Ya Huang

-----Original Message----- From: Sam [mailto:archana_gs@MAILCITY.COM] Sent: Wednesday, March 26, 2003 8:15 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Transposing the data

The data is like this,

Dname patient y/n dcode A 01 y 1 B 01 n 2 C 01 y 3 D 01 y 4 E 01 n 5 B 04 y 2 C 04 n 3 A 04 n 1 D 04 y 4 E 04 n 5

I have to generate listing which looks like

Patient A B C D E

01 Y N Y y N 04 n y n y n

Please explain how to get the output.Can I use proc transpose or is there any other way.

Thank you


Back to: Top of message | Previous page | Main SAS-L page