topic Re: Urgent! Why the same SAS program gives different results? in SAS Programming

Why does the same SAS program gives different results?

xizidememeda — Fri, 06 Nov 2020 11:14:15 GMT

Hi all!

I just have a very urgent question. I find that my SAS program gives different results when run different times. To be concrete, when I run it in this week (for several times), all the results are the same and consistent. However, after several days, like half a month, the results will change even I don't change anywhere (the same code and computer). The program includes several macros, but I check that there is no apparent mistake.

Can you please tell me why this happens? Is there any problem?

I appreciate it very much for your warm help!

Re: Urgent! Why the same SAS program gives different results?

andreas_lds — Fri, 06 Nov 2020 05:56:28 GMT

The community is not the right place to discuss "urgent" matters. Contacting sas technical support is recommended. Because without the code and the complete logs, it is hardly possible to be of any assistance. And i am somewhat sure, that hardly anybody here has the time to analyse "several macros".

Re: Urgent! Why the same SAS program gives different results?

Kurt_Bremser — Fri, 06 Nov 2020 06:11:42 GMT

Same program + different results = different input data.

"input data" can be datasets or files that you import, but also the result of environment-dependent functions like TODAY().

Re: Urgent! Why the same SAS program gives different results?

ballardw — Fri, 06 Nov 2020 10:05:29 GMT

One wonders why if the results are expected to be the same why you are rerunning the "same code"?

Re: Urgent! Why the same SAS program gives different results?

FreelanceReinh — Fri, 06 Nov 2020 10:22:30 GMT

Hi @xizidememeda,

As mentioned by KurtBremser, two runs of the same program on the same input datasets and raw data files can give different results because (1) certain functions or procedures do so or because of (2) changes in the environment:

Less obvious than date/time-dependent or random functions are changes of the observation order. In particular, PROC SQL can possibly deliver results in different orders if not otherwise specified. Among other things, observation order can have an impact on rounding errors in calculations (e.g., by PROC MEANS), which in turn can change the results of comparisons ("if a>b ...").
The environment includes (in)format and function definitions, macros called, global macro variables, system options (e.g. SORTEQUALS), environment variables (e.g. SASAUTOS), external files, the SAS software itself (e.g. updates or hot fixes), other software involved, the operating system and programs running in parallel.

If I had to investigate this and no changes in the environment were known, my first step would be a thorough comparison of the log files. Needless to say, there must be no errors etc. Has the documented number of observations or variables changed anywhere? If not, I would pick one particular value which has changed significantly and trace it back meticulously all the way to the input data.