https://communities.sas.com/t5/SAS-Programming/Deleting-lines-in-one-Variable-but-not-others/m-p/383540#M91483 <P>My Data is as follows</P><P>&nbsp;</P><P>Var_A &nbsp; Var_B &nbsp; Var_C</P><P>5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P><P>14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13</P><P>15 &nbsp; &nbsp; &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P>&nbsp;</P><P>I want to delete lines &gt; 4 &nbsp;of Var_A but keep all other variables the same</P><P>So my table looks like</P><P>Var_A &nbsp; Var_B &nbsp; Var_C</P><P>5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P><P>14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P>Does SAS permit me to do this? And how?</P><P>&nbsp; &nbsp; Randy</P> Fri, 28 Jul 2017 03:08:50 GMT RandyStan 2017-07-28T03:08:50Z https://communities.sas.com/t5/SAS-Programming/Deleting-lines-in-one-Variable-but-not-others/m-p/383540#M91483 <P>My Data is as follows</P><P>&nbsp;</P><P>Var_A &nbsp; Var_B &nbsp; Var_C</P><P>5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P><P>14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13</P><P>15 &nbsp; &nbsp; &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P>&nbsp;</P><P>I want to delete lines &gt; 4 &nbsp;of Var_A but keep all other variables the same</P><P>So my table looks like</P><P>Var_A &nbsp; Var_B &nbsp; Var_C</P><P>5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</P><P>3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6</P><P>14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;13</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P>Does SAS permit me to do this? And how?</P><P>&nbsp; &nbsp; Randy</P> Fri, 28 Jul 2017 03:08:50 GMT https://communities.sas.com/t5/SAS-Programming/Deleting-lines-in-one-Variable-but-not-others/m-p/383540#M91483 RandyStan 2017-07-28T03:08:50Z https://communities.sas.com/t5/SAS-Programming/Deleting-lines-in-one-Variable-but-not-others/m-p/383541#M91484 <PRE>data have; input Var_A Var_B Var_C; cards; 5 7 2 3 8 3 1 5 6 14 7 0 7 11 13 15 5 3 ; data want; set have; if _n_ gt 4 then call missing(Var_A); run; </PRE> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Fri, 28 Jul 2017 03:22:09 GMT https://communities.sas.com/t5/SAS-Programming/Deleting-lines-in-one-Variable-but-not-others/m-p/383541#M91484 art297 2017-07-28T03:22:09Z