Is there a more efficient way to delete observations from a dataset without creating a new dataset and deleting the INDEX other that PROC SQL; DELETE? I find PROC SQL; DELETE very inefficient.
If not, is there another way of deleting observations from a dataset and creating a new one without deleting the INDEX?
remember old FSEDIT..... modifying in place. Big data was just a lot smaller those days.
SAS(R) 9.4 Statements: Reference, Second Edition
It has the options output (write new record), replace (update) and remove (delete) .
More work as you read that and you have to take backup/restore options.
SAS dataset/tables are having many options almost like a RDBMS.
You could even think on an audit-trail SAS(R) 9.4 Language Reference: Concepts, Second Edition
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.