Re: deleting a dataset if a condition is met Posted 03-02-2013 (2913 views) | In reply to Xamius32 If you are already using a macro then you can use conditional logic (%IF %THEN etc). Learn more . When DELETE executes, the current observation is not written to a data set, and SAS returns immediately to the beginning of the DATA step for the next iteration. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. If the file does not exist, write a message to the SAS log. If you do not use a sequential library, then EXIST returns 1 if the library member exists, or 0 if member-name does not exist or member-type is invalid. Check for the existence of a file before trying to use it in a SAS program. is a character constant, variable, or expression that specifies the SAS library member.

This is a pretty simple question -- I'm probably overthinking it. Details: The DELETE statement is often used in a THEN clause of an IF-THEN statement or as part of a conditionally executed DO group. If you use a sequential library, then the results of the EXIST function are undefined. While this example is sort-of straightforward, the SAS macro language is frequently counterintuitive (to me at least). I have a problem with my macro. ; Viewed 1k times 0. Active 1 year, 10 months ago. Check if table exists, if not do nothing. If you are using a version of SAS/IML prior to 9.22, you have to call the DELETE subroutine in a loop to delete multiple data sets. The basic syntax for creating an if statement in SAS is − IF (condition ) THEN DELETE; If the condition evaluates to be true, then the respective observation is processed..
Ask Question Asked 1 year, 10 months ago. I have a data set called people_info and one of the variables is SocialSecurityNum.I have another table called invalid_ssn with a single variable: unique and invalid SocialSecurityNum observations.. I'm just learning SAS. If member-name is blank or a null string, then EXIST uses the value of the _LAST_ system variable as the member name. An IF-THEN-DELETE statement consists of a boolean expression followed by SAS THEN DELETE statement.. Syntax. Use the CEXIST function to verify the existence of an entry in a catalog.

If you're a beginner it might be a good idea to find and read an "into to SAS macros" online. Try to create a table if the name exists. Example DATA EMPDAT; INPUT EMPID ENAME $ SALARY DEPT $ DOJ DATE9. If it does exist, read it into a SAS data set.