In this tips & tricks post we look at how PROC SQL INSERT INTO provides a concise method for inserting additional rows into a dataset. Sometimes it is necessary to force additional observations into your datasets, inserting new observations into…
SAS tips & tricks #10 – ERROR: Variable X not found.
In SAS tips & tricks #9, we looked at what happens when SAS encounters an uninitialized variable within a DATA Step. Here we look at the possibly more serious scenario of what happens when SAS cannot find a reqruied variable…
SAS tips & tricks #9 – NOTE: Variable X is uninitialized.
The “NOTE: Variable X is uninitialized” message is a result of trying to run a DATA Step which utilizes a variable that is not present in the input dataset or has not been created at the point within the DATA…
SAS tips & tricks #8 – NOTE: Numeric values have been converted to charater values
In the last post SAS tips & tricks #7 we looked at how to avoid implicit character to numeric conversion. Here we look at what causes numeric to character implicit conversions and how to avoid them In a similar way…
SAS tips & tricks #7 – NOTE: Character values have been converted to numeric values
In the last two posts we looked at how to clean the log by removing SAS NOTEs, here we look again at what to do when your log contains the following message: NOTE: Character values have been converted to numeric…
SAS tips & tricks #6 – NOTE: Missing values were generated as a result of performing an operation on missing values.
In our last SAS tips & tricks blog post (statskom.com/sas-tips-tricks-5-/) we looked at how to clean up the log by removing the “NOTE: Missing values were generated..” message. In this post we continue the theme by looking at another commonly…
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…
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…