Unlike BASE SAS tables, OLAP cubes must exist in within the metadata in order to access from any of the OLAP Viewers. In addition to having some metadata OLAP cubes have a physical file structure presence (at least for MOLAP/HOLAP because it’s a differ…
How to open a SAS information map in SAS Web Report Studio
Business users of SAS are finding the Web Report Studio capabilities incredibly beneficial for viewing, creating, and sharing reports on the Web. The easy-to-use query and reporting software provides a point-and-click interface for building reports f…
SAS Enterprise Guide: Cut and Paste Excel Data into SAS Dataset
Yes, you can import a spreadsheet into SAS Enterprise Guide and it’s super simple. However, there are times when I have been building datasets from several pieces of data. Come into my lab … now that I’m a data scientist! Careful, don’t knock over any of my beakers or touch my experiments – you might cause an explosion. Create the Framework To build your new dataset just decide how you want it to look – how many columns, what they will hold, and so on. Here’s how you do it in SAS Enterprise Guide: Go to the File > New > Data. A New Data window appears. In the Name field, type the name of your new dataset and then select the library you want it in. This needs to be a local library unless you have permissions to create a dataset in the metadata library. [A completely different subject … ] The next window allows you to create the columns. You can edit Column Properties to change the name, label, format, informat, and length. You can add and delete columns. Obviously – you can be your own little wizard and conjure up the dataset of your dreams! Now for Some Excel Tricks […]
Help! I Have Too Many Variables for a Cube!
The following email landed in my inbox this morning and it is such a good question that I decided to share because it comes up often. (If you are the sender, thank you for sending this message and pulling me out of a no-blogging-recently slump!) Dear …
Skipping through OLAP to find your value
One of the cool things with SAS OLAP Viewer in Add-in to Microsoft Office is your ability to skip right into a specific value. Out of the box, viewing OLAP cubes can lead you to believe that in order to view a specific value you need to click-thru a hi…
SAS EG and Stored Processes: 3 Tips for Using Options
There are some helpful options you can set in SAS Enterprise Guide to make your day-to-day coding tasks a little quicker. Some of these tasks can impact stored processes you create from tasks instead of coding. SAS Enterprise Guide Options From the Tools > Options menu you can preset options such as footer text and default SAS code that you want run before or after a task executes. Sometimes this can be more helpful than other times. Tip #1 – Adding a Default Footer You can add a default footer or header to all of your SAS generated reports. If you are using the SAS Tasks, SAS automatically adds whatever you have preset in the Options. If you use SAS functions or macro variables your reports and graphs will appear more customized. To set a default footer for your SAS Enterprise Guide reports and graphs, do this: From the Tools>Options menu, select the Tasks General pane. In the Default footnote text for task output field, type your text. For instance, I am using the default time and date to indicate the last time the report was updated. Note! The date() function returns when the SAS Enterprise Guide session was started […]