Hello, There is no SAS option to do this on temp bases?
I have a data set that is stacked from different sources of customers (in this case students) names, sex, birthdates, and enterprise customer id but in my case because of different db. sources one db. might have a name change in it that is a legitimate difference I want to keep (name changes might not be replicated to all our db. systems), whether that be a typo correction or full legal name change I want to keep those differences and others might just be simple upper-lower case differences to do data entry issues. What I want to do is drop out all that are just upper-lower case differences and keep just one of those obs. my code...
proc sql;
create table xd_person_want_A7 as
select
distinct
EMPLID,
last_name,
first_name,
middle_name,
name_suffix,
name_display,
sex,
birthdate
from xd_person_want_A6
order by EMPLID, last_name, first_name, middle_name, name_suffix, name_display, sex, birthdate
;quit;
proc print data = xd_person_want_A7 (obs=3);run;

* --- dedup check of just one columns in the key ---;
proc sort data = xd_person_want_A7 nodupkey out = test dupout = dups ;
by emplid;
run;
/* I get some 5K+ dups out of 250k+- obs,,, so, in this case, my next move it working towards making a data warehouse data set keeping the emplid as a foreign key (to link to my fact table) but making my own SID_emplid key for this new db. I am not sure how to use upcase in this example without the output getting changed to all up case, there is no "SAS option" to do this? Most names are formatted in the typical Cap first letter way and I did not want to muck with them in my new data warehouse */

%put &max_SID_emplid2.;
/* Here we use the max_sid_emplid calculated in the beginning of this code.
It keeps the sid keys starting off with next logical key */
data xd_person_want_A8;
set xd_person_want_A7;
by EMPLID last_name first_name middle_name name_suffix name_display sex birthdate;
retain sid_emplid2;
if sid_emplid2=. then sid_emplid2=&max_SID_emplid2.;
sid_emplid2=sid_emplid2+1;
run;