I have a piece of SAS code that make some calculation, and to finish, add a line to a table "T", when I run the code on sas enterprise guide, gives the error below, after a "proc transpose" step, and no line is added to the table "T"
but when I run a stored process, having the same code, it doesn't return the error, and the line is added to the table "T"
anyone ever dealt with the same situation?
Can you please share the log?
hello
you mean the stored process execution log?
Yes.
After all you are executing a SAS code in STP.
Proc transpose is outputing an error and it is quite possible that the source datasets are different.
Are you 100% sure that SP and EG (?) are processing the same input files?
No, that should not happen. Most likely you don't have the same data in scoring_client_p3 for some reason.
That error message means that in your data, there is at least one case where there are multiple records that have the same value for NumDossier and Score_Name.
You could add a step to identify these duplicate values:
proc sort data=scoring_client_p3;
by NumDossier Score_Name;
run;
data dups;
set scoring_client_p3;
by NumDossier Score_Name;
if not (first.score_name and last.score_name);
run;
When you run that in EG, you should see at least two records in dups. Sounds like when you run in it in the stored process, dups will have 0 records. That will confirm there is a difference in your data, which you would need to investigate.
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.