```Date: Thu, 1 May 2003 15:09:57 -0400 Reply-To: Nathaniel_Wooding@DOM.COM Sender: "SAS(r) Discussion" From: Nathaniel Wooding Subject: Re: problem in transposing Comments: To: Archana Gowder Content-type: text/plain; charset=us-ascii Sam Here is a solution that provides unit as a variable in the new data set. without including it as a by variable. However, does this give you the proper value? Note the comments in the code. Where a single unit appears in one of the sets, the value is transposed. However, if two lines have a value for unit, then you get an additional line of output. Is this what you need? I, too, appreaciate your sending your code as you did. Nat Wooding DATA XX; INPUT CAT \$2. PT 3. TEST \$ 5. DAY 2. INVN \$4. VAL \$4. unit \$4.; DATALINES; A 101 DIS1 1 LOP 1.2 A 101 DIS1 2 LOP 1 A 101 DIS1 3 LOP nd nd A 101 DIS2 1 DAN 1.1 A 101 DIS2 2 DAN 1.3 A 101 DIS2 3 DAN 1.2 we B 101 DIS3 1 DAN 1.1 B 101 DIS3 2 DAN 2 B 101 DIS3 3 DAN 3 B 101 DIS4 1 LOP 1.2 B 101 DIS4 2 LOP 1.5 B 101 DIS4 3 LOP nd nd C 101 DIS5 1 DAN 1 C 101 DIS5 2 DAN 2 C 101 DIS5 3 DAN 2 A 102 DIS1 1 LOP 1.2 qw A 102 DIS1 2 LOP 1 A 102 DIS1 3 LOP 1.2 A 102 DIS2 1 DAN 1.1 A 102 DIS2 2 DAN 1.3 A 102 DIS2 3 DAN 1.2 B 102 DIS3 1 DAN 1.1 B 102 DIS3 2 DAN 2 B 102 DIS3 3 DAN 3 B 102 DIS4 1 LOP 1.2 B 102 DIS4 2 LOP 1.5 B 102 DIS4 3 LOP 1.9 C 102 DIS5 1 DAN nd nd C 102 DIS5 2 DAN 2 er C 102 DIS5 3 DAN 2 ; PROC SORT DATA = XX ; BY PT CAT TEST INVN descending unit;* change --note sort on descending unit; proc print; PROC TRANSPOSE DATA=XX OUT = T_XX; ID DAY; BY PT CAT TEST INVN ; copy unit; * change unit moved to this line; VAR VAL; PROC PRINT DATA = T_XX; RUN; "Archana Gowder" om> cc: Subject: Re: problem in transposing 05/01/03 02:38 PM Hi, If i don't use variable in transposing ,like for example unit in my dataset then that data set does n't contain unit varaible .Unit variable is unavailable for further use.How can i use ,whats the solution. Thank you ----- Original Message ----- From: To: "Sam" Sent: Thursday, May 01, 2003 2:30 PM Subject: Re: problem in transposing > > Sam > > I am not certain that I understand your problem but, if the following is an > example > > Obs PT CAT TEST INVN unit > _NAME_ _1 _2 _3 > > 1 101 A DIS1 LOP > VAL 1.2 1 > 2 101 A DIS1 LOP nd > VAL nd > > the two lines come from the fact that you included unit as a by variable > and here unit has two values, blank and 'nd'. > > Nat Wooding > > > ```

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