During September the following conferences and training sessions are taking place: Organisation Date Location Theme Link OpenCDISC 09Sep14 New Jersey, USA Meet the developers of OpenCDISC http://www.opencdisc.org/news/opencdisc-live-comes-new-jersey New Jersey SAS User Group 17Sep14 New Jersey, USA CDISC CDISC 25Sep14 TC The…
SAS tips & tricks #5 – NOTE: The query as specified involves ordering by an item that doesn’t appear in its SELECT clause
SQL allows the SAS programmer to write concise code and offers many advantages over the DATA step, however becoming over reliant on SQL can lead to problems. One issue we regularly see is the following message in the SAS log:…
SAS tips & tricks #3 – SAS dictionary tables
In SAS tips & tricks #2 we looked at retrieving metadata within a datastep using the VARxx functions. Here we look at how the SAS dictionary tables can be used to retrieve SAS metadata. If you’ve ever wondered how to determine…
CDISC training
The first part of our CDISC training series, Introduction to CDISC, will be available to download here for free next week.
SAS paper review #3
This week our SAS paper review looks at “A Closer Look at PROC SQL’s FEEDBACK Option” by Kenneth W. Borowiak. The paper explores how the FEEDBACK option can be used in the SQL statement to cause SAS to create additionally detailed…
SAS tips & tricks #2 – Retrieving variable metadata within DATA Steps
In our last tips & tricks blogpost we looked at how the VARNUM function could be used to within a DATA Step to determine whether a variable was present within dataset and how this function could be used as an…
SAS paper review #2
This week our SAS paper review focusses on “Proc Format, a Speedy Alternative to Sort / Sort / Merge” by Jenine Milum. The paper explains how Proc Format can be used to combine information from multiple datasets in place of…
Social media
Keep upto date with Statskom, follow us on: Twitter :https://twitter.com/statskom Google+ : https://plus.google.com/115147245572366614939 LinkedIn : http://www.linkedin.com/company/statskom?trk=biz-companies-cym
SAS tips & tricks #1 – The VARNUM function
A couple of well known ways to tell whether a variable is present in a dataset include using a PROC CONTENTS or by referring to the SASHELP.VCOLUMN Dictionary Table, a perhaps lesser known approach is to utilise the VARNUM function.…