Hi I want to runing some sql query in RM, and need to use R to generate that sql code.
I'm thinking of sending the sql code to a macro and referring to the macro in "read database" process?
But how do I create/edit a macro in R? Any help's appreciated. Thank you!
Answers
I figured out a way:
generate something in R, and make it the output of R by returning data.frame(x = something)
And send this output data frame into a 'extract macro' process, and extract column x, first row - the content is something.
Code: