Is there a way to create a FEDSQL PROC with the INTO statement for macro variables?
I need to do exactly the same as in the image but with PROC FEDSQL, because then I will use the document and c variables, underlined in yellow
I need PROC FEDSQL because the FROM table is too big and if I use PROC SQL this procedure falls short and resets my session.
You may simply have an overflow of the symbol table. Why do you need to store such a large amount of data in macro variables, anyway?
because I need to take the document variable to create tables for each document, and the c variable to apply in a formula
Use BY in the procedures to create multiple tables/reports, no macro variables needed.
I don't understand when you refer to BY, could you provide me with an example please?
I'm not a FewSQL expert, but I think the interaction with the SAS macro facility is not avaibale in Proc FEDSQL in the same way as Proc SQL.
"Falls short" is a bit vague.
Perhaps you just need the NOPRINT option on PROC SQL.
When your "solution" does not scale you need a different approach.
Give details about what you are trying to do.
Can you show the error messages you get from running the PROC SQL step?
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.