DATA Step, Macro, Functions and more

Subsetting Data

Accepted Solution Solved
Reply
Regular Contributor
Posts: 192
Accepted Solution

Subsetting Data

Hi, I need to identify which observations have a certain value.

I tried the code below but am getting the error message 'array subscript out of range'.

data check;
set all;
array pct  con_pct t_pct pm_pct pb_pct oth_pct;
if pct(i) in ('G1%', 'G2%', 'G5%');
run;

What am I doing wrong?

 

 

Thanks!


Accepted Solutions
Solution
3 weeks ago
Super User
Posts: 17,840

Re: Subsetting Data

Are you expecting the percent (%) sign to act as a wildcard? That won't work, it will check for exactly that string. If you're looking for strings that start with those components consider the colon. But TEST it out thoroughly for their needs.

 

do i=1 to dim(pct);
if pct(i) in: ('G1', 'G2', 'G5') then flag=1;
end;

View solution in original post


All Replies
Trusted Advisor
Posts: 1,615

Re: Subsetting Data

The obvious issue is that you have NOT set a value for variable i. There may be other problems as well.

Solution
3 weeks ago
Super User
Posts: 17,840

Re: Subsetting Data

Are you expecting the percent (%) sign to act as a wildcard? That won't work, it will check for exactly that string. If you're looking for strings that start with those components consider the colon. But TEST it out thoroughly for their needs.

 

do i=1 to dim(pct);
if pct(i) in: ('G1', 'G2', 'G5') then flag=1;
end;
☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 81 views
  • 0 likes
  • 3 in conversation