So you have an idea to implement queries or changes in the metadata via a program directly using SAS. Well, one of the first items of business is actually to grab the Repository ID number. Included below is some quick reference code on how to query that. PROC METADATA SERVER="my_sas_srv_name"
Uncategorized
I am pleased to announce publication of The Business Forecasting Deal: Exposing Myths, Eliminating Bad Practices, Providing Practical Solutions, available now in a convenient carry-everywhere size (approx 6” x 9” x 1”), or for download to your Kindle. Table of contents, sample sections (including the Prologue, Forewords by Tom Wallace
I'm using this post to share links to several SAS-related blogs created by others. This is me acting generous by sharing -- it's not me acting lazy by shirking an original post. Really. Datum Reparo! AnnMaria waves her SAS Enterprise Guide magic wand, utters a few (magic?) words, and makes
We're live from F2010, SAS' premier business forecasting conference. Professionals from dozens of industries are gathering at our headquarters in Cary to discuss the latest technologies and methodologies around forecasting. We caught up with authors Mike Gilliland and Charles Chase as they discussed their forecasting books with us. Enjoy their
Interested in adding a group of users into Metadata w/o Management Console? Included is an example of how to add one user: PROC METADATA SERVER="my_sas_srv_name" PORT=8561 USERID="sasadm@saspw" PASSWORD="xxxxxxxx" PROTOCOL=BRIDGE in="<AddMetadata> <Metadata> <Person Desc='Manager of clinical studies.' Name='Joe E. Doe' Title='Manager of Clinical Studies'> </Person> </Metadata> <Reposid>A0000001.A5VLFKMC</Reposid> <NS>SAS</NS> <Flags>268435456</Flags> <Options/> </AddMetadata>";
Contributed by Paul Allison, Professor of Sociology, University of Pennsylvania I'm happy to announce that the second edition of my book Survival Analysis Using SAS: A Practical Guide has just been published by the SAS Institute. When the first edition was published in 1995, my goal was to provide an
As I make my way around the country I often have the opportunity to talk with state and local government leaders and as you can imagine, the financial crisis is the first, second and third topics on their minds. Everywhere, state and local governments are forced with painful decisions to
"Less Wrong" is the name of the blog where I found this layman's explanation of Bayes' Theorem. As I've pointed out before, I'm not a statistician. But I can comprehend basic statistical explanations such as the explanation of the Monty Hall problem. Understanding the concepts and being able to apply
Within each report you can right click on the table, choose properties, and modify the number of rows to display. However is there a way to GLOBALLY modify the default maximum amount? The answer is yes with the required modification occuring within the web deployment area. WebReportStudioProperties.xml (version 9.2) has a section
I presented recently at the County Auditors Association of California annual conference. It was a packed house in Death Valley, CA, and after weathering a major sandstorm, the attendees seemed anxious to learn of the latest fraud trends in local government. Based on the questions and sidebar discussions throughout the
I've known Jim Cox for a long time. He's the SAS R&D manager for SAS Text Miner, and a gifted singer. We almost never talk about work stuff, because Jim is waaaaay too smart for me. That's why I was so pleased to discover Jim's series of blog entries about
The Results Driven Policing Conference, which was put on by the Penn State University Justice and Safety Institute and held in Baltimore recently, showcased the great performance improvements achieved by forward thinking law enforcement agencies throughout the United State and Canada. These agencies are under increasing pressure to improve public
Like any good SAS professional, I subscribe to the SAS Samples RSS feed. The other day I found this sample that shows how to create a PDF report about the contents of a SAS Information Map. It's a nice example: it shows how to use the INFOMAPS engine and ODS
If you are a SAS/GRAPH user, you may have heard about the new Statistical Graphics ("SG") procedures that are new in SAS 9.2. These procedures are designed to make it easier to produce common statistical charts and plots. You may have assumed that the procedures are only for folks who
The motto of SAS’ home state gets at what I hope will be a recurring theme of State and Local Connections. How can state and local governments differentiate between what seems to be and what is? How can they move beyond intuition and gut feelings to know the truth? It
As Shane reveals on his blog, your SAS session is equipped to read data that are encoded for all types of machine architectures and locales. ASCII, EBCDIC, 32- or 64-bit, English, Japanese, Greek, Hebrew: the list goes on and on. SAS accomplishes this by using a feature called Cross-Environment Data
Susan and Lora share all of the details on the OpenMic blog. (You can also see it on the SAS Publishing Facebook page.) I was pleased to have reviewed the book for technical content before it was published. As usual, Susan and Lora did a great job; they know what
My grandmother was a great cook. When we would visit her in South Carolina, we spent hours on her porch enjoying wonderful meals accompanied by vats of iced tea. Now, my memories of her and those meals are captured in her Junior League cookbook that was passed on to me,
Why does this SAS program produce an error? proc means data=sashelp.cars mean median min max; by origin; run; It's because SASHELP.CARS is a SAS data set, and SAS data sets observations are stored and processed sequentially, and a BY group operation requires that the observations are already grouped and sorted
Contributed by Susan Slaughter, Author, The Little SAS Book series Answer: A lot. Looking at The Little SAS Book for Enterprise Guide 4.2, I am struck by how similar it looks to the previous edition. Updating this book for EG4.2 was not a matter of simply adding a few new
For those of you who were growing up in the 80’s and listening to rock with hair that had been teased for hours on end and using an entire bottle of AquaNet in the process, and pant legs pegged so tight you had bruises around your ankles, that line should
Was it the economy? the timing? the location? or the brilliant and good looking Forum panel? That will be for history (or you) to decide. What we do know is that is that the Institute of Business Forecasting’s Best Practices Conference in San Francisco, April 28-30, drew a large and
I remember studying product distribution in my business classes at Colorado State. We learned about the role of manufacturing, distribution centers, and retail outlets, in moving goods from the factory to the consumer. The publishing industry was built on this model – with the added twist of selling distribution rights
Contributed by Mike Molter, Principal Statistical Programmer, INC Research I’m writing this from an altitude of 35,000 feet. As I try to squeeze my 6’1” frame into a space clearly designed for passengers no taller than 5 feet while trying to find a place to put my left elbow because
SAS catalogs have been around for a long time. Not quite as long as the Sears or L.L. Bean catalogs, but SAS customers have used catalogs to store and retrieve content for many years. A SAS catalog is a special type of SAS file that acts as a container, like
Curt Monash posted a nice summary of the current and planned offerings that help to make SAS analytics more available "in the database" -- allowing you to analyze your data quickly without having to move it around so much. If you use SAS with Teradata, Netezza, or DB2, much of
Welcome to SAS Training Post, the official blog of SAS Training & Certification! My name is Michele Reister and I am the social media manager for SAS Education. This blog will be a channel to provide you with value-add educational content to help you be a better SAS user. You’ll
This is the topic of an 8-minute video tip from SAS Education. What's great about this tip: not only does it show you how to keep historical versions of reports and data that you create in your projects, but it also provides a nice example of cross-tab reporting in SAS
My friend Tom Reilly of Automatic Forecasting Systems posted this comment on the INFORMS discussion group on LinkedIn: Some use all of the data and some withhold data to find the best forecasting model? Withholding is arbitrary as changing the withhold from x to y means a completely different model
Congratulations to John Calhoun of Gilead Sciences Inc.! He was the winner of the SAS Publishing book of his choice for participating in the SAS Global Forum SAS Publishing e-Book Reader Survey! Many thanks to everyone who participated in our survey. A results summary will be posted shortly. Once again,