## Repeated data

Solved
Frequent Contributor
Posts: 76

# 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,405

## Re: Repeated data

[ Edited ]

Like this?

`data have;input A;datalines;17.9317.9317.9317.9317.9317.9323.2923.2923.2923.2924.0024.0024.0024.008.7188.7188.7188.71824.1724.1724.1724.1724.1724.1713.7513.7513.7513.75;data want; set have; by A notsorted; if not first.A then A=.;run;`

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

## Re: Repeated data

[ Edited ]

Like this?

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