DATA Step, Macro, Functions and more

INSERT Errors

Reply
Frequent Contributor
Frequent Contributor
Posts: 98

INSERT Errors

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.

 

PROC Star
Posts: 7,492

Re: INSERT Errors

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

Frequent Contributor
Frequent Contributor
Posts: 98

Re: INSERT Errors

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

 

Thank you, now is working.

 

 

Ask a Question
Discussion stats
  • 2 replies
  • 120 views
  • 0 likes
  • 2 in conversation