Displaying 2 results from an estimated 2 matches for "sasodbc".
Did you mean:
sasldb
2010 Feb 11
2
SAS and RODBC
...lso use SAS v9.2 on the same box. I just started using the SAS ODBC driver that comes with version 9 of SAS. I have been able to set up an ODBC source for SAS datasets using the driver, and then with RODBC I am able to read a sample SAS dataset.
> library(RODBC)
> ch <- odbcConnect('sasodbc', believeNRows=FALSE)
> df <- sqlQuery(ch, 'select * from sasodbc.class', as.is=TRUE)
> df
Name Sex Age Height Weight
1 Alfred M 14 69.0 112.5
2 Alice F 13 56.5 84.0
3 Barbara F 13 65.3 98.0
4 Carol F 14 62.8 102.5
5 Henry M 14 6...
2007 Apr 06
0
translating sas proc mixed to lme()
...A=psdata.bivar COVTEST METHOD = ml;
CLASS cluster_ID individual_id variable_id ;
MODEL y = Dp Dq / SOLUTION NOINT;
RANDOM Dp Dq / SUBJECT = cluster_ID TYPE=UN G GCORR;
REPEATED variable_id / SUBJECT = individual_ID(cluster_ID) TYPE=UN R RCORR;
RUN;
Here is my try:
dta = sqlQuery(odbcConnect("sasodbc", believeNRows=FALSE), "select * from
psdata.bivar")
v = lme(Y~Dp+Dq-1, data=dta, random=~Dp+Dq-1|cluster_ID, method="ML",
weights=varIdent(form=~1|Dp), corr=corCompSymm(, ~1|cluster_ID/individual_id))
Below is the data if you want to try, and also the outputs that I got...