My SAS CODE:
PROC SQL;
INSERT INTO Member_ICD10_LOB
SELECT
LOB,
Member_ID,
Last_Name,
First_Name,
Disease_Name,
DIAG1,
DIAG2,
DIAG3,
DIAG4,
DIAG5,
SERVICE_FROM_DATE
FROM Member_Claims_0100;
QUIT;
Get error:
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.
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
Ok, I havev cheeckd coulmns, found out wrong column.
Thank you, now is working.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.