BookmarkSubscribeRSS Feed
PhanS
Obsidian | Level 7

Hello,

 

Anyone can help much appreciated. How can I know whether if a duplicate of my sub_IDs that they are not the same. Example 

DATA have;
 INPUT
 sub_id : $6.
 gender : $1.
 dob : DATE9.
 race : $1.
 education : $1.;
 FORMAT dob DATE9.;
 LABEL
 sub_id = "id of a subject"
 gender = "gender"
 dob = "dob"
 race = "race"
 education = "level od education" ;
 DATALINES;
002039 F 27mar1971 1 G
001204 M 12jan1972 1 H
005023 M 15jun1969 2 C
003025 M 17apr1968 2 G
001204 M 23feb1972 1 H
003029 F 30dec1970 1 G
001106 F 25oct1973 2 C
002034 M 31jan1962 3 H
005003 M 15jun1969 2 C
001204 M 01jan1972 1 H
006101 F 08jul1970 2 C
;


proc print data = have;
run;

 

 

4 REPLIES 4
Reeza
Super User

What's your expected output from this data? I'm assuming that's sample input data.

 


@PhanS wrote:

Hello,

 

Anyone can help much appreciated. How can I know whether if a duplicate of my sub_IDs that they are not the same. Example 

DATA have;
 INPUT
 sub_id : $6.
 gender : $1.
 dob : DATE9.
 race : $1.
 education : $1.;
 FORMAT dob DATE9.;
 LABEL
 sub_id = "id of a subject"
 gender = "gender"
 dob = "dob"
 race = "race"
 education = "level od education" ;
 DATALINES;
002039 F 27mar1971 1 G
001204 M 12jan1972 1 H
005023 M 15jun1969 2 C
003025 M 17apr1968 2 G
001204 M 23feb1972 1 H
003029 F 30dec1970 1 G
001106 F 25oct1973 2 C
002034 M 31jan1962 3 H
005003 M 15jun1969 2 C
001204 M 01jan1972 1 H
006101 F 08jul1970 2 C
;


proc print data = have;
run;

 

 


 

PhanS
Obsidian | Level 7

I want to identify if there are duplicates among subjects. Sub_IDs 005023 and 005003 are identical. I want to find these two subjects.  

Reeza
Super User

Look at PROC SORT with the DUPOUT or NOUNIQUERECS options. 

Use the other variables, not ID, in your BY statement. 

PhanS
Obsidian | Level 7

Thank you. I will try.

 

Phan S.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 735 views
  • 0 likes
  • 2 in conversation