Transpose Help !!

[Rhino84]

I need to transpose the table in SAS. Please help

Actual table: This table has 3 million members and my transpose statement is not working. There is some insufficient memory issue that i face.

APP_NO	TYPE	rate
1	1	10.9
1	2	5
1	3	7
2	1	8
2	2	9
2	3	23
3	1	44
3	2	23
3	3	34
.	.
.	.
.	.
n	1	54
n	2	56
n	3	55

after transpose: THe below table should be the final output.

APP_NO	TYPE_1	TYPE_2	TYPE_3
1	10.9	5	7
2	8	9	23
3	44	23	34
.
n	54	56	55

[PaigeMiller]

This table has 3 million members and my transpose statement is not working. There is some insufficient memory issue that i face.

For this situation, and in all future situations, saying something "is not working" and providing no additional information never gets us anywhere. In all situations, we need additional information: specifically, if there is an error in the log, we need to see the log. If there is no error in the log but the output is wrong, show us the code and the desired output (you have shown us the desired output but not the code).

[Rhino84]

I guess my code is wrong. Please help me do this

[Reeza]

Please show us the code and log and we'll be more than happy to assist.

[Rhino84]

PROC TRANSPOSE DATA=less1
OUT=WORK.TRNSTransposed1;
BY APP_NO;
VAR TYPE RATE;

RUN; QUIT;

[Reeza]

LOG please.

[Rhino84]

when i run this, i get this table"

APP_NO source col_1 col_2 col_3
1 TYPE 1 2 3
1 rate 10.9 5 7
2 TYPE 1 2 3
2 rate 8 23 44

[AMSAS]

1. Supply the log
2. Does it work for a smaller subset of the data, i.e. start with 10|50|100 rows to confirm your code is doing what you expect it to do

At the end of the day you might be running out of resources to process the table

[Rhino84]

i am able to transpose now. with out error

APP_NO source col_1 col_2 col_3
1 TYPE 1 2 3
1 rate 10.9 5 7
2 TYPE 1 2 3
2 rate 8 23 44


i get this table and i need to eliminnate one duplicate row from this output

[Reeza]

Post the log please.

[Reeza · Accepted solution]

[Rhino84]

Thank you so much REEZA !!