Is there an SQL UPDATE equivlant in SAS?

[dkaplan]

Is it possible, using only SAS syntax, to update a single existing dataset?

The SQL equivalent would be:

UPDATE myTable
SET city = 'Paris'
WHERE id = 22

P.S.

I know this could be done using proc sql. I'm new to SAS and trying to learn the SAS syntax.

 

[TysonLPrice]

Look into Proc SQL

http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_91/base_sqlproc_6992.pdf

 

[dkaplan]

Thanks, TLP

I also found a way to do it in SAS syntax.

data myLib.originalDataset;
set myLib.originalDataset;
if id = 22 then city = 'Paris';
proc print data = myLib.originalDataset;
run;