![]() This means fewer observations may be read from the input dataset. The WHERE= option is similar to the IF subsetting statement, but this options selects observations from the input dataset. DELETE with IF allows the programmer to delete anyone who does not have a claim. We also do not limit the claims dataset to the intersection. When we merge the two datasets, we do not want anyone in this problem dataset without claims. Not everyone in the problem_ids has a pharmacy claim. In the following example, the study had identified persons who had problematic data issues. This is very helpful with combined with the IF statement. The DELETE statement tells SAS to stop processing on the current observation. The subsetting IF statement is often used to do this and then continue the DATA step to create additional variables for this overlap. Often in merging two overlapping datasets, the programmer only wants to keep the overlap and discard observations only in one or the other dataset. If the conditions are false, then SAS will go onto the the next observation. The IF statement, used alone, tells SAS to either continue with the DATA step if the conditions are true. This section will introduce several ways to subset a dataset using statements and options. In this case, it is much easier and efficient to limit the observations in a SAS dataset to this subset. Sometimes researchers are only interested in a subset of the entire population.
0 Comments
Leave a Reply. |