I really dig the SAS Enterprise Guide 5.1 – Data Explorer Tool. How many times have you received a new data set that you know nothing about? While it’s not like it takes forever to run some PROC FREQ/MEANS – but what if it’s already done for you or can be done quickly? Did that get your attention? Here’s how to use this new feature with your data. Open Data Exploration from File Menu From the File menu, select Open > Data Exploration. Then navigate to the dataset you want to open. I am using SASHELP.SHOES since many of you may already be familiar with it. The dataset is open and a new window appears to the right side of the dataset. At the bottom of the window, you can view some general information about the dataset (i.e. 395 rows and 7 columns). All the Statistics You Can Handle This is what I really like – I can run all statistics for all variables at once. From the new window, click the Charts icon and then Click to run all statistics. Notice when I selected the Charts icon, the window changed to list each variable type (character, numeric, currency) […]
Tag: SAS Enterprise Guide
SAS Enterprise Guide: Best Practice for Centralized User Storage
A nice feature of SAS Enterprise Guide is the “Files” folder. This provides direct access to the file system where the workspace server is running. You can take advantage of this by configuring a central location where users can store data, SAS code, CSV files, Excel files, or anything useful. If this is not configured it defaults to a user-specific area. In some cases this may be the most appropriate location of the “Files” link. Simple Ways to Use Centralize SAS code developed by users Centralize SAS datasets or other types of data for users Stage incoming files from external sources for end users to consume and analyze Important Note: Make sure file permissions are set appropriately for the file system location on the server! How to Configure the “Files” Folder Use SAS Management Console to configure the location of the “Files” folder. This requires an administrative role to accomplish because it is seen across the enterprise. The workspace server runs SAS code from EG so it will be the item of interest in Management Console. Since users will access data and submit code through the SASApp context server, you will want to navigate to the workspace server through the […]
How to search your SAS Enterprise Guide project files
If you are like many SAS Enterprise Guide users, you’ve amassed a large collection of project files (EGP files) that contain important content: programs, logs, notes, results, and more. However, to most tools and processes, the EGP file is opaque. That is, you can’t see what’s inside of it unless […]
User Conferences = Busy Summer
It’s going to be a busy summer with a lot of travel. I’ve been invited to several user conferences so I’m really excited to get to meet even more SAS users, pick up some great tips for others, and wear myself out chatting. Wisconsin Illinois SAS Users Summer ConferenceMilwaukee, WIJune 27 This SAS user group is having a summer conference [Conference Brochure] in Milwaukee, WI on June 27th. I have never been to Wisconsin so I’m really excited to spend at least one day there. Summerfest, the world’s largest music festivals opens on the same day! At this conference I’ll be talking about the first steps to creating SAS stored processes and offer 25 tips for using SAS Enterprise Guide. I just finished the presentations yesterday – I’m really exhausted but the presentations are going to be fun. For the SAS Enterprise Guide topic I’m using some UFO data and interweaving UFO trivia with the presentation. I need to find tin foil hats for us all to wear – so the aliens cannot read our SAS brain waves. You totally know we would be asked to analyze alien trends – how to improve time warp speed … etc. But it won’t […]
SAS Enterprise Guide: Import Odd Spreadsheet Data
Perhaps you took my advise a few weeks back and took advantage of the amazing (trumps blare!) SAS Enterprise Guide ability to import MS Excel spreadsheets. However, if your spreadsheet is a little different – then you may run into some issue when you go to import it. For instance, look at this import: Oh it’s so horrible – the columns names are not there and it’s going to be a lot of work to clean it up. Urgh .. it’s giving me a bad day already. Looks like the default approach to importing this spreadsheet didn’t work out as well. Curses – there must be a better way! Your Data Needs Some Special Lovin’ So let’s look at a spreadsheet similar to the one imported above. You’ll notice that the actual data I want starts on row 3 not on row 1 as the default import would like. So row 3 contains the column labels and row 4 contains the data. When you go with the default… If I go with the defaults and select First row of range contains the field name – the Import wizard default assumes row 1 is where I want to start. Basically when […]
How much time will your process flow take to run?
SAS users, by definition, do not embrace the mysterious. That’s one of the main reasons that they use SAS: to demystify some data or process. And so, when you (as a SAS user) have gone to the trouble of designing a process flow in SAS Enterprise Guide, you like to […]
New Book: The 50 Keys to Learning SAS Stored Processes
At the SAS® Global Forum 2012 last month I picked up a copy of “The 50 Keys to Learning SAS Stored Processes“, the latest book from the dynamic writing duo, Tricia Aanderud & Angela Hall. As it happens, my partner Michelle also wo…
SAS OLAP Cubes: Viewing Member Properties in Excel and Enterprise Guide
As a follow-up to my earlier post on taking advantage of OLAP member properties, you can also display OLAP member properties through the Add-in for Microsoft Office as well as SAS Enterprise Guide. I’m a huge fan of Enterprise Guide, so it’s nice to have that ability but even nicer when the more common information consumer can display member properties through a Pivot Table in Excel. One Click to More Information Simply right-click the level and select Show Properties in Report. From there you can check the properties you have defined. I like the way the Pivot Table displays member properties as each column in Excel. This information gives the user a little more insight into the data. Also Works in SAS Enterprise Guide To display member properties through SAS Enterprise Guide the approach is similar, right-click the level and select Show Member Property. From there you can check the member properties you want to display. More about OLAP Member Properties Check out my earlier post to see how these same OLAP member properties are defined and displayed in SAS Web Report Studio. Related content: SAS OLAP Cubes: Taking Advantage of OLAP Member Properties SAS Business Intelligence Tools Overview SAS […]