BookmarkSubscribeRSS Feed
yassine_ben
Calcite | Level 5

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"

yassine_ben_1-1701648756297.png

 

 

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? 

5 REPLIES 5
Sajid01
Meteorite | Level 14

Can you please share the log?

yassine_ben
Calcite | Level 5

hello

 

you mean the stored process execution log?

Sajid01
Meteorite | Level 14

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.

andreas_lds
Jade | Level 19

Are you 100% sure that SP and EG (?) are processing the same input files?

Quentin
Super User

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.

The Boston Area SAS Users Group is hosting free webinars!
Next webinar will be in March 2025. Until then, check out our archives: https://www.basug.org/videos. And be sure to subscribe to our our email list.

sas-innovate-wordmark-2025-midnight.png

Register Today!

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.


Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 979 views
  • 1 like
  • 4 in conversation