Proc ID Transpose Issue

[saikiran_nemani]

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 ?

[Kurt_Bremser · Accepted solution]

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;

[Cayden]

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.