Feb 27, 2012

SAS BI Web Report Studio for Quick Report Generation

SAS Web Report Studio is a Web application that anyone can use to view, interact, create, and distribute both public and private reports. You can interactively get the information you need without having to understand a programming language. In addition, SAS predictive analytical results can be used by business professionals across the enterprise via their Web browsers.
SAS Web Report Studio
The Report Wizard enables novice users to quickly create and distribute basic queries and reports based on either relational or multidimensional data sources in five easy steps. More advanced users can use additional layout and query capabilities that are available, including the ability to define custom calculations and complex filter combinations, multiple queries, and SAS analytical results into a single document. A gallery of predefined layout choices expedites the report creation process, and an extensive range of advance report components enable users to create and interact with reports from their Web browsers. Reports and the application can be branded to match a corporate style.
Watch these you tube videos to learn more about SAS Web Report Studio
Hands on Workshop Web Report Studio..

Other interesting references…

Feb 12, 2012

Length and Precision of SAS Variables....

Did you know that ?
- The maximum number of variables in a single SAS data set under Windows is 32,767.
- An observation under Windows cannot be longer than 5MB(ie 5*1024*1024).
- Therefore, if you want your data set to contain 32,767 character variables, the longest each variable can be is approximately 160 bytes.
- However, a DATA step can reference more than 32,767 variables, if you write only 32,767 or fewer variables to the data set. For example, you could drop some variables with a DROP= data set option. The maximum number of variables a DATA step can reference under Windows is 2,147,483,647.
- The default length of numeric variables in SAS data sets is 8 bytes. (You can control the length of SAS numeric variables with the LENGTH statement in the DATA step.) In SAS under Windows, the Windows data type of numeric values that have a length of 8 is LONG REAL. The precision of floating-point values is always accurate to 15 digits. Depending upon the number, the precision may be 16 digits of accuracy.
Significant Digits and Largest Integer by Length for SAS Variables under Windows
Length in BytesLargest Integer Represented ExactlyExponential NotationSignificant Digits Retained
This maximum number varies for every Operating System…
72057594037927936 – os/390 IBM Mainframes
9007199254740991 – OpenVMS
9007199254740992 – Windows / Unix
For example, if you know that a numeric variable always has values between 0 and 100, you can use a length of 3 to store the number and thus save space in your data set.
Here is an example:
Trying out numbers greater than max number for len 8 in the above table to see the results….employed best32. format.
data numbers;
input x;
format x best32.;
Look at the output for obs 3 & 4…The values are getting rounded off to the next number with trailing zeroes…
sas lengthnum
Note: Dummy variables (those whose only purpose is to hold 0 or 1) can be stored in a variable whose length is 3 bytes.