Ok, well the major issues have been tackled except 1. How do you handle spaces in your NameValuePairs? Well, without the single quotes below, it kept splitting the values between the Sample and the Data. The single quotes hold it together.Check this ou…
Category: SAS
Our journey with SAS’s StoredProcessService object continues…
Check out this code:string newParms = “outdata=WORK.TEST”;Common.SasLanguageService.Async = true;StoredProcessService sp = Common.SasLanguageService.StoredProcessService;sp.Repository = storedProcLibrary;sp.Execute(storedProcedureName, newParms);Standa…
This one is a real Keeper
So, if you ever get this error while trying to work with OleDb and SAS IOM:The object … could not be found; make sure it was previously added to the object keeperMake sure that you include the following lines (the lack of a Keeper is what causes this…
Progress reading SAS sas7bdat files (natively) in R
This post describes some preliminary results from a compatibility study of the SAS sas7bdat file format. The most current results stored in a github repository here: sas7bdat The ultimate goal is a native solution to the incompatibility between open-source statistical software (e.g. R) and sas7bdat database files. Demonstration There has been significant progress in interpreting […]
NOTE: Undocumented Features – Use Them at Your Peril!
Back in October 2009 I mentioned the undocumented feature in Enterprise Guide whereby data sets whose names begin “_TO” are hidden by EG’s Server List pane. I also cautioned against using undocumented features.
SAS’s Chris Hemedinger recently highligh…
NOTE: Are You Ready to be Taught? Test Your SAS Skills
SAS Education in the US have launched a series of online assessments to allow prospective training customers to see if they’re at the right level of knowledge to join a course. Since SAS share course materials across many regions, the value of the…
A subroutine in SAS to simulate asset pricing paths
For matrix computation in SAS, SAS/IML is the choice. This module has its own syntax, functions and even plotting subsystem. Some statisticians used it to realize the algorithms beyond the reach of SAS’s procedures, for example, boosting [Ref. 1]. Ho…
Where SAS trumps SQL- the easy way with Enterprise Guide
Just to set the record straight, I’m a programmer who loves to write code. While SAS Enterprise Guide (EG) does make reporting easier, this time it’s not the displays that caught my eye. EG won this round hands down for ease of use to summariz…