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 (January 2004, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 23 Jan 2004 16:00:41 -0330
Reply-To:   Nan Li <nanl@NLCHI.NF.CA>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Nan Li <nanl@NLCHI.NF.CA>
Subject:   Question about converting data from vertical to horizontal
Content-Type:   text/plain; charset="ISO-8859-1"

Dear lister,

Could you please let me know how I could convert the following data from vertical to horizontal. I tried to using proc transponse, but it seems not work in the way that I want. Any help would be highly appreciated!

The input data like this:

care_epi dx_code (numeric) (character) 275332 1534 275332 1976 275333 5532 275333 1970 275333 V100 275334 V168 275334 4349 275335 2780 275335 3429 275335 E8781

I want the output like the following:

care_epi dx_cod1 dx_cod2 dx_cod3

275332 1534 1976 275333 5532 1970 V100 275334 V168 4349 275335 2780 3429 E8781

Thanks!

Nan

By the way, could you please reply to my email, since I'm only on the digest list. Thanks again.


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