MACROS IN SAS.
in [SAS]
|
From: Patrick on 22 Apr 2010 04:52 Well: What's the problem?
From: Chris Jones on 22 Apr 2010 04:59 Why not use a format?
From: Tom Abernathy on 22 Apr 2010 07:44 On Apr 21, 5:59 pm, StorageDevil <ragup...(a)in.ibm.com> wrote: > Hi Der do we need to do something to a macro if we have written it > newly in SAS. > > %macro volsla; > Select; > When (Storgrp eq 'DB2SRTD') SLA_Util = 92; > When (Storgrp eq 'DB2SRTP') SLA_Util = 98; > When (Storgrp eq 'OPSNSRDF') SLA_Util = 60; > When (Storgrp eq 'OPSPRIME') SLA_Util = 90; > When (Storgrp eq 'SASPRIME') SLA_Util = 85; > When (Storgrp eq 'SCRTCHSD') SLA_Util = 90; > When (Storgrp eq 'TINBATCH') SLA_Util = 85; > When (Storgrp eq 'TINPRIME') SLA_Util = 90; > When (Storgrp eq 'TSOPRIME') SLA_Util = 90; > When (Storgrp eq 'TSOSMALL') SLA_Util = 90; > When (Storgrp eq 'TSTPRIME') SLA_Util = 95; > When (Storgrp eq 'USRPRIME') SLA_Util = 85; > Otherwise SLA_Util = 80; > End; > Label SLA_Util = 'SLA*Util%'; > > %mend; > > This macro is running fine and I have a need to make a change to it to > make it to 60 for OPSNSRD. But anyhow it is stored in a new member and > not the old member so I call it volslaI > > This is my sas code: > > Data Storgrp; > Set VOLSUM; > File ALRTLOG; > %VOLSLAI; /* SLA_Util for storage group set in macro */ > If MeanPct < SLA_Util Then Delete; > > Put @01 Date date9.0 > @11 Time time5.0 > @18 Storgrp $8.0 > @27 SLA_Util 3.0 > @32 MeanPct 3.0 > @38 '/' > @41 Num_Vols 3.0 > @48 Sum_Capa 4.0 > @54 Sum_Aloc 4.0 > @60 MeanFree 4.0 > @67 Larg_Ext 4.0 ; > > Now IT S JUST AN ASSUMPTION THAT MEANPCT is 82 and SLA_UTIL is now 60 > so can some give any suggestion as to what am I doing wrong here... If you are using autocall to load the macros then after the first call the macro will already be compiled and so changes to the source code will not take effect. You will need to SUBMIT the source code for the macro so that SAS will compile the new version.
|
Pages: 1 Prev: Proc Report Line@ Next: PROC MIXED, panel data and fixed effects |