The datawarehouse uses SAS 9.1 while on the workstation I'm able to use SAS 9.3.
SAS 9.4 Studio is available through a web browser but it's pretty much a standalone without a proper connection to the datawarehouse yet.
So I'm left with SAS 9.1 on the server and SAS 9.3 on my desktop. I need to connect to the server in order to access the data or SAS tables. Since the server still uses SAS 9.1 and can't be easily configured, I often prefer using SAS 9.3 on my desktop to take advantage of the later features.
The dilemma I have here is that, the data is huge so downloading them to my current desktop is a definite no. But if I want to plot some graphs using Proc Sgplot, I can only do that on my desktop.
So how do I create graphs using proc sgplot (or in fact use any function like cmiss(), anything post SAS 9.1) using SAS desktop
without having to download the data from the server?
Well you could use SAS 9.1 on your server to pre-summarise your data and then just download the summary needed for graphing. Of course you would have to know the type of summary in advance but that shouldn't be too difficult to figure out.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.