If then column value

[BETO]

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

[Patrick · Accepted solution]

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;