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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.