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;
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;
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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.