s******e
发帖数: 841 | 1 【 以下文字转载自 Statistics 讨论区 】
发信人: shawjone (保持一个良好的心态), 信区: Statistics
标 题: Import data in R
发信站: BBS 未名空间站 (Mon Jun 15 20:26:38 2009, 美东)
I have a for loop in R, in each loop, I want to import data from a database
using different selection criteria.
I know how to use SQL in R to get data with a fixed criterion, but my
criterion changes in each loop, how can I use an R variable in the SQL query
so that each time I can import different data I want?
Thanks | w*******e
发帖数: 1622 | 2 Dynamic SQL in SQL Server
database
query
【在 s******e 的大作中提到】
: 【 以下文字转载自 Statistics 讨论区 】
: 发信人: shawjone (保持一个良好的心态), 信区: Statistics
: 标 题: Import data in R
: 发信站: BBS 未名空间站 (Mon Jun 15 20:26:38 2009, 美东)
: I have a for loop in R, in each loop, I want to import data from a database
: using different selection criteria.
: I know how to use SQL in R to get data with a fixed criterion, but my
: criterion changes in each loop, how can I use an R variable in the SQL query
: so that each time I can import different data I want?
: Thanks
| b*******y
发帖数: 447 | 3 in R, let a variable change, and paste its value to the query string and
submit.
database
query
【在 s******e 的大作中提到】
: 【 以下文字转载自 Statistics 讨论区 】
: 发信人: shawjone (保持一个良好的心态), 信区: Statistics
: 标 题: Import data in R
: 发信站: BBS 未名空间站 (Mon Jun 15 20:26:38 2009, 美东)
: I have a for loop in R, in each loop, I want to import data from a database
: using different selection criteria.
: I know how to use SQL in R to get data with a fixed criterion, but my
: criterion changes in each loop, how can I use an R variable in the SQL query
: so that each time I can import different data I want?
: Thanks
|
|
