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…