topic Re: INSERT Errors in SAS Programming

INSERT Errors

JHE — Thu, 13 Jul 2017 21:25:25 GMT

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.

Re: INSERT Errors

art297 — Thu, 13 Jul 2017 22:30:35 GMT

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

Re: INSERT Errors

JHE — Thu, 13 Jul 2017 22:40:02 GMT

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

Thank you, now is working.