DATA Step, Macro, Functions and more

Repeated data

Accepted Solution Solved
Reply
Contributor
Posts: 55
Accepted Solution

Repeated data

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

Hi guys 

 

In this variable A repeated numbers, I would like to keep only one appearance of each number, and the rest I should have a missing value. 

my data set has this name P1FD

my best regards 

 

Ibrahim 


Accepted Solutions
Solution
‎02-26-2018 12:45 PM
PROC Star
Posts: 1,190

Re: Repeated data

[ Edited ]

Like this?

 

data have;
input A;
datalines;
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
;

data want;
set have;
by A notsorted;
if not first.A then A=.;
run;

View solution in original post


All Replies
Solution
‎02-26-2018 12:45 PM
PROC Star
Posts: 1,190

Re: Repeated data

[ Edited ]

Like this?

 

data have;
input A;
datalines;
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
;

data want;
set have;
by A notsorted;
if not first.A then A=.;
run;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 106 views
  • 0 likes
  • 2 in conversation