topic Re: conditional macro variable in New SAS User

conditional macro variable

mona4u — Tue, 16 Apr 2019 20:27:20 GMT

Hi all;

I am writing this conditional macro variable and I think I'm missing something. Also, I wasn't able to see how it resolve by %put statement and compile note option

this is the code

OPTIONS SYMBOLGEN mprint;

*OPTIONS MPRINT;

%let Year=2018;

%let Qtr=1;

%macro q1;

%let lastqyear=%eval(&year-1);

%let lastq=4;

%mend;

%macro otherq;

%let lastqyear=&year;

%let lastq=%eval(&qtr-1);

%mend;

%global lastQyear lastq;

%macro thisq;

%if &qtr=1 %then %do; %Q1; %end; %else %do; %otherq; %end;

%mend;

%let outpath=Z:\Reporting\Safety Reporting\2018\QC\AE_2018Mar30;

%let Hardlock=Z:\Reporting\Safety Reporting\&Year\Extract Data\SDTM\q&qtr;

%let Phlext=Z:\Reporting\Safety Reporting\&lastqyear\Extract Data\SDTM\q&lastq;

Re: conditional macro variable

ballardw — Tue, 16 Apr 2019 19:10:18 GMT

Your macro variables lastyear and lastq do not exist after the macros Q1 and OtherQ finish executing because the variables would be treated as local.

You would need to add

%global lastyear lastq;

to each of those macros before assigning the values to the variables.

Look up Macro Variable Scope

Re: conditional macro variable

Astounding — Tue, 16 Apr 2019 19:12:45 GMT

You're missing two things.

%LET statements need to end with a semicolon. You have a bunch of them missing. Perhaps they are missing only in what you posted, and not in what you actually ran.

The second item is that the newly created macro variables (LASTQYEAR and LASTQ) are %local to the macro that defines them. You need to add this statement:

%global lastqyear lastq;

The easiest place to add it is at the beginning of the %RESOLVE macro. That way, you only need to add it once.

Re: conditional macro variable

mona4u — Tue, 16 Apr 2019 19:29:05 GMT

it is still not working even after I put the semicolon

Re: conditional macro variable

mona4u — Tue, 16 Apr 2019 19:45:10 GMT

this is the error msg after I tried global statement

131

132 OPTIONS SYMBOLGEN mprint;

133 *OPTIONS MPRINT;

134

135 %let Year=2018;

136 %let Qtr=1;

137

138

139 %macro q1;

140 %let lastqyear=%eval(&year-1);

141 %let lastq=4;

142 %mend;

143

144 %macro otherq;

145 %let lastqyear=&year;

146 %let lastq=%eval(&qtr-1);

147

148 %mend;

149

150 %global lastyear lastq;

151

152 %macro resolve;

ERROR: Macro RESOLVE has been given a reserved name.

ERROR: A dummy macro will be compiled.

153 %if &qtr=1 %then %do; %Q1; %end; %else %do; %otherq; %end;

154

155 %mend;

156

157

158

159

160 %let outpath=Z:\Reporting\Safety Reporting\2018\QC\AE_2018Mar30;

161

162 %let Hardlock=Z:\Reporting\Safety Reporting\&Year\Extract Data\SDTM\q&qtr;

SYMBOLGEN: Macro variable YEAR resolves to 2018

SYMBOLGEN: Macro variable QTR resolves to 1

163 %let Phlext=Z:\Reporting\Safety Reporting\&lastqyear\Extract Data\SDTM\q&lastq;

WARNING: Apparent symbolic reference LASTQYEAR not resolved.

SYMBOLGEN: Macro variable LASTQ resolves to

Re: conditional macro variable

Astounding — Tue, 16 Apr 2019 19:48:03 GMT

This error means you have to change the name of the macro. RESOLVE is not a legal name.

Re: conditional macro variable

mona4u — Tue, 16 Apr 2019 19:53:40 GMT

now this is the error msg

197

198 OPTIONS SYMBOLGEN mprint;

199 *OPTIONS MPRINT;

200

201 %let Year=2018;

202 %let Qtr=1;

203

204

205 %macro q1;

206 %let lastqyear=%eval(&year-1);

207 %let lastq=4;

208 %mend;

209

210 %macro otherq;

211 %let lastqyear=&year;

212 %let lastq=%eval(&qtr-1);

213

214 %mend;

215

216 %global lastyear lastq;

217

218 %macro thisq;

219 %if &qtr=1 %then %do; %Q1; %end; %else %do; %otherq; %end;

220

221 %mend;

222

223

224

225

226 %let outpath=Z:\Reporting\Safety Reporting\2018\QC\AE_2018Mar30;

227

228 %let Hardlock=Z:\Reporting\Safety Reporting\&Year\Extract Data\SDTM\q&qtr;

SYMBOLGEN: Macro variable YEAR resolves to 2018

SYMBOLGEN: Macro variable QTR resolves to 1

229 %let Phlext=Z:\Reporting\Safety Reporting\&lastqyear\Extract Data\SDTM\q&lastq;

WARNING: Apparent symbolic reference LASTQYEAR not resolved.

SYMBOLGEN: Macro variable LASTQ resolves to

Re: conditional macro variable

Kurt_Bremser — Tue, 16 Apr 2019 20:22:07 GMT

macro thisq is never called
lastqyear is not defined global, so it stays local to q1 and otherq
all those calculations are much better done in a data step with date functions, the macros are not necessary at all

Re: conditional macro variable

Tom — Tue, 16 Apr 2019 20:24:17 GMT

Your %GLOBAL statement defined lastyear but your code referenced lastQyear .

You defined three macros, but you did not call any of them.

Re: conditional macro variable

Astounding — Tue, 16 Apr 2019 20:29:42 GMT

A missing letter: the %global statement should mention LASTQYEAR, not LASTYEAR.

Re: conditional macro variable

mona4u — Tue, 16 Apr 2019 20:30:19 GMT

Just edited the code and the macro didn't resolve

263

264 OPTIONS SYMBOLGEN mprint;

265 *OPTIONS MPRINT;

266

267 %let Year=2018;

268 %let Qtr=1;

269

270

271 %macro q1;

272 %let lastqyear=%eval(&year-1);

273 %let lastq=4;

274 %mend;

275

276 %macro otherq;

277 %let lastqyear=&year;

278 %let lastq=%eval(&qtr-1);

279

280 %mend;

281

282 %global lastQyear lastq;

283

284 %macro thisq;

285 %if &qtr=1 %then %do; %Q1; %end; %else %do; %otherq; %end;

286

287 %mend;

288

289

290

291

292 %let outpath=Z:\Reporting\Safety Reporting\2018\QC\AE_2018Mar30;

293

294 %let Hardlock=Z:\Reporting\Safety Reporting\&Year\Extract Data\SDTM\q&qtr;

SYMBOLGEN: Macro variable YEAR resolves to 2018

SYMBOLGEN: Macro variable QTR resolves to 1

295 %let Phlext=Z:\Reporting\Safety Reporting\&lastqyear\Extract Data\SDTM\q&lastq;

SYMBOLGEN: Macro variable LASTQYEAR resolves to

SYMBOLGEN: Macro variable LASTQ resolves to

Re: conditional macro variable

Tom — Tue, 16 Apr 2019 20:33:39 GMT

Why are you making things so complicated?

%let Year=2018;
%let Qtr=1;

data _null_;
   previous=intnx('qtr',yyq(&year,&qtr),-1);
   call symputx('lastqyear',year(previous),'g');
   call symputx('lastq',qtr(previous),'g');
run;

1577  %put &=year &=qtr;
YEAR=2018 QTR=1
1578  %put &=lastqyear &=lastq;
LASTQYEAR=2017 LASTQ=4

Re: conditional macro variable

Tom — Tue, 16 Apr 2019 20:38:48 GMT

Looks like it did what you asked.

You probably want to run one of those macros you defined.

Try adding this line before the last to %LET statements:

%thisq

Re: conditional macro variable

mona4u — Tue, 16 Apr 2019 20:52:38 GMT

this code is good put I still have limitations since I need the code to look to the same year if it the q2,q3,q4

Re: conditional macro variable

Kurt_Bremser — Tue, 16 Apr 2019 21:02:04 GMT

@mona4u wrote:

this code is good put I still have limitations since I need the code to look to the same year if it the q2,q3,q4

Have you even tried it before posting this?