Import data in R - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Import data in R

Import data in R# Database - 数据库

s*e2009-06-16 07:06

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*e2009-06-16 07:06

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