Create new observation from 'or' statement

Reply
Contributor
Posts: 44

Create new observation from 'or' statement

Here's a scenario:

data have;

  input id x $;

  cards;

1  a

2  b

3  a or b

;

run

data want;

  input id x $;

  cards;

1  a

2  b

3  a

3  b

;

run;

Could someone please suggest code to get 'data want' from 'data have'? Thanks.

Super Contributor
Posts: 644

Re: Create new observation from 'or' statement

Here is a one step solution

data have;

  Infile cards missover ;

  input id x $ @ ;

  output ;

  input @'or' x ;

  If not missing(x) then output ;

  cards;

1  a

2  b

3  a or b

;

run ;

Richard

Super User
Posts: 10,035

Re: Create new observation from 'or' statement

data have;
  input id x $10.;
  cards;
1  a
2  b
3  a or b
;
run;
data want(drop=i x);
 set have;
 length y $ 10;
 do i=1 to countw(x);
  y=scan(x,i);
  if y ne 'or' then output;
 end;
run;
  

Xia Keshan

Trusted Advisor
Posts: 1,228

Re: Create new observation from 'or' statement

data want(drop= i x rename=(y=x));

set have;

i=1;

do while (scan(x,i,'or ') ne ' ');

id=_n_;

y=scan(x,i,'or ');

output;

i=i+1;

end;

run;

Ask a Question
Discussion stats
  • 3 replies
  • 203 views
  • 0 likes
  • 4 in conversation