What OS does your SAS App server run on? If it is Windows then SAS users need the logon as batch job credential. On other OSs the ability to logon to the SAS App server is necessary. We may wish to open a Tech Support as more diagnosing imay be required.  ... View more

This doesn't look too difficult, but you'll need to supply some made up sample data for us to program with.  We would only need up to 5 loans, plus maybe 2 years of history by month. Please supply this in a DATA step using the DATALINES statement.   Not sure why all your dates are character as every banking database I use has dates stored as numbers so you can easily to date calculations.  ... View more

There are literally hundreds of Unix commands and they vary in syntax between Unix flavours. If you have a specific requirement then post what it is but you should also just be able to google and find the command you want anyway. ... View more

Try this. The SMALLEST function ignores missing values: data new; set old; MAX_IR = max(of IR00 - IR40); if IR00 = 0 then IR00 = .; if IR10 = 0 then IR10 = .; if IR20 = 0 then IR20 = .; if IR30 = 0 then IR30 = .; if IR40 = 0 then IR40 = .; MIN_IR = smallest(of IR00 - IR40); run; ... View more

I'd also suggest checking the Windows Event Viewer, in case there are other errors happening to trigger the EG problem. ... View more

@epower - I note you are using 32-bit EG 8.3. I'm wondering if EG 8.4 is only available as 64-bit? Maybe @ChrisHemedinger can chime in. ... View more

@epower  - If you are not seeing the update then you have a different problem. Your organisation could be blocking access to sas.com websites to check for updates. I'm still waiting for a fix for our file download problems. Our IT security folks have agreed they caused the problem... ... View more

Yours is the second recent post on this topic. Here is the other one that may be of some help: https://communities.sas.com/t5/SAS-Programming/How-to-Stop-amp-Restart-Query-Every-30-min/m-p/922572#M363274   The obvious question is why can't the time out limit be changed? This could be the result of a firewall rule for example. I suggest you check with your SAS administrator before spending a lot of time working around this limitation - better to cure the disease rather than deal with the symptom. ... View more

I doubt there are many users on the Community who have experience with this specialist prooduct, so opening a Tech Support track will likely get you a faster response. ... View more

This library article describes how this works: https://communities.sas.com/t5/SAS-Communities-Library/Connecting-SAS-Viya-in-the-Cloud-to-on-Premises-Data-Sources/ta-p/922576 ... View more

In my experience FIRSTOBS and OBS are a very efficient way of pulling a small sample of rows from a large dataset so I don't see any need to find a 'better' way as long as it runs reliably and efficiently for your use case. ... View more

Please post your complete SAS log where you are using the SUBCHAR option, including the source code and any notes and errors.   Note, you need to be using SAS 9.4M7 or later to use SUBCHAR with Hadoop. ... View more

That's the SASUSER metadata group which has nothing to do with the SASUSER library and the permissions required for the folder it is using. Talk to your SAS administrator to get this fixed. ... View more

The SAS EVM Manager and Agent manage and collect the data displayed in EVM. The SAS EVM web interface is provided by a separate SAS web app run under web server SASServer2_1.   ... View more