data btw brackets

[cathy_sas]

Hi All,

My data look like below format . I need col value in two variable , N & pct.

have:

id           col

100        239  ( 34.5)

101         67  (100.0)

103           0

104            8 (  6.9)

105        58   (     5.2)

want:

id           col                         n         pct

100        239    ( 34.5)        239      34.5

101         67  (100.0)           67       100.0

103           0                         0

104            8 (  6.9)              8        6.9

105         58  (    5.2)            58       5.2

Thanks

Cathy

[Reeza · Accepted solution]

Use the Scan function, but you might need or want to account for cases where it's 0.

n=scan(original_var, 1, "(");

pct=scan(original_var, 2, "(");

[cathy_sas]

Thanks reeza!!!

but i tweaked little bit

pct=scan(original_var, 2, "()");

Thanks

Cathy