topic Re: Repeated data in SAS Programming https://communities.sas.com/t5/SAS-Programming/Repeated-data/m-p/440204#M109925 <P>Like this?</P> <P>&nbsp;</P> <PRE>data have;<BR />input A;<BR />datalines;<BR />17.93<BR />17.93<BR />17.93<BR />17.93<BR />17.93<BR />17.93<BR />23.29<BR />23.29<BR />23.29<BR />23.29<BR />24.00<BR />24.00<BR />24.00<BR />24.00<BR />8.718<BR />8.718<BR />8.718<BR />8.718<BR />24.17<BR />24.17<BR />24.17<BR />24.17<BR />24.17<BR />24.17<BR />13.75<BR />13.75<BR />13.75<BR />13.75<BR />;<BR /><BR />data want;<BR /> set have;<BR /> by A notsorted;<BR /> if not first.A then A=.;<BR />run;</PRE> Mon, 26 Feb 2018 15:29:27 GMT PeterClemmensen 2018-02-26T15:29:27Z Repeated data https://communities.sas.com/t5/SAS-Programming/Repeated-data/m-p/440201#M109924 <PRE><CODE class=" language-sas">A 17.93 17.93 17.93 17.93 17.93 17.93 23.29 23.29 23.29 23.29 24.00 24.00 24.00 24.00 8.718 8.718 8.718 8.718 24.17 24.17 24.17 24.17 24.17 24.17 13.75 13.75 13.75 13.75</CODE></PRE><P>Hi guys&nbsp;</P><P>&nbsp;</P><P>In this variable A repeated numbers, I would like to keep only one appearance&nbsp;of each number, and the rest I should have a missing value.&nbsp;</P><P>my data set has this name P1FD</P><P>my best regards&nbsp;</P><P>&nbsp;</P><P>Ibrahim&nbsp;</P> Mon, 26 Feb 2018 15:18:07 GMT https://communities.sas.com/t5/SAS-Programming/Repeated-data/m-p/440201#M109924 Barkamih 2018-02-26T15:18:07Z Re: Repeated data https://communities.sas.com/t5/SAS-Programming/Repeated-data/m-p/440204#M109925 <P>Like this?</P> <P>&nbsp;</P> <PRE>data have;<BR />input A;<BR />datalines;<BR />17.93<BR />17.93<BR />17.93<BR />17.93<BR />17.93<BR />17.93<BR />23.29<BR />23.29<BR />23.29<BR />23.29<BR />24.00<BR />24.00<BR />24.00<BR />24.00<BR />8.718<BR />8.718<BR />8.718<BR />8.718<BR />24.17<BR />24.17<BR />24.17<BR />24.17<BR />24.17<BR />24.17<BR />13.75<BR />13.75<BR />13.75<BR />13.75<BR />;<BR /><BR />data want;<BR /> set have;<BR /> by A notsorted;<BR /> if not first.A then A=.;<BR />run;</PRE> Mon, 26 Feb 2018 15:29:27 GMT https://communities.sas.com/t5/SAS-Programming/Repeated-data/m-p/440204#M109925 PeterClemmensen 2018-02-26T15:29:27Z