I was joining two simple tables that reside on an SQL server and thought I would check if there was a difference if I named the parent table first or second. There was and I can't figure out why. Can anyone help please?
I am also wondering what happens when variables have the same name?
Here is the log:
proc sql noprint; create table cmd1 as select b.*, a.* from cmdclaim.claim a, cmdclaim.claimdetail b where b.claimid=a.claimid order by a.claimid; WARNING: Variable ClaimID already exists on file WORK.CMD1. WARNING: Variable DiagnosticCode already exists on file WORK.CMD1. WARNING: Variable ModifiedDate already exists on file WORK.CMD1. WARNING: Variable CreatedDate already exists on file WORK.CMD1. NOTE: Table WORK.CMD1 created, with 50788 rows and 48 columns.
16 quit; NOTE: PROCEDURE SQL used (Total process time): real time 15.14 seconds cpu time 3.41 seconds
proc sql noprint; create table cmd1 as select b.*, a.* from cmdclaim.claim a, cmdclaim.claimdetail b where a.claimid=b.claimid order by a.claimid; WARNING: Variable ClaimID already exists on file WORK.CMD1. WARNING: Variable DiagnosticCode already exists on file WORK.CMD1. WARNING: Variable ModifiedDate already exists on file WORK.CMD1. WARNING: Variable CreatedDate already exists on file WORK.CMD1. NOTE: Table WORK.CMD1 created, with 50811 rows and 48 columns.
23 quit; NOTE: PROCEDURE SQL used (Total process time): real time 14.73 seconds cpu time 3.54 seconds
I would appreciate any help understanding the difference in the results.
Sally
... View more