topic Re: macro variables in PROC FEDSQL in SAS Programming

macro variables in PROC FEDSQL

sateh — Wed, 02 Nov 2022 19:35:30 GMT

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 — Wed, 02 Nov 2022 19:43:37 GMT

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 — Wed, 02 Nov 2022 19:45:39 GMT

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 — Wed, 02 Nov 2022 19:47:55 GMT

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

sateh — Wed, 02 Nov 2022 19:53:44 GMT

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

PeterClemmensen — Wed, 02 Nov 2022 19:53:51 GMT

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__ — Wed, 02 Nov 2022 19:57:59 GMT

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

Kurt_Bremser — Wed, 02 Nov 2022 19:59:51 GMT

Show the code for a single document.

Quentin — Wed, 02 Nov 2022 20:10:14 GMT

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