Many a times we come across a situation where we may need to encrypt the password which we use in the SAS programs (Example: Using a password to access a database like db2). This can be acheived by the pwencode procedure. See the example below:filename…
Tag: Base SAS
Error Codes for libname
Whenever we assign a libname (especially a libname to a database), we would want to be sure that the library path should be valid/existing. When it comes to assigning a libname to a database, example oracle, we may also want to confirm if the user-id a…
PUTLOG statement
The PUTLOG statement writes a message that you specify to the SAS log.
The PUTLOG statement is helpful when you use macro-generated code because you can send output to the SAS log without affecting the current file destination.
The PUTLOG statemen…
Got dating problems? Use ANYDATE…
Many a times we might come across a situation where we would not be able to determine the informat of the date or datetime variable that needs to be read into the SAS dataset. Or me may at times fail to remember the informat name for a particular date …
Collateral damage (Control)
Indexed SAS datasets are at times vulnerable to getting damaged. Especially when you update an indexed dataset. To save this damage, SAS has come up with these options which repairs the dataset and gets back the data to its original form.. (trust me.. …