One other thing you can try, run the forllowing Proc Options group=performance; run; within your SAS session to determine what settings you have inplace, then try to tweak them if you can. I'm talking about - memsize= - sortsize= - sumsize= - threads/nothreads   Changing the values of these options can yield better performance. The other SAS options you should have are Fullstimer, and msglevel options fullstimer msglevel=i;   They will inform you of how your SAS system utlizing the available/allocated resources.   Hope this helps, Ahmed ... View more

You way try creating your desired chart(s) using the Custom Graph Builder within SAS VA? How to Use SAS Visual Analytics Graph Builder   Hope this helps, Ahmed ... View more

Check the following page What Is the SAS ODBC Driver? From the On-line User Guide documentation for the SAS ODBC Driver. It describes the purpose of this driver and how it can be used and what other components it requires.   Ahmed  ... View more

Hi,   If I have understood your requirements correctly, I think you are going about it the wrong way!   To gain access to SAS Data Sets/Files residing on a Linux Server from Windows programs, your options are 1. Use SAS/CONNECT if you have it licesened      Connecting Simply with SAS/CONNECT®      SAS/CONNECT    2. Use Linux Samba Server, which helps you to share Linux files and printers with Windows-based PCs and other operating systems   Hope this helps. Ahmed ... View more

Hi,   This kind of issues are better handeled by SAS Tech Support. For several reasons - They may have encountered this issue with other client(s) before, and if not, they can record it for the future - if an issue were to be found in the underlying software, they can work on a patch for you.   Thanks, Ahmed ... View more

Hi Kroken,   I came across this paper and I thought it might be of interest to you. Designing for Performance – Best Practices for SAS® Visual Analytics Reports   Regards, Ahmed ... View more

One more potential way to speed your query, would be - if you have SAS 9.4, you may want to try the Threaded Read feature of Proc DS2, that's available in BASE SAS.   Here is an implementation example   options threads; /* Tells SAS to use threaded processing */ %let have_ds = have; %let filter= va1=2; proc ds2; thread newton/overwrite=yes; /* Some debugging variables */ dcl double count thisThread; drop count thisThread; method run(); SET {select * from &have_ds where &filter}; /* Ability to use FedSql query within DS2 */ /* Assign/Initialize debugging vars */ thisThread=_threadid_; count+1; end; method term(); put '**Thread' _threadid_ 'processed' count 'rows:'; end; endthread; data lib1.want/overwrite=yes; dcl thread newton frac; /* Declare an Instance of the newton thread */ method run(); set from frac threads=4; /* <--- You Change the number of threads to control the threaded reads */ end; enddata; run; quit; Please note, according to the Proc DS2 documentation, "If one computation thread can keep up with the I/O thread, then that single thread is used for all computation."   Ahmed     ... View more

Hi,   If you the following can be applied to you, then your query should run faster: - Your under lying storage system, allows for 50-75 MB/sec sustained I/O throughput - Use SPDE/SPDS for your Output Library (lib1) to speed the writing of your output table http://support.sas.com/rnd/scalability/spde/index.html - Use Index for your Va1 variable to speed the reading of your subset/filtered data   Hope this helps, Ahmed ... View more