BookmarkSubscribeRSS Feed
sateh
Obsidian | Level 7

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

 

sateh_1-1667417632327.png

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.

8 REPLIES 8
sateh
Obsidian | Level 7

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

sateh
Obsidian | Level 7


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

PeterClemmensen
Tourmaline | Level 20

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__
Jade | Level 19

"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
Super User

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 8 replies
  • 2261 views
  • 0 likes
  • 5 in conversation