If then column value

BETO — Mon, 06 Apr 2015 21:37:14 GMT

hi I have a table that looks like thi

. City. Market. Sub market

Houston. A. b

NeW York. Q

san fran.

Austin. D.

i have a data step looks like this

ddata report; set report;

if sub market = ( .) then market = sub market;

run;

i shan't the value that is in the maket column an not the word sub market if market is blank as well thN it should default to city value not name city ...thanks again

Re: If then column value

Patrick — Mon, 06 Apr 2015 21:45:54 GMT

The coalescec() function will return the first non-missing character value from a list.

data report;

set report;

sub_market=coalescec(sub_market, market, city);

market=coalescec(market, city);

run;

topic If then column value in SAS Procedures

If then column value

Re: If then column value