I created a LogCheck macro [code provided] to review the log during a batch process. The SAS log files can be rather large and it is so much easier if you can just extract the issues in an easy to understand format. This macro reads in each line of the log file and keeps the ones with Error, Warning, Note, or specific text you want to trap. Then it sends a colorful email to report what issues (if any) were found. You can download the code and two sample programs to review or change for your situation. Let me know what you think in the Comments section. How can the code be improved? Any ideas you have? Using the LogCheck Macro Add the LogCheck macro to your batch job to report issues through email about the job. When the job has no errors, you will receive an email similar to the following. The subject line indicates no found issues – thus you have some assurance the job was successful. When the job has errors – the macros sends an email similar to the following. Notice the subject line contains the number of Errors, Warnings, and Notes present in the […]
Communities launch set for first week of April
5 …. 4 …. 3 …. 2…. 1 Launch! We’ve set the launch date for the upgrade to Communities on SAS. At 2pm ET, Wednesday, April 4th, we will take communities.sas.com off line. The site may be unavailable for as much as 36 hours. We hope that …
New certification program: SAS Versions Professional
Today, SAS announces a new addition to its global certification program: you can now become “SAS Versions”-certified. Over the past 36 years, SAS has delivered hundreds of software products to the business analytics marketplace. Each of those products has a version number. As new revisions are released, the combination of […]
OpenCDISC Validator V1.3: An Unboxing Review (1): counting issue
The lasted OpenCDISC Validator version 1.3 was released at 29 March, 2012 (btw, there is a typo in the Line 1 of CHANGELOG.txt within the package: “2012” not “2011”). As usual, you can submit the following SAS scripts to get some basic information(remember to customize your directory): filename CDISC url "https://raw.github.com/Jiangtang/Programming-SAS/master/Rules_Count_OpenCDISC_XML.sas"; %include CDISC; %Rules_Count_OpenCDISC_XML(dir=C:\OpenCDISC1.3\compare\opencdisc-validator_1.3\config) and […]
Fetch CDISC Control Terminology Files in NCI Vocabulary Repository: All in One Click
CDISC Control Terminology is the most frequent updated model among CDISC standards. Take SDTM as example, the latest SDTM terminologies released at 23 March 2012; and from 2009 to 2011, there were 15 different SDTM terminology versions! If you just rely on your own local repository, you might miss the pace somehow. Here is a […]
SAS BI Dashboard: User Adoption Is Biggest Challegne
Today I’m blogging at the All Analytics site about how you encourage users to adopt your dashboard (or really any reporting tools). Join the Dashboard E-Chat Tomorrow When I was at the IFSUG conference, I attended a presentation by Stephen Harris, a senior VP at Bank of America. He discussed very thoroughly the issues he had getting users to accept the BI Dashboard as a reporting tool and the methodology he later developed to overcome the issues. There’s an E-Chat with him tomorrow at 3 PM EST where he will be discussing some of the issues and providing advise. It’s a great chance for you to “speak” directly with an industry expert. If you cannot attend the e-chat – just leave a question here (quick site registration required) and then you can check back afterwards for his answer. Facebook and Privacy Plus … check out my All Analytics vblog about the data Facebook shares with other sites when you use the quick log-in features. Please join the conversation – I would love to know what you think. Now I have to go get ready for my red carpet interviews … <ha ha>! Related content: SAS® Global Forum: Is Google […]