topic Re: parameter with arguments with plus sign in SAS Programming

parameter with arguments with plus sign

Ronein — Thu, 23 Aug 2018 10:19:15 GMT

Hello

Let's say that in vector parameter we have 5 arguments:

current month+previous month+last DEC+same month previous year+last month previous quarter

Sometimes some arguments are same.

for example:

current month=1807

previous month=1806

last DEC=1712

same month previous year=1707

last month previous quarter=1806

vector=1807+1806+1712+1707+1806;

How can I tell sas that in case that there are identical arguments in &vector parameter to leave only one of them.

so I want that vector=1807+1806+1712+1707;;

Re: parameter with arguments with plus sign

RW9 — Thu, 23 Aug 2018 10:31:42 GMT

Store data in a dataset, then use Base SAS datasteps and procedures to manipulate data. This is the fundamental of SAS programming.

Re: parameter with arguments with plus sign

Kurt_Bremser — Thu, 23 Aug 2018 10:32:52 GMT

If you kept your data in a small dataset (which is the sensible thing to do) instead of a macro variable (which is usually not the smartest thing to do - I'm being polite here!), you'd only need a sort nodupkey or a select distinct.

Re: parameter with arguments with plus sign

Ronein — Thu, 23 Aug 2018 11:07:15 GMT

Thank you.

You are telling me to store the information in data set and then take distinct values.

But ,I get the data in parameter as I showed so we need to search for solution from here.

There is no data set.

How can I create a data set from information in parameter?

Re: parameter with arguments with plus sign

PaigeMiller — Thu, 23 Aug 2018 11:10:01 GMT

Read it into a data set. Then manipulate it.

Re: parameter with arguments with plus sign

Kurt_Bremser — Thu, 23 Aug 2018 11:10:42 GMT

data quarters (keep=quarter);
length quarter $4;
do i = 1 to countw("&param","+");
  quarter = scan("&param",i,"+");
  output;
end;
run;

and you got a nice dataset from which to work.

Re: parameter with arguments with plus sign

Ronein — Thu, 23 Aug 2018 12:35:35 GMT

So now from the &vector parameter I created a data set.

Then I took the distinct values.

Now I need to create again a parameter with multiple values with + between them

I should I do the final step please?

%let vector=1807+1806+1712+1806;

data tbl1 (keep=YYMM);
length YYMM $4;
do i = 1 to countw("&vector","+");
  YYMM = scan("&vector",i,"+");
  output;
end;
run;

PROC SQL;
	create table tbl2 as
	select 	 distinct YYMM  
	from tbl1
;
QUIT;

/*Now I want to create a parameter called  &vector2 that will get the values in table tbl2 with + symbol between values*/

Re: parameter with arguments with plus sign

Kurt_Bremser — Thu, 23 Aug 2018 12:38:51 GMT

The question is: what will you be doing with that "vector"? There is a fair chance that you can do that directly off the dataset.