07-13-2017 05:25 PM
My SAS CODE:
INSERT INTO Member_ICD10_LOB
ERROR: INSERT statement does not permit correlation with the table being inserted into.
ERROR: The reference to Disease_Name appears to refer to a variable in the table being inserted into.
07-13-2017 06:30 PM
Do your fields match? The following works for me:
data Member_Claims_0100; input name $ sex $ age height weight; cards; Arthur M 73 72 180 Sandra F 65 60 105 ; data Member_ICD10_LOB; set sashelp.class; run; PROC SQL; INSERT INTO Member_ICD10_LOB SELECT name, sex, age, height, weight FROM Member_Claims_0100 ; QUIT;
Art, CEO, AnalystFinder.com