topic Re: Update value in table in SAS Programming

Update value in table

hexx18 — Tue, 25 Sep 2018 19:31:29 GMT

Hi I am trying to update the value for x in table zz

Proc SQL;
Update apple.zz
Set x = 'Y';
         (select * from apple.hh p
             join apple.zz d
       on d.id = p.ID
and p.drd = 20
and c_ga =5
and x = 'N');
Quit;

can anyone please help

Re: Update value in table

Kurt_Bremser — Tue, 25 Sep 2018 20:13:17 GMT

What did you try to do with that select in brackets?

Re: Update value in table

hexx18 — Tue, 25 Sep 2018 21:23:51 GMT

I am not sure if my code works it might be wrong too

Re: Update value in table

PGStats — Tue, 25 Sep 2018 21:33:36 GMT

It is not clear what table c_ga belongs to but the query should either be :

Proc SQL;
Update apple.zz as d
Set x = 'Y'
where 
    x='N' and
    c_ga=5 and
    exists (select * from apple.hh where drd=20 and ID = d.id);
Quit;

/* OR */

Proc SQL;
Update apple.zz as d
Set x = 'Y'
where 
    x='N' and
    exists (select * from apple.hh where drd=20 and c_ga=5 and ID = d.id);
Quit;

Re: Update value in table

hexx18 — Tue, 25 Sep 2018 22:25:25 GMT

x,c_ga is from apple.zz table

and drd from apple.hh table

Re: Update value in table

hexx18 — Tue, 25 Sep 2018 22:45:38 GMT

It worked . Thank you So much