topic Re: Need to extract data which has "*" as value in SAS Programming

Need to extract data which has "*" as value

vraj1 — Thu, 21 Sep 2017 08:18:58 GMT

I have a variable which has caharacter values and i want to extract values which ends with *.

var

5.6 H *

4.3

2.6

9.6 L *

How can i do that?

Re: Need to extract data which has "*" as value

ShiroAmada — Thu, 21 Sep 2017 08:42:42 GMT

Try this....

data WANT;
  set HAVE;
  where indexc(var_char,"*");
run;

Hope this helps.

Re: Need to extract data which has "*" as value

vraj1 — Thu, 21 Sep 2017 09:15:06 GMT

Thanks a lot can i include multiple conditions in it like

  where indexc(var_char,"H*" "L*");

so that i can extract values which has "H*" and "L*"?

Re: Need to extract data which has "*" as value

ShiroAmada — Thu, 21 Sep 2017 09:44:17 GMT

What's next after you have flagged records with "*"?

INDEXC - i think this is limited to just a character you can google it.

Try this....

data want;
  set have;
  where indexc(var,"*");
  chars=catx(" ",scan(var,-2" "),scan(var,-1," "));
run;

Hope this helps.

Re: Need to extract data which has "*" as value

vraj1 — Thu, 21 Sep 2017 09:42:53 GMT

I need to have values only which has either "L*" or "H*" values and the rest be deleted.

Re: Need to extract data which has "*" as value

ShiroAmada — Thu, 21 Sep 2017 09:47:47 GMT

data want;
  set have;
  where indexc(var,"*");
  chars=catx(" ",scan(var,-2" "),scan(var,-1," "));
run;

Re: Need to extract data which has "*" as value

vraj1 — Thu, 21 Sep 2017 09:51:59 GMT

It doesnt work unfortunately

var

8.3

22 *

6.7 H *

120 H *

34 L *

I need the below

var

6.7 H *

120 H *

34 L *

there is space between number and H or L and *

Re: Need to extract data which has "*" as value

ShiroAmada — Thu, 21 Sep 2017 09:56:11 GMT

Here is a better version.

Try this....

data WANT;
  set HAVE;
where indexc(var,"*");

char_used=ifc(find(var,"H *",1),"H *","L *");
run;

Since when a record has an "*" the values are either "H *" or "L *".

If you just want those records containing "H *" or "L *" then remove the assignment statement for char_used.

Hope this helps.

Re: Need to extract data which has "*" as value

vraj1 — Thu, 21 Sep 2017 09:56:10 GMT

Thanks, but this just gives H * or L *

I need the entire values like if it is 345 H * i need the entire 345 H *

Re: Need to extract data which has "*" as value

Astounding — Thu, 21 Sep 2017 10:27:29 GMT

where index(var, 'H *') or index(var, 'L *');

The initial focus on the * led in the direction of using INDEXC. Switch to INDEX.

Re: Need to extract data which has "*" as value

Patrick — Thu, 21 Sep 2017 10:35:35 GMT

@vraj1

Something like below should do.

data have;
  infile datalines truncover;
  input var $20.;
datalines;
8.3
22 *
6.7 H *
120 H *
34 L *

;
run;

/* option 1 */
data want1;
  set have;
  if prxmatch('/(h|l)\s*\*$/oi',strip(var));
run;

/* option 2 */
data want2(drop=_:);
  set have;
  _var=compress(var);
  if upcase(substrn(_var,lengthn(_var)-1)) in ('L*','H*');
run;

/* option 3 */
data want3;
  set have;
  if strip(scan(var,-1,'lh','i')) ='*';
run;

Preferred option: Option 3