Displaying 3 results from an estimated 3 matches for "biomass_data".
2009 Apr 21
3
create objects in a loop and adding sqlQuery content to them
...t into an
object named 'sitex_data'.
Somehow I'm really missing something as I'm not able to create these
sitex_data objects with
the database values, neither using list nor assign...
Here some code snipplets:
>library (RODBC)
>channel <- odbcConnectExcel2007 ("biomass_data.xlsx")
>site_data <- sqlQuery(channel, "select site_no from [biomass_data
$] group by site_no")
#Here the values I want to loop through
>str(site_data)
'data.frame': 44 obs. of 1 variable:
$ site_no: num 4 7 9 10 15 16 17 18 19 20 ...
#Here my first try...
2009 May 19
2
create string of comma-separated content of vector
...reate a string of the comma-separated content of a vector?
I've got the vector i with several numeric values as content:
>str(i)
num 99
and want to create a SQL statement to look like the following where
the part '(2, 4, 6, 7)' should be
the content of the vector i:
select * from [biomass_data$] where site_no in (2, 4, 6, 7)
Here my approach (which doesn't work):
site_all_data <= sqlQuery(channel, "select * from [biomass_data$]
where site_no in (",paste(i,sep=","),") )
sorry for spaming so much today to the mailing list...
-Katharina
--
Time flies...
2009 Jul 20
1
package lmodel2: p-value RMA fitting?
...f lm?
Sorry for bothering everybody with this, well, probably rather idiotic
question, but I don't know where to
continue from this point...
Thanks,
Katharina
Here the output of my lmodel2 regression:
Model II regression
Call: lmodel2(formula = log(AGB) ~ log(BM_roots), data = biomass_data,
range.y = "interval", range.x = "interval", nperm = 99)
n = 1969 r = 0.9752432 r-square = 0.9510993
Parametric P-values: 2-tailed = 0 1-tailed = 0
Angle between the two OLS regression lines = 1.433308 degrees
Permutation tests of OLS, MA, RMA slopes: 1-tailed, tail c...