macro variables in PROC FEDSQL

[sateh]

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.

[Kurt_Bremser]

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?

[sateh]

because I need to take the document variable to create tables for each document, and the c variable to apply in a formula

[Kurt_Bremser]

Use BY in the procedures to create multiple tables/reports, no macro variables needed.

[sateh]

I don't understand when you refer to BY, could you provide me with an example please?

[Kurt_Bremser]

Show the code for a single document.

[PeterClemmensen]

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.

[data_null__]

"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.

[Quentin]

Can you show the error messages you get from running the PROC SQL step?