As I mentioned yesterday, some users create portal applications to bypass a second authentication step from the Portal to a Stored Process (via a URL Display Portlet). New in SAS 9.2, there is a STPRun directive that allows you to just complete one sin…
Tag: Uncategorized
Right Mouse Clicking in Stored Process and Portal Web Apps
In 9.2, the right-mouse click functionality is not available by default. To switch back to this (which for STP developers in a DEV environment is essential to our productivity), SAS has provided the following note: http://support.sas.com/kb/39/292.html…
Manage the internal SAS 9.2 account policies
In SAS 9.2, internal accounts can be created and utilized within the metadata and then do not require host (or domain) accounts defined elsewhere. By default, the sasadm@saspw is one such internal account. Unless you specifically declare an exception, …
Create a fully summarized table for OLAP Cubes
SAS procedure SUMMARY is a quick method of converting your detail table to a fully summarized one. Included is a sample. The key option to set is the NWAY – this generates the lowest level of summary for use in the OLAP cube. Essentially – the class st…
Star Schema Options in OLAP Cubes
In the past couple months, this scenario has occurred twice. So thought I’d share a quick remedy ~ and save for my future reference when this occurs again :). In Star Schemas, there are sometimes occasions where the data quality isn’t exactly perfec…
Adding Negative Solve Orders to OLAP Calculated Members
OLAP Calculated Members need to be tested to ensure that the numbers are correct in various tools. What we recently found was that the member tested properly in the OLAP Studio View Cube but then in Web Report Studio, the measure wasn’t correct. Essent…
DI Studio Code Importer for Comments
In DI Studio 4.3, SAS offers a code importer utility that can assist with moving legacy SAS code into an enterprise DI environment. The importer uses PROC SCAPROC to analyze and translate the code into DI Studio components. There is also a neat utility…
SAS truncates SQL columns to length 1024
At first I thought SAS was giving me errors because the input data was malformed. Before I found data entry operators typing invalid dates such as “3/30/33/2009″ : NOTE: Invalid argument to function INPUT at line 1248 column 26 NOTE: Mathem…