topic distinct values of macro varaible (vector) in SAS Programming

distinct values of macro varaible (vector)

Ronein — Wed, 22 Apr 2020 08:21:54 GMT

Hello

I have a sas macro varaible that get multiple values seaprated by plus sign.

For example

%let Vector=2001+2001+2002+2003+2003+2003+2004;

My question is how to create from this macro variable another macro varaible that have distinct values.

So in this example I should get"

%let NewVector=2001+2002+2003+2004;

Thanks

Jow

Re: distinct values of macro varaible (vector)

Jagadishkatam — Wed, 22 Apr 2020 08:34:39 GMT

you can try something as below

%let Vector=2001+2001+2002+2003+2003+2003+2004;

data have;
var="&vector";
count=countw(var,'+');
do i= 1 to count;
var2=scan(var,i,'+');
output;
end;
run;

proc sql;
select distinct var2 into: vector separated by '+' from have;
quit;

%put &vector;

Re: distinct values of macro varaible (vector)

ballardw — Wed, 22 Apr 2020 08:46:40 GMT

Perhaps you can show how you build that "vector" to begin with? Perhaps that step could be modified to not have duplicates.

Re: distinct values of macro varaible (vector)

Kurt_Bremser — Wed, 22 Apr 2020 09:16:08 GMT

That's why you do NOT store data in macro variables. With data in datasets, it's a simple select distinct or proc sort with nodupkey.

Re: distinct values of macro varaible (vector)

RichardDeVen — Wed, 22 Apr 2020 13:20:12 GMT

A regular expression search and replace can remove repeated adjacent years.

options nosource;

%let years = 2001+2001+2002+2003+2003+2003+2004;

%let rxid = %sysfunc(prxparse(s/((\d+)\+)(\1)+/\1/));
%let times = -1;

%put NOTE: before, &=years;

%syscall prxchange(rxid,times,years);
%syscall prxfree(rxid);

%put NOTE: after,  &=years;

%symdel years rxid times;

Log

NOTE: before, YEARS=2001+2001+2002+2003+2003+2003+2004
NOTE: after,  YEARS=2001+2002+2003+2004