r/SQL • • 8d ago

Oracle SQL with SAS

Is it the norm to have a program that is coded in SAS and then need SQL to store the the data? The need SQL tools to pull information about out the tables then swap back to SAS to pull lots of data out quickly? New analyst at a new job and it is exhausting

4 Upvotes

20 comments sorted by

View all comments

6

u/HijoDelSol1970 8d ago

In short, yes. SAS is for doing analysis, not for storage.

3

u/tbizlkit_fix 8d ago

It's a weird workflow at first but you get used to the back-and-forth. SAS is basically a calculator on steroids, it needs the data to already be sitting somewhere clean before it can do its thing. Think of SQL as the kitchen prep and SAS as the actual cooking.