replacing a value based on the value of other variabels

[Samero]

I have a table like this

Ac1               Ac2       Ac3     ZDS

Stoffwechsel Cycle    osg      9.05.02.

Stoffwechsel Cycle    osh      9.05.02.

Stoffwechsel Cycle                9.05.02.

Stoffwechsel Cycle    osg      9.05.02.

I just want from SAS to replace the ZDS value when Ac2 = Cycle  and Ac3 is missing at the same time (in this cas at the third line), How to do that what to write in SAS?

I tried

if Ac2 = Cycle   and Ac3 = " " then ZDS = 9.05.04.;

run;

but it didn"t work

Many thanks in advance             

[r_behata · Accepted solution]

Try :

if Ac2 = 'Cycle'   and missing(Ac3)  then ZDS = "9.05.04.";

[Samero]

wow, that worked super, thank you very much

[Samero]

but what if it is not a missing value and i wanted to change the third value based on the first two values what will be the code in this case? many thanks

[ballardw]

Is ZDS supposed to be a SAS DATE value? (if so really should use a 4 digit year display format)

The only way to use a literal date value in SAS is to use the "ddMONyy"d or "ddMONyyyy"d construct.

So if you want a date that would be 9 May 2002 use "09May2002"d, if you want 5 Sep 2002 use "05Sep2002"d.

Choice of single or double quotes is yours.

[Samero]

no it is not a date it is a key

[andreas_lds]

Have you tried the code suggested by @r_behata ?

[Samero]

yes, it has done the trick