topic Re: Axis in scatterplot: reflect untransformed values but plot log-transformed values in Graphics Programming

Axis in scatterplot: reflect untransformed values but plot log-transformed values

Dinurik — Mon, 03 Jun 2019 17:42:52 GMT

Could you please help me with this problem?
I am making a scatterplot between ln-transformed levels of testosterone and score on a certain scale. But I need the axis for testosterone to reflect its actual values before transformation. How can I do it?

So far I have been using proc gplot, but as far as I understood from reading proc gplot syntax on support.sas.com I cannot do this in the axis statement. Here is my current code:

symbol1 color=red value=dot height=2 interpol=rl ;
symbol2 color=blue value=square height=2 interpol = rl;
axis1 label=("Testosterone (ng/g)");
axis2 label=(a=90 "Raw Score") order = (0 to 150 by 20);

proc gplot data=model;
plot score*ln_testosterone=sex / haxis=axis1 vaxis=axis2;
run; quit;

I would really appreciate any input!

Re: Axis in scatterplot: reflect untransformed values but plot log-transformed values

Rick_SAS — Tue, 04 Jun 2019 15:17:37 GMT

I suspect you want to use LOGSTYLE=LOGEXPAND on the XAXIS statement, but maybe you want to use LOGSTYLE=LINEAR.

Here is a program that shows both so you can choose.

DATA have;
call streaminit(1);
cnt = 0;
do i = -1 to 3 by 0.4;
   testosterone = 10**i;
   Sex = ifc( mod(cnt,2), 'F', 'M' );
   cnt + 1;
   Score = i + rand("Normal");
   output;
end;
run;

ods graphics / attrpriority=NONE;
proc sgplot data=Have;
series x=testosterone y=Score / group=Sex markers;
xaxis type=log logstyle=logexpand;
run;

proc sgplot data=Have;
series x=testosterone y=Score / group=Sex markers;
xaxis type=log logstyle=linear  label="Testosterone (ng/g)";
yaxis label="Raw Score";
run;

And here's a link to the documentation for the XAXIS statement.

Re: Axis in scatterplot: reflect untransformed values but plot log-transformed values

Dinurik — Mon, 10 Jun 2019 17:45:02 GMT

Thank you!

I tried this with scatter statement instead of series, and removes "markers" option. It worked. Thank you so much!