topic replacing a value based on the value of other variabels in SAS Programming

replacing a value based on the value of other variabels

Samero — Tue, 30 Jun 2020 14:12:16 GMT

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

Re: replacing a value based on the value of other variabels

r_behata — Tue, 30 Jun 2020 14:20:20 GMT

Try :

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

Re: replacing a value based on the value of other variabels

ballardw — Tue, 30 Jun 2020 14:33:15 GMT

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.

Re: replacing a value based on the value of other variabels

Samero — Wed, 01 Jul 2020 08:05:14 GMT

no it is not a date it is a key

Re: replacing a value based on the value of other variabels

andreas_lds — Wed, 01 Jul 2020 12:54:24 GMT

Have you tried the code suggested by @r_behata ?

Re: replacing a value based on the value of other variabels

Samero — Wed, 01 Jul 2020 15:04:47 GMT

wow, that worked super, thank you very much

Re: replacing a value based on the value of other variabels

Samero — Wed, 01 Jul 2020 15:06:50 GMT

yes, it has done the trick

Re: replacing a value based on the value of other variabels

Samero — Wed, 01 Jul 2020 15:13:17 GMT

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