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

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 2338 views
  • 0 likes
  • 5 in conversation