topic data btw brackets in SAS Procedures

data btw brackets

cathy_sas — Wed, 26 Aug 2015 03:09:40 GMT

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 — Wed, 26 Aug 2015 03:23:55 GMT

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 — Wed, 26 Aug 2015 03:34:09 GMT

Thanks reeza!!!

but i tweaked little bit

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

Thanks

Cathy