I'm not going to scan through your SQL code to figure out the difference. Just tell me, yes or no, are the columns that same in the two SQL calls, and if so, what is the difference? Why two SQL calls creating the same named data set (WORK.query)? What are you trying to say by showing us the two SQL calls?
However when I tried to use the score statement as described in your response, the model failed to predict anything.
Never (that's NEVER, not even once more in the future) should you state something failed and then not explain and not provide evidence. There are two possibilities here:
1. If there is an error or problem in the log, show us the ENTIRE log for PROC LOGISTIC. Please copy the log as text and paste it into the window that appears when you click on the </> icon.
2. If the output is wrong, show us the incorrect output and explain what is wrong.
... View more