topic Re: how to scan a value in SAS Programming

how to scan a value

HitmonTran — Thu, 07 Jan 2021 21:57:22 GMT

Hi ,

new to SAS

I have data where i need to extract the % without the "%"

Data (character values):
column 1

11(21.2%)

0(0.0%)

9(17.3%)

5.(9.6%)

want (in numeric values):

column2

21.2

0.0

17.3

9.6

Astounding — Thu, 07 Jan 2021 22:23:10 GMT

You identified the proper tool for the job. Try:

column_2 = scan(column_1, 1, '(' );

ballardw — Thu, 07 Jan 2021 22:47:44 GMT

Scan will return the Character value, so you will need to use an input.

The question, since you are starting with a percent is do you actually want a Percent value: i.e. 21.2% = 0.212 as decimal or 100*0.212 or 21.2

Either of the Y or Z yields 21.2 for the first.

data junk;
  x="11(21.2%)";
  y= input(scan(x,2,'(%)'),6.);
  z= input(scan(x,2,'()'),comma6.);
run;