In this post you’ll learn how to delete datasets in SAS using 3 simple ways. It also explains how you can drop the entire SAS dataset and/or entire data from a specific library. Short Summary: Delete table v/s Drop table The DELETE statement deletes only the rows (data) in a table. The DROP TABLE statement … Read more
In this article you will learn how you can delete data in SAS. There are two common operations most people do on SAS datasets: DELETE the entire data set DELETE specific rows from a data set You can remove data using two SAS procedures such as proc sql and proc datasets. You can also use … Read more
You might have encountered the following error when loading, updating to re-creating a sas data set. “File WORK.XXXX.DATA is damaged. I/O processing did not complete” ERROR: File OLRSAS.RESULT.DATA is damaged. I/O processing did not complete. This is a most common situation where you need to repair a damaged data set: A system failure occurs while … Read more
In this article we’ve already described 4 ways to create indexes on SAS dataset with practical examples. I’m assuming you’ve a SAS dataset which already has indexes defined on it. For any reason you want to delete those indexes on the SAS dataset, this is the article where you learn how to remove indexes. How … Read more
An Index is the most important part of a sas dataset but it’s kind of optional. As a beginner you might ignore this but as soon as you learn more about SAS you’ll understand the importance of having Index on a SAS dataset. Why to Create Index on SAS Dataset? Indexes are used to quickly … Read more
In SAS you can easily extract characters from a string using SUBSTR() or SUBSTRN() functions. But it only works with the character variable. To extract last 4 digits or any number of digits from a numeric variable, you need to convert the input from numeric variable to character variable in order to use substr function. … Read more
You can use the SUBSTR() function in SAS to read a part of a string. It can also be used to replace very specific given characters from a string. You pass the input string to be processed, it can be a char variable as well, then specify starting position to read and size – that’s how … Read more
You can easily populate the current date and datetime in SAS using today() and datetime() functions. More specifically, current date can be populated using today() function and date with time can be populated using datetime() function. We’re going to use the work data set “work.hightemp” to insert a new variable “date_now” with current date or … Read more
SAS internally generates logs while executing SAS statements and writes them into the SAS LOG window or any specified external log file. The level of logging depends on the SAS system configuration or SAS options specified in the SAS program itself. But none of them prints actual data into the log window or log file. … Read more
After successful execution of each SAS statement SAS generates a log and you can see it in the LOG window assuming you’re running your code in SAS Studio or SAS EG. It’s always a good practice to check out the logs even after the successful execution of the SAS program. It gives you a sort … Read more