https://communities.sas.com/t5/SAS-Programming/Group-variable-repeat-only-once/m-p/342505#M78537 <P>Sort the dataset by X<BR />Then use the condition if first.X ne 1 and last.x ne 1;</P><P>Output;</P><P>Else x=' ';</P><P>Output;</P> Mon, 20 Mar 2017 09:44:51 GMT gauthamk28 2017-03-20T09:44:51Z https://communities.sas.com/t5/SAS-Programming/Group-variable-repeat-only-once/m-p/342502#M78536 <P>Hi I have the following input</P> <P>&nbsp;</P> <P>X &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Z</P> <P>a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20</P> <P>a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;def &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19</P> <P>a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;hij &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100</P> <P>b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120</P> <P>b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 80</P> <P>b &nbsp; &nbsp; &nbsp; &nbsp; M &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40&nbsp;</P> <P>&nbsp;</P> <P>I need output as</P> <P>X &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Z</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; abc &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20</P> <P>a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;def &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 19</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; hij &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; T &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120</P> <P>b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;F &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 80</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 20 Mar 2017 09:42:41 GMT https://communities.sas.com/t5/SAS-Programming/Group-variable-repeat-only-once/m-p/342502#M78536 molla 2017-03-20T09:42:41Z https://communities.sas.com/t5/SAS-Programming/Group-variable-repeat-only-once/m-p/342505#M78537 <P>Sort the dataset by X<BR />Then use the condition if first.X ne 1 and last.x ne 1;</P><P>Output;</P><P>Else x=' ';</P><P>Output;</P> Mon, 20 Mar 2017 09:44:51 GMT https://communities.sas.com/t5/SAS-Programming/Group-variable-repeat-only-once/m-p/342505#M78537 gauthamk28 2017-03-20T09:44:51Z https://communities.sas.com/t5/SAS-Programming/Group-variable-repeat-only-once/m-p/342508#M78539 <P>Is this for display or as a dataset? Assuming for a report/display use Proc Report with the GROUP variable.&nbsp;</P> Mon, 20 Mar 2017 09:46:55 GMT https://communities.sas.com/t5/SAS-Programming/Group-variable-repeat-only-once/m-p/342508#M78539 Reeza 2017-03-20T09:46:55Z