topic Re: Deleting Observertions in SAS Programming https://communities.sas.com/t5/SAS-Programming/Deleting-Observertions/m-p/188030#M265810 <HTML><HEAD></HEAD><BODY><P>remember old FSEDIT.....&nbsp; modifying in place. Big data was just a lot smaller those days.</P><P><A href="http://support.sas.com/documentation/cdl/en/lestmtsref/67175/HTML/default/viewer.htm#n0g9jfr4x5hgsfn17gtma5547lt1.htm" title="http://support.sas.com/documentation/cdl/en/lestmtsref/67175/HTML/default/viewer.htm#n0g9jfr4x5hgsfn17gtma5547lt1.htm">SAS(R) 9.4 Statements: Reference, Second Edition</A> </P><P>It has the options output (write new record), replace (update) and&nbsp; remove (delete) .</P><P>More work as you read that and you have to take backup/restore options.</P><P></P><P>SAS dataset/tables are having many options almost like a RDBMS.&nbsp; </P><P>You could even think on an audit-trail&nbsp; <A href="http://support.sas.com/documentation/cdl/en/lrcon/67227/HTML/default/viewer.htm#n0ndg2uekz7qkbn1caoki2hzqx8l.htm" title="http://support.sas.com/documentation/cdl/en/lrcon/67227/HTML/default/viewer.htm#n0ndg2uekz7qkbn1caoki2hzqx8l.htm">SAS(R) 9.4 Language Reference: Concepts, Second Edition</A></P></BODY></HTML> Wed, 26 Feb 2014 21:54:26 GMT jakarman 2014-02-26T21:54:26Z Deleting Observertions https://communities.sas.com/t5/SAS-Programming/Deleting-Observertions/m-p/188029#M265809 <HTML><HEAD></HEAD><BODY><P>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. </P><P>If not, is there another way of deleting observations from a dataset and creating a new one without deleting the INDEX?</P></BODY></HTML> Wed, 26 Feb 2014 19:25:24 GMT https://communities.sas.com/t5/SAS-Programming/Deleting-Observertions/m-p/188029#M265809 sasthebest 2014-02-26T19:25:24Z Re: Deleting Observertions https://communities.sas.com/t5/SAS-Programming/Deleting-Observertions/m-p/188030#M265810 <HTML><HEAD></HEAD><BODY><P>remember old FSEDIT.....&nbsp; modifying in place. Big data was just a lot smaller those days.</P><P><A href="http://support.sas.com/documentation/cdl/en/lestmtsref/67175/HTML/default/viewer.htm#n0g9jfr4x5hgsfn17gtma5547lt1.htm" title="http://support.sas.com/documentation/cdl/en/lestmtsref/67175/HTML/default/viewer.htm#n0g9jfr4x5hgsfn17gtma5547lt1.htm">SAS(R) 9.4 Statements: Reference, Second Edition</A> </P><P>It has the options output (write new record), replace (update) and&nbsp; remove (delete) .</P><P>More work as you read that and you have to take backup/restore options.</P><P></P><P>SAS dataset/tables are having many options almost like a RDBMS.&nbsp; </P><P>You could even think on an audit-trail&nbsp; <A href="http://support.sas.com/documentation/cdl/en/lrcon/67227/HTML/default/viewer.htm#n0ndg2uekz7qkbn1caoki2hzqx8l.htm" title="http://support.sas.com/documentation/cdl/en/lrcon/67227/HTML/default/viewer.htm#n0ndg2uekz7qkbn1caoki2hzqx8l.htm">SAS(R) 9.4 Language Reference: Concepts, Second Edition</A></P></BODY></HTML> Wed, 26 Feb 2014 21:54:26 GMT https://communities.sas.com/t5/SAS-Programming/Deleting-Observertions/m-p/188030#M265810 jakarman 2014-02-26T21:54:26Z