topic plot mean with std error in Graphics Programming

plot mean with std error

sas9 — Mon, 29 Apr 2013 19:06:22 GMT

I am trying to take the mean of the log of a variable. There are some values of the variable which is 1. so the log value will be "0"(zero) value . then i am supposed to take the mean of all the values that contains some '0' too and plot against std error. so when i do proc means i get missing mean as well as std error . i am suppose to plot this mean of the log value of the variable with the std error. Can anyone please guide me to overcome this problem.

Re: plot mean with std error

PGStats — Mon, 29 Apr 2013 19:59:57 GMT

I am not clear as to what your problem is exactly. Which of the following conditions apply to your case. You get missing values...

in the log-transformed value because the value is <= 0
in the mean because the log-transformed values are all missing
in the std because the mean is missing or there is only one nonmissing value

Re: plot mean with std error

sas9 — Mon, 29 Apr 2013 21:43:52 GMT

Thankx for reaching out to me. I do have logarithmic values of the variable as zero since there are some values of the variable which are 1 and when i take log(1) it gives me zero.further to that i take mean of the log value of the variable and st error . the mean as well as stderror comes as missing.

all i want to do is take the log of a variable and then plot mean of the log with the stderror.but the variable has some 1 values.

Re: plot mean with std error

Rick_SAS — Tue, 30 Apr 2013 00:18:23 GMT

I still don't understand the issue. Here are some data that have been log-transformed. The results of PROC MEANS are not missing. Can you modify my DATA step to mimic the data that you have? Or can you explain how your analysis is different ?

data A;

input x @@;

logX = log(x);

datalines;

0 1 2 3 4 5 4 0 3 2 1 2 3

;

proc means data=A mean std;

var logX;

run;

Re: plot mean with std error

sas9 — Tue, 30 Apr 2013 02:19:12 GMT

Thank you Rick for getting back to me.

variable(dose) values are for example 1 1 1 1 1 1.5 1.6 ...

data ds(keep =usubjid dose);

set datax;

where dose ne . ;

dose1 =log(dose);

run;

when i do this where ever dose values are equal to 1 i get dose1 =0

i get a note in logafter i run that part of the code as "mathematical operations could not be performed "and there is "an invalid argument to function log".

then i did

proc means data =datax ;

by usubjid;

var dose1;

output out =datax1 n=n mean=mean stderr=stderr;

run;

the datax1 dataset has values where mean=o and std err=0 and also some values where stderr =missing.

Re: plot mean with std error

PGStats — Tue, 30 Apr 2013 02:36:44 GMT

Your second step doesn't use the dataset named ds created in the first step. Try this instead

data ds(keep =usubjid dose1);
set datax;
where dose > 0 ;
dose1 =log(dose);
run;

proc means data=ds ;
by usubjid;
var dose1;
output out =datax1 n=n mean=mean stderr=stderr;
run;

Re: plot mean with std error

sas9 — Tue, 30 Apr 2013 14:57:15 GMT

Thank you.. your idea of >0 removed the log problem.

I did use the correct dataset in my program but i guess typed it wrong in the sample code that i sent. I am sorry .Thank you very much though.