01-10-2019
rbikes
Obsidian | Level 7
Member since
03-20-2015
- 18 Posts
- 1 Likes Given
- 2 Solutions
- 0 Likes Received
-
Latest posts by rbikes
Subject Views Posted 1293 01-07-2019 06:45 PM 1363 12-10-2018 01:41 PM 880 12-10-2018 01:31 PM 660 12-10-2018 12:59 PM 950 12-10-2018 12:30 PM 2234 10-12-2016 04:09 PM 3674 06-14-2016 03:04 PM 2867 06-13-2016 12:12 PM 2888 06-10-2016 02:26 PM 2893 06-10-2016 02:19 PM -
Activity Feed for rbikes
- Posted Re: How to get the change rate using proc mixed? how to explain proc mixed output? on SAS Programming. 01-07-2019 06:45 PM
- Posted Re: How to get the change rate using proc mixed? how to explain proc mixed output? on SAS Programming. 12-10-2018 01:41 PM
- Posted Re: proc mixed with baseline age centered. Do I need add baseline age to all follow up visits? on SAS Programming. 12-10-2018 01:31 PM
- Posted Re: odds ratio and class interval for numeric values(Dependent and independent) on SAS Programming. 12-10-2018 12:59 PM
- Posted Re: DO Loop on SAS Programming. 12-10-2018 12:30 PM
- Posted Re: aggregate frequencies on SAS Programming. 10-12-2016 04:09 PM
- Posted Re: Unicode in a format to change output of proc template and proc sgender on Graphics Programming. 06-14-2016 03:04 PM
- Posted Re: Unicode in a format to change output of proc template and proc sgender on Graphics Programming. 06-13-2016 12:12 PM
- Posted Re: Unicode in a format to change output of proc template and proc sgender on Graphics Programming. 06-10-2016 02:26 PM
- Posted Unicode in a format to change output of proc template and proc sgender on Graphics Programming. 06-10-2016 02:19 PM
- Posted Re: Condense a data set variables columns into one on SAS Data Management. 05-02-2016 04:51 PM
- Liked Re: Condense a data set variables columns into one for ballardw. 05-02-2016 04:51 PM
- Posted Condense a data set variables columns into one on SAS Data Management. 05-02-2016 01:31 PM
- Posted Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server? on Microsoft Integration with SAS. 03-23-2015 02:20 PM
- Posted Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server? on Microsoft Integration with SAS. 03-23-2015 01:59 PM
- Posted Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server? on Microsoft Integration with SAS. 03-23-2015 01:23 PM
- Posted Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server? on Microsoft Integration with SAS. 03-23-2015 01:17 PM
- Posted Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server? on Microsoft Integration with SAS. 03-20-2015 05:42 PM
-
Posts I Liked
Subject Likes Author Latest Post 1
01-07-2019
06:45 PM
If you just want to find the slop I would suggest to follow this tutorial by Rick Wicklin
https://blogs.sas.com/content/iml/2013/02/27/slope-of-a-regression-line.html
... View more
12-10-2018
01:41 PM
The estimate is only the estimate of the dependent variable. Here, the dependent variable is bmd, is bmd a change rate? Looking at the structure I would say it isn't. Assuming I am correct I would suggest you create baseline variable and then from that and bmd calculate the change and use the change variable as the dependent variable and also include baseline into the model.
... View more
12-10-2018
01:31 PM
Yes, you would need to have a column that just has baseline age per person.
... View more
12-10-2018
12:59 PM
Yes as you said to follow the Odds Ratio approach you need to create a binary variable.
data have2;
set have;
obese = (read>=30);
run;
proc logistic data = have2;
model obese = age ;
run ;
But I highly recommend you review the following:
https://stats.idre.ucla.edu/sas/dae/logit-regression/
https://stats.idre.ucla.edu/sas/faq/in-proc-logistic-why-arent-the-coefficients-consistent-with-the-odds-ratios/
... View more
12-10-2018
12:30 PM
Could you do something like this? instead of sashelp.class use your dataset and instead of AGE use the code var, and use 1 and 2 for 14 and 15.
proc freq data=sashelp.class;
where AGE in (14 15);
table age;
run;
... View more
10-12-2016
04:09 PM
Could you give an example of a the double freq you mentioned or point me some where that does?
... View more
06-14-2016
03:04 PM
I found a solution, it was from moving the
linearopts=(
tickvaluelist=(1 2)
tickdisplaylist= ("< 5 Years" "^{unicode '2265'x} 5 Years") tickvaluefitpolicy=none
)
unicode from the format to the tickdisplaylist. It looks like the following:
... View more
06-13-2016
12:12 PM
Thank you Sanjayand RIck for responding. But uncofcentialy when I added in the (*ESC*) within the format it still donest work. I am running SAS 9.3 TS level 1M2 on windows
proc format;
value age
1="< 5 Years"
2="(*ESC*){unicode '2265'x} 5 Years";
run;
data race;
infile datalines dlm=',';
input age score;
datalines;
1,12
2,14
1,17
1,10
2,7
2,4
1,6
2,8
;
run;
proc template;
define statgraph plot_race;
begingraph /border=false designwidth=800px designheight=500px;
layout overlay/walldisplay=none
yaxisopts=(label="Scroe"
linearopts=(tickvaluelist=(0 5 10 15 20) viewmin=0 viewmax=20))
xaxisopts=(Label="age" type=linear display=(line ticks tickvalues)
linearopts=( tickvaluelist=(1 2)
tickvalueformat=age.
tickvaluefitpolicy=none));
scatterPlot x=eval(0.08*rannor(57)+age) y=score / name="sp1"
markerAttrs=GraphData1
dataTransparency=0.5;
boxplot x=age y=score /boxwidth=0.2 display=(caps mean median)
meanAttrs=(symbol=plus);
endlayout;
endgraph;
end;
run;
ods rtf file="C:\Users\[NAME]\Downloads\Test Score" style=myjournal BODYTITLE_AUX nogtitle nogfootnote;
ods graphics/ height= 4in width=6.4in;
options orientation=landscape;
ods escapechar='^';
title1 "Results";
proc sgrender data=race template=plot_race;
run;
ods rtf close;
ods listing;
if that helps.
... View more
06-10-2016
02:26 PM
Sorry, I do know about ods escapechar, but it still doesn't work. ( updated code with it in there)
proc format;
value age
1="< 5 Years"
2="^{unicode '2265'x} 5 Years";
run;
data race;
infile datalines dlm=',';
input age score;
datalines;
1,12
2,14
1,17
1,10
2,7
2,4
1,6
2,8
;
run;
options orientation=landscape;
ods escapechar='^';
proc template;
define statgraph plot_race;
begingraph /border=false designwidth=800px designheight=500px;
layout overlay/walldisplay=none
yaxisopts=(label="Scroe"
linearopts=(tickvaluelist=(0 5 10 15 20) viewmin=0 viewmax=20))
xaxisopts=(Label="age" type=linear display=(line ticks tickvalues)
linearopts=( tickvaluelist=(1 2)
tickvalueformat=age.
tickvaluefitpolicy=none));
scatterPlot x=eval(0.08*rannor(57)+age) y=score / name="sp1"
markerAttrs=GraphData1
dataTransparency=0.5;
boxplot x=age y=score /boxwidth=0.2 display=(caps mean median)
meanAttrs=(symbol=plus);
endlayout;
endgraph;
end;
run;
ods rtf file="Test Score" style=myjournal BODYTITLE_AUX nogtitle nogfootnote;
ods graphics/ height= 4in width=6.4in;
title1 "Results";
proc sgrender data=race template=plot_race;
run;
ods rtf close;
ods listing;
... View more
06-10-2016
02:19 PM
Hi everyone, I have this fomat that has a unicode for greater or equal to and would like to use a chatagory in a graph similar to the output of this example code below.
Thanks ahead of time!
proc format;
value age
1="< 5 Years"
2="^{unicode '2265'x} 5 Years";
run;
data race;
infile datalines dlm=',';
input age score;
datalines;
1,12
2,14
1,17
1,10
2,7
2,4
1,6
2,8
;
run;
proc template;
define statgraph plot_race;
begingraph /border=false designwidth=800px designheight=500px;
layout overlay/walldisplay=none
yaxisopts=(label="Scroe"
linearopts=(tickvaluelist=(0 5 10 15 20) viewmin=0 viewmax=20))
xaxisopts=(Label="age" type=linear display=(line ticks tickvalues)
linearopts=( tickvaluelist=(1 2)
tickvalueformat=age.
tickvaluefitpolicy=none));
scatterPlot x=eval(0.08*rannor(57)+age) y=score / name="sp1"
markerAttrs=GraphData1
dataTransparency=0.5;
boxplot x=age y=score /boxwidth=0.2 display=(caps mean median)
meanAttrs=(symbol=plus);
endlayout;
endgraph;
end;
run;
ods rtf file="Test Score" style=myjournal BODYTITLE_AUX nogtitle nogfootnote;
ods graphics/ height= 4in width=6.4in;
title1 "Results";
proc sgrender data=race template=plot_race;
run;
ods rtf close;
ods listing;
... View more
05-02-2016
04:51 PM
Thanks for replying ballardw!
The function is great! I appericate your time, next time I will spicify what I am looking for.
rbikes
... View more
05-02-2016
01:31 PM
Hello,
I am trying to create a condensed dataset from one that has a stepwise apperence. I started by thinking of listing the column varables names and setting those varables names that repeat to the same column. I did this by collecting the names into double ampersand macro varables list, one appersand for the subgroup name and the other appersand for the count of repeated varables. Then I conducted a %if %else condition with %index. Now it seemed to work fine, but the and find some TRUE results, but it dones't seem to like to output to static varable names:
%else %if %index(&&b&i, 2)>0 %then C3=resolve('&&b&i');
MLOGIC(DOIT): %IF condition %index(&&b&i, 2)>0 is TRUE
NOTE: Line generated by the invoked macro "DOIT".
36 C3=resolve('&&b&i')
--
22
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=, <>, =, >,
><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=.
Here bellow is a relpicated issue:
%let a1 = a5;
%let a2 = a6;
%let a3 = a7;
%let a4 = a8;
%let obs = 4;
data prop;
input a5 a6 a7 a8;
n=_n_;
cards;
1 . . .
. 2 . .
. 2 . .
. . 3 .
. . 3 .
. . 3 .
. . . 4
. . . 4
. . . 4
. . . 4
;
run;
options mlogic;
%macro doit1();
data prop2;
length f 3.;
set prop;
by n;
%do i=1 %to &obs;
%if %index(&&a&i,5)>0 %then e=&&a&i;
%else %if %index(&&a&i,6)>0 %then e=&&a&i;
%else %if %index(&&a&i,7)>0 %then e=&&a&i;
%else %if %index(&&a&i,8)>0 %then e=&&a&i;
%end;
run;
%mend;
%doit1;
options nomlogic;
... View more
03-23-2015
02:20 PM
I found a potential solution, here. SAS Downloads: SAS PC Files Server
... View more
03-23-2015
01:59 PM
It turns out I am running a 32 bit MS Office, sorry about the missup and found this link. 38779 - The 64-bit edition of SAS/ACCESS® 9.2 Interface to ODBC running in a 64-bit Windows operating environment requires 64-bit ODBC drivers Is there any update to this, or do we still need to use older SAS programs?
... View more
03-23-2015
01:23 PM
Here is the error for the point and click. ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. Now using the libname: libname mdb pcfiles path="test.mdb"; I get this error: ERROR: Unable to locate pcfserver.exe. Please install PC Files Server. ERROR: Error in the LIBNAME statement. Which is so weird to me becase when I run this code it shows that I have PC Files and accessing excel files works just fine....: ---SAS/ACCESS Interface to PC Files
... View more