topic Proc ID Transpose Issue in SAS Programming

Proc ID Transpose Issue

saikiran_nemani — Sat, 02 Dec 2023 06:35:37 GMT

PROC TRANSPOSE DATA=FINAL2

OUT = FINAL3 ;

BY LOAN_NO;

ID new_date1;

VAR INSTL_AMOUNT;

RUN;

ERROR: The ID value "NOV2023" occurs twice in the same BY group.

Can anyone help on above issue ?

Re: Proc ID Transpose Issue

Kurt_Bremser — Sat, 02 Dec 2023 06:52:19 GMT

What it says. You have at least one LOAN_NO group where the NEW_DATE1 value "NOV2023" appears more than once.

For TRANSPOSE to work, you have to de-duplicate the dataset first, so you have to make a decision what you do with the INSTL_AMOUNT values: take only one, sum, maximum, minimum, mean.

Since a wide dataset will not be suited for further analysis, I suspect you need this for reporting purposes, so you should look at PROC REPORT first, as it can handle all this at once (use NEW_DATE1 as an ACROSS variable).

proc report data=final2;
column loan_no instl_amount,new_date1;
define loan_no / group;
define instl_amount / "" analysis sum;
define new_date1 / "" across;
run;

Re: Proc ID Transpose Issue

Cayden — Mon, 11 Dec 2023 14:29:58 GMT

I've encountered the "Proc ID Transpose Issue" before, and it can be quite frustrating. Make sure to double-check your data formatting and variables. If you need help, there are some useful resources online like essay app https://essaypro.app/ to troubleshoot this problem.