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 (July 2008, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 14 Jul 2008 08:50:18 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>"
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>"
Subject:      Re: Understanding Proc Transpose

On Mon, 14 Jul 2008 05:35:25 -0700, Takeadoe <mtonkovich@MSN.COM> wrote:

>Good morning, > >I was hoping someone might lend a hand with a Proc Transpose >question. I don't understand why it generated the results that it >did. Here is a snapshot of the data before I ran Proc Transpose. >Note, there are probably 100+ variables in the data set, I've only >included a few of them. > >MatchID 200_00 200_01 200_02 212_06 212_07 220_00 220_01 ... >54 >100 >212 >45 >... > >code: >Proc Transpose; >var 200_00 200_01 (all variables in the dataset other than MatchID, >which represented unique customers) >by MatchId; > >I did not use a variable for new column name(s). > >I expected to see a 3-variable dataset consisting of MatchID Source >and Column. Instead, I ended up with a 5-variable dataset that >included MatchId Source _1 _2 _3. Some records had values for _1, >others _2, and yet others _3. What caused this? Why were there 3 new >variables (_1, _2, _3) instead of just 1? > >One other item worth noting. Values for the variables were either 0, >1, ".", or part the name of the variable such as 222 or 212. > >Any help at all would really be appreciated. > >Thank you in advance. > >Mike

At least one of your MatchID values repeats 3 times.

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