This is a very common use case where we need to write code to check if a substring is present on a character variable in SAS. That substring can be a character string, a character, or any special character. Depending on the outcomes you can perform your specific operations. You can achieve this by using … Read more
The FIND function in SAS searches for a specific substring in a given string or character variable and returns the position of its first occurrence. The FIND function is mostly used where any specific character, keyword, or phrase you want to identify, and/or extract. It is especially helpful when you read raw, scattered, and long … Read more
The ALTER TABLE statement is used to add new variables, delete existing variables, or modify format of variables. This method gives you more flexibility while adding new variables or modifying existing ones. It is also possible to add values on those newly added columns with UPDATE TABLE statement. The following example demonstrates that two new … 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
Top 5 reasons why you should not choose data analytics as a career option. Career in data analytics can be a life changing decision but you should be aware of the reality. There is lots of misleading information available on the internet. In this article you’ll find 5 reasons why you shouldn’t choose data analytics … Read more