topic Re: Key for nodupkey in SAS Programming

Key for nodupkey

SASdevAnneMarie — Wed, 06 Jul 2022 09:08:48 GMT

Hello Experts,

I have a file with duplicate values and the same data with no duplicate values. I can import the 2 files. Do you know please how to find the key of sorting ?

Thank you !

Re: Key for nodupkey

andreas_lds — Wed, 06 Jul 2022 10:58:11 GMT

I am sure that i don't understand your problem.

If you use proc sort with "presorted" options, sas will only sort the dataset if it is not already sorted by the variable you provide.

Re: Key for nodupkey

Patrick — Wed, 06 Jul 2022 12:06:21 GMT

@SASdevAnneMarie Put yourself into our shoes and assume you read below without any further information and context:

I have a file with duplicate values and the same data with no duplicate values. I can import the 2 files. Do you know please how to find the key of sorting ?

...and now that you understand please try and provide all the necessary information so we can help you to help yourself.

Re: Key for nodupkey

SASdevAnneMarie — Wed, 06 Jul 2022 12:13:10 GMT

Hello Patrick,
I mean that I would like to do the proc compare between sorted and not sorted data. But I don’t know if proc compare can indicate the duplicate values. Thank you for your help.

Re: Key for nodupkey

Rick_SAS — Wed, 06 Jul 2022 13:42:20 GMT

It sounds like you have one data set that is unsorted and you want to check whether the unique values in the data match a specified set of "target" values, which are in a second data set. To do that you can use PROC SORT with the NODUP option and compare the output to the set of "target" values:

/* orig data */
data Have;
input x @@;
datalines;
4 3 2 5 6 4 3 2 2 2 3 5 4 7
;
proc sort data=Have nodup out=Want;
  by x;
run;

/* unique values ("target" values) that we want to compare against */
data Unique;
input x @@;
datalines;
2 3 4 5 6 7
;

proc compare base=Unique compare=Want;
run;