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,788

## 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

Posts: 1,270

## 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;

Discussion stats
• 3 replies
• 228 views
• 0 likes
• 4 in conversation