04-11-2017 07:22 PM
I am using SAS 9.4 and have been experimenting with PROC FEDSQL and have been experiencing some weird results as shown below in the log:
As you can see everytime I run it I get a different result (I manually checked the dataset and the rowcount does match the log so that part is consistent). Changing the code back to using proc sql I get the expected row count every time it is run.
Does anyone know why fedsql is giving random results? The input datasets are static and have never changed.
05-16-2017 02:57 PM
I will follow up on this. What data source is the LSPMB library accessing? Also what SAS 9.4 release and platform are you using?
05-16-2017 07:14 PM
LSPMB is given by: LIBNAME LSPmb SPDE "/data/SPDE/M_B_PNCHPI" partsize=1028;
%PUT sys-ver = &sysvlong and OS = &SYSSCP &SYSSCPL;
sys-ver = 9.04.01M3P062415 and OS = LIN X64 Linux