Re: [R] Paasing values to sqlQuery like SAS macro

2012-09-13 Thread ramoss
Thanks I was doing something similar in SAS. I was looping macro based on a dataset containing the values: data _null_; set summary2; mindat=put(datepart(mindate),date9.); min_date='mindat_'|| trim(left(_n_)); put mindate= mindat= min_date=; /*check values in log*/ call symput (min_

Re: [R] Paasing values to sqlQuery like SAS macro

2012-09-13 Thread Thomas Lumley
On Fri, Sep 14, 2012 at 3:54 AM, ramoss wrote: > We lost our SAS licence & I am busy transfering my old SAS programs to R > environment. I am very new to R. In 1 program I was creating SAS macro > vars & passing them into a SQL query to run against the server. There are 3 > variables firm, begi

[R] Paasing values to sqlQuery like SAS macro

2012-09-13 Thread ramoss
Hello, We lost our SAS licence & I am busy transfering my old SAS programs to R environment. I am very new to R. In 1 program I was creating SAS macro vars & passing them into a SQL query to run against the server. There are 3 variables firm, begindt, enddt. # of values for each varies month to