It's doing what you tell it to do.

Try removing UNIT from the BY statement in the PROC TRANSPOSE step.

Comment: It was easy to work with this problem because self-contained, ready-to-run code was provided.

On Thu, 1 May 2003 10:48:55 -0700, Sam <gowdar@ADVBIOL.COM> wrote:

>Hi , > > Here is the data and i am trying to transpose the data .But its >leaving a space and going to next line when i transpose the unit val >.Please let me know why . > >Thank you > > >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 unit; >RUN; > >PROC TRANSPOSE DATA=XX OUT = T_XX; >ID DAY; >BY PT CAT TEST INVN unit; >VAR VAL; >RUN; >PROC PRINT DATA = T_XX; >RUN;