Hello:
I have the sample dataset list below. I would like to remove the duplicates of "Group" of (100, 200, 300 and 400) if I could find the
same text in the subgroup of 101-199, 201-299, 301-399 or 401-499. Please help. Thanks.
data test;
infile datalines dsd;
input Group Class : $20. Component : $20. Product : $20.;
datalines;
100, ANTI/INSULIN, , ,
100, ANTI/VITA, , ,
100, PHENAZO, , ,
112, ANTI/VITA, , ,
150, PHENAZO, , ,
180, PHENAZO, , ,
181, Large, , ,
200, , HERBS, ,
200, , PSYCH, ,
200, , BANZOCAINE, ,
200, , Large, ,
210, , SKIN, ,
270, , HERBS, ,
280, , BANZOCAINE, ,
300, ANTI/INSULIN, , PHENAZO,
300, ANTI/INSULIN, , ANTI/VITA,
322, ANTI/INSULIN, , PHENAZO,
377, ANTI/INSULIN, , Large,
400, , , FLOWER,
400, , , SUBST,
421, , , BANZOCAINE,
422, , , FLOWER,
;
data final;
infile datalines dsd;
input Group Class : $20. Component : $20. Product : $20.;
datalines;
100, ANTI/INSULIN, , ,
112, ANTI/VITA, , ,
150, PHENAZO, , ,
180, PHENAZO, , ,
181, Large, , ,
200, , PSYCH, ,
200, , Large, ,
210, , SKIN, ,
270, , HERBS, ,
280, , BANZOCAINE, ,
300, ANTI/INSULIN, , ANTI/VITA,
322, ANTI/INSULIN, , PHENAZO,
377, ANTI/INSULIN, , Large,
400, , , SUBST,
421, , , BANZOCAINE,
422, , , FLOWER,
;
data test;
infile datalines dsd;
input Group_code 1. @-1 Group 3. Class : $20. Component : $20. Product : $20.;
datalines;
--- your data ---
; run;
proc sort data=test; by group_code class Component Product ; run;
data want;
set test;
by group_code class Component Product ;
if first.Product and last.Product; /* remove duplicates */
run;
Alternativly to line:
input Group_code 1. @-1 Group 3. Class : $20. Component : $20. Product : $20.;
use:
input Group Class : $20. Component : $20. Product : $20.;
group_code = int(group/100);
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.