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
Hi SAS Community,
I'm reaching out for some guidance on loading large .dat files into SAS Viya 4.
Our Process: Each semester, we generate census datasets from snapshots of data received as .dat files from IT. Previously, we used Base SAS programs to read these files from a Windows file server and convert them to SAS datasets.
Challenge: Since transitioning to SAS Viya 4, I'm encountering difficulties loading the .dat files, particularly with larger ones exceeding 100MB. I'm unable to load or copy them directly into SAS Viya.
Clarification: I'm copying the .dat files to "SAS Content," not the CAS server (I am unable to copy to cas). For this project my programs typically read data from the "SAS Content" location.
Specific Issue: Out of 19 .dat files, 17 successfully copy to the "SAS Content" path and able to convert them into sas datasets. However, the two remaining files (119MB and 153MB) fail to copy, resulting in an error (details provided below).
I'd greatly appreciate any insights or suggestions on how to approach loading/copying these large .dat files into SAS Viya 4. Any advice on alternative methods or configuration adjustments would be incredibly helpful.
Thank you for your time and support!
Sincerely,
Bhaskar
... View more
Hi I have a file uploaded to a big data platform showing correct d.p but somehow when our clients see the same file via ODBC, the decimal place change from 4 to 2, how did that happen? Do I need to setup schema for showing data via ODBC or there is specific settings required dealing with?
... View more