topic Re: Order columns in a data set. in SAS Programming https://communities.sas.com/t5/SAS-Programming/Order-columns-in-a-data-set/m-p/134386#M260888 <HTML><HEAD></HEAD><BODY><P>Have a look into this very recent discussion <A __default_attr="60911" __jive_macro_name="thread" class="jive_macro jive_macro_thread" href="https://communities.sas.com/" modifiedtitle="true" title="Ordering fields "></A></P><P></P><P>It's sometimes worth to first search the communities as a lot of questions have already been answered.</P></BODY></HTML> Mon, 08 Sep 2014 09:55:58 GMT Patrick 2014-09-08T09:55:58Z Order columns in a data set. https://communities.sas.com/t5/SAS-Programming/Order-columns-in-a-data-set/m-p/134385#M260887 <HTML><HEAD></HEAD><BODY><P>My data set have variables VAR1, VAR2, and VAR3.</P><P></P><P>The variables are displayed in order VAR1, VAR3 and VAR2. I want them in order VAR1, VAR2 and VAR3.</P><P></P><P>How do I change the order in a <STRONG>DATA STEP</STRONG>?</P></BODY></HTML> Mon, 08 Sep 2014 06:44:42 GMT https://communities.sas.com/t5/SAS-Programming/Order-columns-in-a-data-set/m-p/134385#M260887 attjooo 2014-09-08T06:44:42Z Re: Order columns in a data set. https://communities.sas.com/t5/SAS-Programming/Order-columns-in-a-data-set/m-p/134386#M260888 <HTML><HEAD></HEAD><BODY><P>Have a look into this very recent discussion <A __default_attr="60911" __jive_macro_name="thread" class="jive_macro jive_macro_thread" href="https://communities.sas.com/" modifiedtitle="true" title="Ordering fields "></A></P><P></P><P>It's sometimes worth to first search the communities as a lot of questions have already been answered.</P></BODY></HTML> Mon, 08 Sep 2014 09:55:58 GMT https://communities.sas.com/t5/SAS-Programming/Order-columns-in-a-data-set/m-p/134386#M260888 Patrick 2014-09-08T09:55:58Z Re: Order columns in a data set. https://communities.sas.com/t5/SAS-Programming/Order-columns-in-a-data-set/m-p/134387#M260889 <HTML><HEAD></HEAD><BODY><P>data want;</P><P>retain var1 var2 var3;</P><P>set have;</P><P>run;</P></BODY></HTML> Mon, 08 Sep 2014 12:04:42 GMT https://communities.sas.com/t5/SAS-Programming/Order-columns-in-a-data-set/m-p/134387#M260889 stat_sas 2014-09-08T12:04:42Z Re: Order columns in a data set. https://communities.sas.com/t5/SAS-Programming/Order-columns-in-a-data-set/m-p/134388#M260890 <HTML><HEAD></HEAD><BODY><P>Often the order of variables does not matter, but I recently wrote an article about reordering variables according to a value of a statistic (mean, median, variance,...). Yes, I used the RETAIN statement. For details, see</P><P><A href="http://blogs.sas.com/content/iml/2014/09/08/order-variables-by-statistic/" title="http://blogs.sas.com/content/iml/2014/09/08/order-variables-by-statistic/"> Order variables by values of a statistic - The DO Loop</A> </P></BODY></HTML> Mon, 08 Sep 2014 13:19:57 GMT https://communities.sas.com/t5/SAS-Programming/Order-columns-in-a-data-set/m-p/134388#M260890 Rick_SAS 2014-09-08T13:19:57Z