topic Re: New variable in SAS Programming

New variable

SASPhile — Wed, 27 Apr 2011 15:07:27 GMT

%MACRO OUTPUT(DSN,MARKET,GROUP1,GROUP2,GROUP3);

%DO I=1 %TO 3;
%put GROUP= &&GROUP&I;
%IF %NRQUOTE(&&GROUP&I)= %THEN %DO;
%LET VGROUP&I = ;
%END;
%ELSE %DO;
%LET VGROUP&I = "&&GROUP&I"N;
%END;
%put VGROUP= &&VGROUP&I;

%END;

%mend output;
%OUTPUT(ANTIF,ANTI-FUNGAL
,ABC,DE F,HIJ);

How to create another macro variable name which resolves as follows:
'ABC,'DEF',HIJ'
i.e
name resolves to 'ABC,'DEF',HIJ'

Re: New variable

SPR — Wed, 27 Apr 2011 18:01:37 GMT

Hello SASPhile,

You wrote: How to create another macro variable name which resolves as follows:
'ABC,'DEF',HIJ' i.e name resolves to 'ABC,'DEF',HIJ'

%let New='ABC,'DEF',HIJ';

Is this what you need?

Sincerely,
SPR

Re: New variable

SASPhile — Wed, 27 Apr 2011 18:06:13 GMT

Yes.
But macro variable 'NEW' are the postional parameters. They may change whenever the user passes a new value.
So it should be dynamic.

Re: New variable

SPR — Wed, 27 Apr 2011 18:17:16 GMT

How about this within your macro:

%let new="&GROUP1.","&GROUP2.","&GROUP3.";?

Re: New variable

SASPhile — Wed, 27 Apr 2011 18:27:47 GMT

The reason to create %let name is to use it in subsetting the dataset in the next step.
i.e where condition where rolrod in (&name);

The problem with that is:

there could be group1 to group9 values.but sometimes user passes only 6 or 5 or 3 values .
so in the %let name statement if we define from group1 to group9

and only three values are passed
the macro varible will have missing values in the end like this

%let name= 'ABC','DEF',HIJ',,,,,, ;

Re: New variable

chang_y_chung_hotmail_com — Wed, 27 Apr 2011 19:00:45 GMT

%*-- comma separated quoted values --*;
%macro csqv(key1,key2,key3,key4,key5,key6,key7,key8,key9);
   %local i k;
   %do i = 1 %to 9;
      %let k = &&key&i;
      %if &k= %then %goto cont;
      %if &i>1 %then %*;,;
      %*;%sysfunc(quote(&k))
      %cont:
   %end;
%mend csqv;
%put ***%csqv(abc, def, hij)***;
%*-- on log
***"abc","def","hij"***
--*;

Re: New variable

SASPhile — Wed, 27 Apr 2011 19:05:16 GMT

%cont is not defined!?

Re: New variable

Ksharp — Thu, 28 Apr 2011 03:36:34 GMT

How about:
[pre]

%MACRO OUTPUT(DSN,MARKET,GROUP1,GROUP2,GROUP3);
%let name=;
%let group1=%sysfunc(compress(&group1));
%let group2=%sysfunc(compress(&group2));
%let group3=%sysfunc(compress(&group3));

%DO I=1 %TO 3;
%let name=&name %str(%')&&group&i%str(%');
%END;
%let name=%sysfunc(translate(&name,%str(,),%str( )));
%put name= &name;

%mend output;
%OUTPUT(ANTIF,ANTI-FUNGAL,ABC,DE F,HIJ)

[/pre]

Ksharp

Message was edited by: Ksharp

Message was edited by: Ksharp

Re: New variable

Patrick — Thu, 28 Apr 2011 11:46:38 GMT

Hi SASPhile

Is it eventually this you're after?

%macro OUTPUT/parmbuff;

%let dsn=%scan(%bquote(&syspbuff),1,%str(%(,%)));
%let MARKET=%scan(%bquote(&syspbuff),2,%str(,%)));

%put dsn = &dsn;
%put market= &market;

%let i=3;
%let name=;
%do %while(%scan(%bquote(&syspbuff),&i,%str(,%))) ne );
%let group&i =%scan(%bquote(&syspbuff),&i,%str(,%)));
%let vgroup&i="&&group&i"N;
%if &name eq %then %let name="&&group&i";
%else %let name=&name.,"&&group&i";

%put group= &&GROUP&I;
%put VGROUP= &&VGROUP&I;

%let i=%eval(&i+1);
%end;

%put name= &name;

%mend OUTPUT;

%OUTPUT(ANTIF,ANTI-FUNGAL,ABC,DE F,HIJ)

%OUTPUT(ANTIF,ANTI-FUNGAL,ABC,DE F,HIJ, xxxx, yy yy)

HTH
Patrick Message was edited by: Patrick

Re: New variable

SASPhile — Thu, 28 Apr 2011 15:21:23 GMT

if one of the parameters is like this ABC/DEF?

Re: New variable

Patrick — Fri, 29 Apr 2011 04:00:20 GMT

Hi SASPhile

"if one of the parameters is like this ABC/DEF?"

You're the one who knows best what strings could be passed - and probabely you need to play around a bit more with quoting and unquoting.

For the case you've given using %qscan() instead of %scan() in the %do..%while loop does the trick:
%do %while(%qscan(&syspbuff,&i,%str(,%))) ne );

HTH
Patrick

Re: New variable

SASPhile — Mon, 09 May 2011 19:39:40 GMT

Hi,
How to insert a record?
when passing the parameters say ABC is not present in the dataset, we need to insert a record for ABC in the dataset.

Re: New variable

Ksharp — Tue, 10 May 2011 03:37:57 GMT

[pre]
data class;
set sashelp.class;
run;
proc sql;
insert into class
set name='ABC',age=10;
quit;
[/pre]

Ksharp