table update with condition

andy_wk — Tue, 08 Jul 2014 10:55:14 GMT

It should be an easy one but I'm stuck

Proc sql;  UPDATE dicofr SET  
dicofr.period = correspondance.period 
FROM  dicofr INNER JOIN correspondance ON dicofr.name_fic = correspondance.name_fic;

I was thinking my update would be done but I got this error instead.

271 proc sql;

272 update dicofr

273 set dicofr.period = correspondance.period - 73 76

ERROR 73-322: Expecting an =. ERROR 76-322: Syntax error, statement will be ignored.

I've tried with a straight join with a select

proc sql; SELECT * FROM dicofr INNER JOIN correspondance ON dicofr.nom_fic=correspondance.nom_fic;

The select is fine.

How come?

Is my SQL query not correct? I don't think so ...

Edited: It seems the update I want to do is not possible. Is there a way to do what I want with SAS language?

Re: table update with condition

andy_wk — Tue, 08 Jul 2014 12:04:16 GMT

I found my answer.

proc sql;

update dicofr as h1

set period=(select period from correspondance as h2 where h1.name_fic=h2.name_fic)

where name_fic in (select name_fic from correspondance);

quit;

topic Re: table update with condition in SAS Procedures

table update with condition

Re: table update with condition