I attended SAS Programming 3: Advanced Techniques and Efficiencies training recently at the SAS’ Austin Training Center. Programming 3 demonstrates many ways to make your SAS code and programs more efficient, but I also picked up one tidbit that makes coding and testing even easier. When using the enhanced editor, to create comments in your [...]
from support.sas.com: Data source name The name of the relational or multidimensional data source that is being used for the view elements in the report section. (Does not apply to stored processes.) Data source description If available, the description of the relational or multidimensional data source that is being used for the view elements in [...]
from support.sas.com: In response to requests from many customers, quarterly updates to the SASHELP.ZIPCODE data set are now available for you to download from the SAS Maps Online Web site. The zip file provided in the download is a SAS data set in transport format, and you should use this file to replace your existing [...]
I created some nice data cubes using SAS Data Integration Studio recently. I had a local, regional, and state-level hierarchy for my geographical dimension as well as a monthly, quarterly, and annual hierarchy for my time dimension. I had eight measures which were vital for assessing where the organization was through time. I added drill-through [...]
I recently took the opportunity to sit through a SAS e-Learning course titled Creating OLAP Cubes. It was a pretty detailed walkthrough for individuals creating OLAP cubes using SAS OLAP Cube Studio or Data Integration Studio. Dimensions, levels, and hierarchies were described thoroughly, but measures were inadequately addressed. Overall, it was a fine course for [...]
I’m currently attending Querying and Reporting Using SAS Enterprise Guide training at the SAS office in Austin, TX. I’m a veteran at using Enterprise Guide, but SAS has great training courses and you always pick up a lot of worthwhile information when you are lucky enough to attend. One tidbit that was covered yesterday that [...]
When using a Microsoft product, I’m used to mousing to the Help menu and choosing About… to find out which updates or service packs have been applied. I haven’t been as accustomed to doing the same thing with SAS software because the updates are applied manually, and I usually remember the last update I performed. [...]
We ran into a problem recently in SAS Web Report Studio 3.1 where our web reports that contained graphs produced java errors while our table-only reports did not. Our platform is SAS Enterprise Business Intelligence Server 9.1.3 Service Pack 4 running Solaris 10 on Sun SPARC Servers. Our web server is Apache Tomcat 4.1.18. The [...]
SAS developed Web Report Studio (9.1.3 BI Server installation) for Internet Explorer 6.0. I have used IE 7.0 and Firefox 2.x and 3.x with Web Report Studio and ran into a few different Javascript errors. These errors don’t necessarily make Web Report Studio completely unusable, you just have to know what NOT to do. To [...]
I recently attended a three-day training course titled “Data Mining Techniques: Theory and Practice” in Boston, Massachusetts. The training is part of the Business Knowledge Series offered by SAS Institute Inc., which features courses authored by experts and utilizing SAS software to accomplish the objectives of the courses. I was fortunate to have Gordon Linoff [...]
