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 […]
Example 9.33: Multiple imputation, rounding, and bias
Nick has a paper in the American Statistician warning about bias in multiple imputation arising from rounding data imputed under a normal assumption. One example where you might run afoul of this is if the data are truly dichotomous or count variables…
Traffic lighting of numeric variables by SAS or VBA
“Traffic lighting” applies distinctive colors to any numeric variables to indicate the ranges, which is particularly important for Excel reporting. In SAS, it can be easily realized by a user defined format. For example, if I want to add yellow …
Stochastic Gradient Decending Logistic Regression in SAS
Test the Stochastic Gradient Decending Logistic Regression in SAS. The logic and code follows the code piece of Ravi Varadhan, Ph.D from this discussion of R Help. The blog SAS Die Hard also has a post about SGD Logistic Regression in SAS.
filen…
Favourite Papers from SAS Global Forum 2012
These are some of my favourite papers from SAS Global Forum 2012 last month. I didn’t to get to see as many papers in person as I’d originally planned; we were very busy at our Metacoda stand. So it was great that the papers had already bee…