topic Re: Transpose Help !! in SAS Programming

Transpose Help !!

Rhino84 — Tue, 07 Dec 2021 18:16:44 GMT

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

Re: Transpose Help !!

PaigeMiller — Tue, 07 Dec 2021 18:22:06 GMT

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).

Re: Transpose Help !!

Rhino84 — Tue, 07 Dec 2021 18:20:45 GMT

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

Re: Transpose Help !!

Reeza — Tue, 07 Dec 2021 18:22:08 GMT

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

Re: Transpose Help !!

Rhino84 — Tue, 07 Dec 2021 18:30:04 GMT

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

RUN; QUIT;

Re: Transpose Help !!

Reeza — Tue, 07 Dec 2021 18:36:36 GMT

LOG please.

Re: Transpose Help !!

Rhino84 — Tue, 07 Dec 2021 18:41:12 GMT

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

Re: Transpose Help !!

AMSAS — Tue, 07 Dec 2021 18:44:01 GMT

Supply the log
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

Re: Transpose Help !!

Rhino84 — Tue, 07 Dec 2021 18:45:33 GMT

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

Re: Transpose Help !!

Reeza — Tue, 07 Dec 2021 18:46:28 GMT

Post the log please.

Re: Transpose Help !!

Reeza — Tue, 07 Dec 2021 18:49:13 GMT

Re: Transpose Help !!

Rhino84 — Tue, 07 Dec 2021 20:18:03 GMT

Thank you so much REEZA !!