DI Studio client side logs are usually found here: C:\Users\username\AppData\Roaming\SAS\SASDataIntegrationStudio\DIStudioVersion   ... View more

I haven't used it myself, just read through some papers around it. There are quite a few vidoes avilable. For 9.4, here's the users guide, which could server as a starting point: SAS Help Center: SAS® Environment Manager 2.5: User’s Guide, Third Edition If you not already have this set up, and you are not familiar with SAS products, you may need to ask yourself why you need to this? If you need to find out specifically what SAS products are actually used, try to find your users and send them an inquiry/interview them. Yet another options is to run a SAS Contents Assessment, which give you quite some information about your current environment. To fully utilise this you need access to SAS Visual Analytics platform though... SAS Help Center: SAS 9 Content Assessment ... View more

Do you mean how often users are accessing these modules/products?   Here's an old paper that describes a method, probably requieres a bit of adjustment to fit your site: Tracking SAS Licensed Product Usage   Is this a SAS server installation? If you also have a SAS Environment Manager availbale on that server, you could proably configure that to give you statistics like this. ... View more

I would say the top 8 of your list is usually referred to as SAS Foundation products. For stand-alone Base SAS installations, I think Enterprise Guide is included in the license, but it's not considered to be a part of Base SAS. This is 9.4. When it comes to Viya 4, that's is a different story. ... View more

SAS can't handle delimeters OOTB with more than one character. If you can recreate the file using quotation around your char variables, and a single char as a delimter, it would hopefully work. Your other option is to write your own program to deal with this record layout, using a data step. ... View more

Definie "automate".   If you need to repeat the jobs and perdform updates due to new folders and variables, sure, I would build macro programs to do the job. But it's not a super quick task, but here are som general thoughts.   You need a libname for each folder, so have  a list/dataset with paths and name for each libref, use a data step with call execute to assign them. If they are already assigned, you could go the other way around and fetch this informaiton from DICTIONARY.LIBNAMES using proc sql;   In macro lop over the dat stes from each folder, potentially build a view on each table where you add the folder path in a new variable, and at the end concatenate all of them. If your datsets are not big you would be fine using a KEEP statement in the data step that concatenets the data. Otherwise generate a KEEP= data set option when you first read each data set. ... View more

I agree with @PaigeMiller here. The only (?) reason to do it in SQL if your (large) data resides in an external databbase, so you can push the query there. Then you need to join with table B three times, and using Rank in the join criterias.   ... View more

No experience, but given the documentation ODBC is your choice if you want some kind of plug-and-play inteface. Since DUckDB is an OLAP engine, I thought that OLEDB for OLAP should an appropriate choice, but they doesn't seem to support OLEDB. ... View more

Non-tested code since you disn't provide raw data as a data step/datalines: proc sql; select name, max(sales_date) as last_sales_date, count(*) as no_of_sales, sum(sales) as run_sales_tot, '31Dec2023'd - calculated last_sales_date as no_of_days_last_to_31dec2023 from have group by name ; quit; ... View more

If you got your dataframe result to a SAS dataset, you can formats to the columns you need to have a specified numger of decimals: proc datasets lib=library-name; modify sas-dataset-name; format variable-name 22.16; run; quit; ... View more

You could try using OR in the join criteria. You might end up with duplicates that way, but I know too little of your data to give more specific advice. Is it possible to post test data as datalines in a data step? ... View more

SCAN function works for this kind of scenarios: SAS Help Center: SCAN Function ... View more

My SAS FIles is a folder in the Metadata server, and is set-up by default for each metadata user. It has nothing to do with SASUSER. The purpose is to have a playpen for you to store SAS content for your own needs, like testing/development. Typical object to store here could be Stored Processes, EG projects etc. ... View more

You mean running in batch vs running inside DI Studio application? Please share logs. ... View more