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…