Help using Base SAS procedures

If then column value

Accepted Solution Solved
Reply
Regular Contributor
Posts: 240
Accepted Solution

If then column value

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


Accepted Solutions
Solution
‎04-06-2015 05:45 PM
Respected Advisor
Posts: 3,907

Re: If then column value

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;

View solution in original post


All Replies
Solution
‎04-06-2015 05:45 PM
Respected Advisor
Posts: 3,907

Re: If then column value

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;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 160 views
  • 0 likes
  • 2 in conversation