topic Re: Reading % in SAS Procedures

Reading %

R_Win — Wed, 17 Sep 2008 07:04:10 GMT

Hi i have a data set and the observation are having % how can i read it

data x;
input id sal;
cards;
3.4% 7.8%
1.2% 8.9%
run;

data y;
set x;
y=avg(id,sal);
run;
proc print;
run;

how can i read this i have kept $after the variable it was read in first data set bet for second how can i do the calculation .Help me

Re: Reading %

Olivier — Wed, 17 Sep 2008 13:38:36 GMT

Hi.
You can use the PERCENT informat in the INPUT statement.
PS : the AVG function does not exist, its name is MEAN.
[pre]
data x;
input id :PERCENT. sal :PERCENT. ;
FORMAT _numeric_ PERCENT12.2 ;
cards;
3.4% 7.8%
1.2% 8.9%
;
run;

data y;
set x;
y=MEAN(id,sal);
run;
proc print;
run;
[/pre]
Olivier

Re: Reading %

R_Win — Thu, 18 Sep 2008 03:56:59 GMT

Thqs it worked