When you omit the VAR statement, you get the default behavior, which is to transpose all numeric variables. Occasionally appropriate, but not in this case.

Your initial statement was quite vague and just said that PROC TRANSPOSE seemed not to work as needed. If you had been more specific and had shown code and/or results, somebody would have pinpointed the problem *even faster*!

On Fri, 23 Jan 2004 16:27:53 -0330, Nan Li <nanl@NLCHI.NF.CA> wrote:

>Venita, Bruce, and Paul, > >Thank you very much for your quick response. Yes, I left VAR statemant in my >proc transform. Thanks again! > >-----Original Message----- >From: DePuy, Venita [mailto:depuy001@dcri.duke.edu] >Sent: Friday, January 23, 2004 4:04 PM >To: SAS-L@LISTSERV.UGA.EDU; 'Nan Li' >Subject: RE: Question about converting data from vertical to horizontal > > >Hi Nan et al - > >I'm guessing you left the BY statement out of Proc Transpose. >Working program follows. >HTH, >Venita > > >data file1; > input care_epi dx_code $; >cards; > 275332 1534 > 275332 1976 > 275333 5532 > 275333 1970 > 275333 V100 > 275334 V168 > 275334 4349 > 275335 2780 > 275335 3429 > 275335 E8781 > ; >proc print;run; > >proc transpose out=out1; > var dx_code; > by care_epi; >proc print data=out1; >data out1; > set out1 (rename= (col1 = dx_cod1 col2=dx_cod2 col3=dx_cod3)); > drop _NAME_; >proc print;run; > >> ---------- >> From: Nan Li[SMTP:nanl@NLCHI.NF.CA] >> Reply To: Nan Li >> Sent: Friday, January 23, 2004 2:30 PM >> To: SAS-L@LISTSERV.UGA.EDU >> Subject: Question about converting data from vertical to horizontal >> >> 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. >>