Update value in table

[hexx18]

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

[Kurt_Bremser]

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

[hexx18]

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

[PGStats · Accepted solution]

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;

[hexx18]

x,c_ga is from apple.zz table

and drd from apple.hh table

[hexx18]

It worked . Thank you So much