About ChrisHemedinger

ChrisHemedinger

Here's some logic lifted from one of my processes that I had to guard against network issues like this. It does not produce a clean log but it does allow the process to continue gracefully. The first trick is to check for the existence of the SYS_PROCHTTP_STATUS_CODE macro before checking for a value. In my case I built in some retry logic, but if it fails again then I fall through and give up. %if %symexist(SYS_PROCHTTP_STATUS_CODE) %then %do; %if &SYS_PROCHTTP_STATUS_CODE. ne 200 or &syserr. ne 0 %then %do; %put WARNING: Expected 200, but received &SYS_PROCHTTP_STATUS_CODE., SYSERR = &syserr.; %put Waiting 20 seconds to retry...; %if &SYS_PROCHTTP_STATUS_CODE. eq 403 %then %do; %put Refreshing auth token; %refreshAuthToken; /* special case where I might need to reauth */ %end; data _null_; rc=sleep(20,1); run; /* call macro that retries here */ %if &SYS_PROCHTTP_STATUS_CODE. ne 200 or &syserr. ne 0 %then %do; %put WARNING: Failed again. Expected 200, but received &SYS_PROCHTTP_STATUS_CODE., SYSERR = &syserr.; %let msgerr = Process stopped after 2 consecutive failures: &SYS_PROCHTTP_STATUS_CODE., see log; %end; %end; %else %do; %put HTTP result: &SYS_PROCHTTP_STATUS_CODE. &SYS_PROCHTTP_STATUS_PHRASE.; %end; %if &syserr. = 0 %then %do; /* Process Result Here */ %end; %end; /* SYMEXIST SYS_PROCHTTP_STATUS_CODE */ %else %do; %put ERROR: PROC HTTP failed! %superq(syserrortext); %let msgerr = Errors in fetching data - see log.; %end;

ChrisHemedinger

The tcperror condition -- when it happens -- is at a lower level than what PROC HTTP can catch/detect and report in the status macro variables. As a very frequent user of PROC HTTP, I see it only when there are network glitches or issues that might be triggered by a firewall or other environmental conditions. My only advice is to make sure you are up-to-date on SAS maintenance/hotfix releases, and ensure your network environment is stable/available during your SAS job run.

ChrisHemedinger

Are you using SAS Visual Analytics for this? I'm guessing that's the case given the steps you've described so far. I'll move this topic to the SAS VA forum.

ChrisHemedinger

@PaigeMiller I think it's more mundane than that. I think it's simply a way to get spurious commercial links into other websites to boost SEO for those outfits. I also think it's ineffective at achieving that outcome, but that doesn't stop people from trying.

ChrisHemedinger

You'll need to make a similar change for the SAS.DataSet entries in the Windows Registry: HKEY_CLASSES_ROOT\SAS.DataSet.701\shell\BrowsewithEG.8\command Remove the "/openfile" part of the commands. The /openfile directive will reuse an existing EG session if one is running.

ChrisHemedinger

It looks like you are using SAS Enterprise Miner within the SAS OnDemand environment. I've moved this discussion to the SAS Software for Learning discussion board.

ChrisHemedinger

Excellent approach by @FreelanceReinh. It reminds me of a challenge I had years ago in validating NPI (national provider identity) numbers, which relies on the Luhn algorithm. I also created an FCMP version!

ChrisHemedinger

Your query is comparing a date value -- which is essentially a number -- to a range defined by two other values. Since your example value (01/01/2024) is just a series of characters that SQL won't resolve as a date, you have to take a step to convert it to a number. Maybe that value is coming to you from somewhere else and that's why you don't want to use the '01Jan2024'd date literal format. Instead you could convert it "inline" with a function that will yield a number: %sysfunc(inputn(01/01/2024,mmddyy10))

ChrisHemedinger

"DEV/TEST/PROD": If that term means something to you, then you are probably among our many customers that use SAS software across different environments. You might have one SAS environment for playing around ("dev" for "development"), another for testing candidate changes ("test"), and yet another for production processes ("prod"). SAS Enterprise Guide "Connections" window Or, you might work with different environments that are segregated across business units: one for Finance, for example, and another for Human Resources. You can also create different profiles for a single environment, but with different user accounts -- for example, one account with admin privileges, and another as a "mere mortal" end user. Wouldn't it be convenient to have different shortcuts on your desktop so that you can launch SAS Enterprise Guide and point directly to the environment that you want to use? We thought so, and so we added some command-line options to make this easy to do. (These were added way back in version 4.2 and they still work the same way today!) Two shorcuts for two environments The command-line option is /profile:"ProfileName", where "ProfileName" is the friendly name you used to label your SAS profile definition. (The quotes are optional unless the profile name contains spaces or special characters, in which case the quotes are necessary.) Here is an example command that you can use in a desktop shortcut to connect to the "prod" environment: "C:\Program Files\SAS\EnterpriseGuide\8\seguide.exe" /profile:prod Here is a variation with a space in the profile name ("My Server"): "C:\Program Files\SAS\EnterpriseGuide\8\seguide.exe" /profile:"My Server" And finally, if you want to run with no profile: that is, without connecting to a SAS metadata server at all (using just your local SAS installation), you can run: "C:\Program Files\SAS\EnterpriseGuide\8\seguide.exe" /noprofile Regardless of which profile you launch with, SAS Enterprise Guide will always show any additional "ad hoc" servers that you've defined, including connections to SAS Viya or to other SAS Workspace servers outside of SAS metadata connections.

ChrisHemedinger

The TODAY() function might be stopping this from passing through to the database. Try using the more standard SQL function DATE() and see if that passes through.

ChrisHemedinger · ‎05-14-2024

Okay, that's what I thought. The command to open the files into EG looks like this, and is configured in the Windows registry: "C:\Program Files\SASHome\SASEnterpriseGuide\8\seguide.exe" /openfile:"%1" If you change the command to remove the "/openfile", each invocation will open a new EG session instead. "C:\Program Files\SASHome\SASEnterpriseGuide\8\seguide.exe" "%1"

ChrisHemedinger · ‎05-14-2024

No special license is needed for EG 8.1 -- anyone with EG can update to this. However, maybe your question is about what happens when you double-click on a .SAS file? By default EG would open a .SAS file into an existing EG session if there is already one opened. But is your problem that new EG sessions are opening each time? Or -- maybe -- that's the behavior you want instead of the default to open into existing EG sessions?

ChrisHemedinger · ‎05-13-2024

It looks like you are using EG 7.1 in this screenshot, but EG 8.1 and later offers much better window management. Is it possible that the reinstall put a back-level version of SAS Enterprise Guide on your machine?

ChrisHemedinger · ‎05-10-2024

This list has a lot of procedures -- that must have been an impressive prompt that you fed to ChatGPT. Many of the HP (high-performance) procedures probably are not available in SODA. However, most have non-HP versions that would functionally be the same. Some of the "procs" in this list don't exist. CVMODELFIT, for example, is an option in PROC HPSPLIT. I don't think it exists as its own procedure. Like others have said, I expect that ChatGPT probably didn't do a great job of creating code that reflects good/best practices. I encourage you to use these forums to ask questions and leverage the wisdom of the crowd.

ChrisHemedinger · ‎05-09-2024

If it was working up until just today, check the license -- did it expire? You would have seen warnings before now, but once the expiration hits, no more warnings -- just failure to connect.

Online Status	Offline
Date Last Visited	Friday