topic Re: What is the most efficient way to extract the percent out of parentheses? in SAS Programming

What is the most efficient way to extract the percent out of parentheses?

Hello_there — Tue, 20 Sep 2022 22:10:57 GMT

data have1;
infile datalines dsd dlm=",";
	input number $;
datalines;
5 (31.4),
3 (12.4),
38 (71.3)
;
run;

Hi, i'm trying to extract then numbers out of the percent and turn them into

numerical values.

The desired result should be:

31.4

12.4

71.3

Thanks!

Re: What is the most efficient way to extract the percent out of parentheses?

ballardw — Tue, 20 Sep 2022 22:17:36 GMT

One way:

data want;
   set have1;
   num = input(scan(number,2,'()'),f5.);
run;

Scan function allows setting what is the delimiter between values of interest so ( and ) seem likely candidates. The second word would start after the ( and end at the ). Input is the function to turn the value in numeric value with an appropriate informat.

@Hello_there wrote:
data have1;
infile datalines dsd dlm=",";
	input number $;
datalines;
5 (31.4),
3 (12.4),
38 (71.3)
;
run;
Hi, i'm trying to extract then numbers out of the percent and turn them into

numerical values.

The desired result should be:

31.4

12.4

71.3

Thanks!

Re: What is the most efficient way to extract the percent out of parentheses?

awesome_opossum — Tue, 20 Sep 2022 22:18:21 GMT

data want; set have;
Newvar = substr(oldvar, 1, 1);
Newvar2 = .;
Newvar2 = Newvar;
run;

Re: What is the most efficient way to extract the percent out of parentheses?

Reeza — Tue, 20 Sep 2022 22:22:27 GMT

Slight variation on @ballardw solution which converts it to an actual percentage.

data want;
   set have1;
   num = input(scan(number,1,'()'),f5.);
   pct = input(scan(number,2,'()'),f5.)/100;
   format pct percent12.1;
run;

Re: What is the most efficient way to extract the percent out of parentheses?

Hello_there — Tue, 20 Sep 2022 23:13:03 GMT

Thank you for the explanation!

Re: What is the most efficient way to extract the percent out of parentheses?

DrAbhijeetSafai — Fri, 19 Jan 2024 05:20:27 GMT

Many thanks. This use of scan function has saved lot of my time. It is very useful where substr is not useful because substr is position specific.

Thank you.

- Dr. Abhijeet Safai