INSERT Errors

[JHE]

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.

[art297]

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

[JHE]

Ok, I havev cheeckd coulmns, found out wrong column.

Thank you, now is working.