Why use indexes in SAS?
A page is the smallest I/O unit that SAS can read or write, including data set page and index file page. Index files in SAS are sorting and searching structures made by B-trees. “When an index is used to process a request,…
Category: SAS
Top gear for SAS Professionals: Knowledge!
It’s been two years since my first trip to SAS UK for the SAS Professionals Convention. That was also my first trip to the UK, ever. I was pretty naive back then and didn’t know what to expect from this strange land and its people. I was shown tremendous hospitality […]
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 […]
Links for 2012-06-03 [del.icio.us]
HTML Dog
HTML and CSS Tutorials, References, and Articles
ThemeShaper
Home of the Automattic Theme Team, tutorial on Wordpress.
DevZone, PHP 101
PHP For the Absolute Beginner, and they mean it.
How user friendly should statistical software be?
I got into a conversation on Twitter (find me there as @peterflomstat) about the user-friendliness of statistical software. I have heard R described (appropriately, I think) as being “expert friendly”. This led to a conversation about wheth…
Links for 2012-06-01 [del.icio.us]
Irene Armesto – The aesthetics of nostalgia
Portfolio of a great and talented photographer, and also a good friend.
Poll Shows Open Source Almost Even with Commercial Analytics Software
The 2012 results of the annual KDnuggets poll are in. It shows R in first place with 30.7% of users reporting having used it for a real project. Excel is almost as popular. It seems out of place among so … Continue reading →
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 […]