Hello, I have a deployed SAS job runs in flow which always fails during the first run and after we re -run manually it will get succeeded. The issue is due to sql server stored procedure which we call in it in the SAS job. So we thought of adding exception handling in the schedule manager for that job. We have defined that 'if the job fails with exit code greater than zero, we asked it to re-run automatically', But its not working. Is there any other way to remove the manual process of re run ? Thanks
... View more
I am trying to understand how filevar= option is used in infile statement. I am able to understand that a different file each time (varying file, filevar) will be given to read and it is read sequentially. But I am not able to understand the exact syntax. I am sharing the syntax below which I am trying.
filename qtr1 "path";
filename qtr2 "path";
filename qtr3 "path";
data new;
infile temp filevar = qtr1;
input A B C D;
run;
A B C D are four columns in .dat file qtr1, qtr2 and qtr3 and they are getting read properly without filevar= option. But when I am using filevar=option, the error is shown that "Invalid physical name."
I request to kindly guide me about this. Thanks in advance.
- Dr. Abhijeet Safai
... View more
First, let me say that I'm a fan of the Reddit community. I've used it to learn tricks about all types of topics, including home improvement and video game secrets. I've also answered SAS questions in some subreddits. However, over the past several months we've seen many old Reddit topics that are copy/pasted into new threads here on the SAS Community.
This isn't Reddit's fault and has nothing to do with the original authors of the topics. Instead, it's an approach by spammers to create what seems like a legitimate topic on the forums, get some credibility for their profile, and then follow it up with other replies that link to unrelated commercial sites.
The trick they use is to select some of the more provocative topics on Reddit, like "why is SAS so difficult" or "Should I learn SAS instead of Python, what do you guys think." We have no objection to authentic questions like these from community members, but we do not allow this inauthentic approach to generating engagement for misleading commercial purposes.
Ours is not the only community that experiences this. Many of our industry peers who manage other communities are reporting that they see the same thing on their forums.
When we spot cases like these we take action. We mark the topic as Spam (to remove it from view) and then we ban the user account that posted it. How can we tell the content came from Reddit? There is a trick you can use with Google search: copy a unique phrase from the post and paste it into a Google search field in quotation marks to find the exact phrase in other internet sites.
In a recent example, a thread contained the phrase "SAS seems astonishingly unintuitive and overly rigid". A search for this exact phrase yielded a single result: a Reddit thread from 2019. That's all I needed to confirm that this was not an authentic post for our community, but an effort to leverage the popularity of our site for an unrelated purpose.
If you see a community post that seems provocative like this, think twice before you respond. Many community members are quick to jump in and advocate for SAS and encourage the original poster to stick with it and learn more...but we'd hate for you to invest time in a reply that gets deleted because the topic was not genuine.
If you see/suspect spam topics like these, use the Report Inappropriate Content menu item on the message to let us know. We can investigate and then take action as needed.
As always, thank you for your advocacy and for helping fellow SAS users on the community!
... View more
From a server different from the SAS machine, we are running processes in batch mode on the SAS machine. These processes (process.sas) essentially create, delete, and regenerate a table in a library from an .egp file. In some cases, when we run the process outside of business hours, it executes in batch mode without issues. However, on certain occasions when we execute it during business hours, we have encountered situations where the table intended for deletion and regeneration is locked, possibly due to a user accessing it. This results in an error, but we cannot determine if the execution completed successfully or failed from the batch mode call. To make the call, we use a command like the following example: ```sh "/sas/config/Lev1/SASApp/BatchServer/sasbatch.sh -logconfigloc \"/sas/config/Lev1/SASApp/BatchServer/logconfig.xml\" -log /sas/config/Lev1/SASApp/BatchServer/Logs/"$1"_ -batch -noterminal -logparm \"rollover=session\" -sysin /sas/config/Lev1/SASApp/SASEnvironment/SASCode/Jobs/"$1"" ``` We make this call from another server, not the SAS machine, using an SSH connection.
... View more