SAS Support Communities

As @Tom has already stated, I don't think there is such a SAS function for checking all available functions nor any way of implementing such a check yourself in FCMP. Why do you want such functionality?   ... View more

@Delgoffe_MCRI  - That's a big improvement! You could try INSERTBUFF values like 15000 and 20000 to see what the optimal value is. ... View more

@SAM_2025  - When you schedule a job in SMC you have to select a scheduling server. If you have licensed Platform Process Manager with SAS then that is one of the options you can select: In that case you are actually using a different scheduler to the other two default SAS options. Scheduled job details are stored in SAS metadata, but that wont tell whether they are actually being used or not. If you use PPM then that has a separate database you could query to get history of scheduled jobs.   ... View more

Having logs of over 2 million rows sounds excessive. Right now you appear to be fixing the symptom rather than the disease. BTW, if you ran your SAS application as a batch job (sas.exe -sysin MySASPgm.sas) you wouldn't need to use DMSLOGSIZE OR PROC PRINTTO.  ... View more

Welcome to the world of SQL subqueries! IMHO these are an underappreciated part of SQL. Once you get into correlated subqueries you will find that they are a very powerful and efficient way of creating result sets from different tables and different levels of data granularity. ... View more

Do you by any chance have to SAS option MPRINT switched on? If so switching it off should significantly reduce log sizes. Just add this to the start of your program: options nomprint; ... View more

To date, you haven't posted any SAS logs of your slow steps. That means we have no idea what techniques you are using. In my experience some techniques are better than others. If you want to make further progress then I suggest you post one or two slow steps so we can get a better idea of what techniques you use. ... View more

@dcacike  - What does your SAS log report when you start a SAS session? If it shows something similar to this: then I suggest your upgrade is successful. I would trust this message more than PROC PRODUCT_STATUS. ... View more

Have you ever tried PROC DATASETS APPEND? We use this with SQL Server and get seriously good performance as long as we also set the INSERTBUFF and DBCOMMIT options: libname AWSLIBNAME redshift server="&secretinformation..us-east-2.redshift.amazonaws.com" database=&database. port=5439 conopts="encryptionmethod=6;validateservercertificate=0;" schema="&schema_name." user=&awsdwid. password=&awsdwpwd. dbcommit = 0 insertbuff = 10000; proc datasets library = AWSLIBNAME nolist; append base = AWS_TABLE_NAME data = SASLIBNAME.SAS_TABLE_NAME; run; quit; Playing with the INSERTBUFF value may improve performance further. ... View more

You haven't posted any SAS logs of your slow select-from and insert-into query steps. It would be helpful to see examples. Often tweeking connection settings can improve performance but without seeing examples it's hard to know what to suggest. ... View more

@DrAbhijeetSafai  - If you want faster action on this then you really need to open a track with SAS Tech Support. Adding comments on old posts wont necessarily result in any action from SAS.  ... View more

You can't get cheaper than free. SODA is free for non-commercial / learning activities. ... View more

In my experience the default settings that tune database loading are not optimal. I've had excellent load performance by adding these options to the LIBNAME or CONNECTION statement pointing at the database: libname MyDB ODBC < connection settings > dbcommit = 0 insertbuff = 10000; However you may need to experiment with these options to get the best performance. ... View more

@amiller  - Run this to confirm your current MEMSIZE setting and post the results:   proc options option = memsize; run; Increasing MEMSIZE may allow your program to work. ... View more

When you've tried the obvious things and you are still stuck, then IMHO opening a track with SAS Tech Support is your best option if you haven't already. Personally I go direct to them with tricky problems and I often have the answer in a day or two. ... View more