About Kelroy22

Kurt_Bremser · ‎01-08-2019

Work in steps. Start with the code that works, and then add code and test with every single step. Something in your other code causes a problem. And enable us to follow Maxim 2 (post the log).

Kelroy22 · ‎06-26-2018

My solution ended like this. Thank you for your help. /Steffan %macro doit; proc sql noprint; select nobs into :nobs from dictionary.tables where libname = 'WORK' and memname = 'CONTROL'; quit; %if &nobs ne 0 %then %do; filename mymail email subject="Risk Control IRK: Violation in HQLA Concentration Risk" to="san@al-bank.dk" attach= (&HQLA. content_type="application/xlsx") CONTENT_TYPE="text/html"; ods listing close; ods html body=mymail; proc print data=work.control; run; ods html close; ods listing; %end; %mend; %doit;

s_lassen · ‎10-04-2017

@Kelroy22: Your problem is probably the length of the WORD variable - the DO statement initializes the variable to the length of the first value in the iteration, as you can see from this log: 1507 data _null_; 1508 do word="kon.-LK", "koncern-LK.ramme"; 1509 put word; 1510 end; 1511 run; kon.-LK koncern If you add a LENGTH statement it should work: 1512 data _null_; 1513 length word $20; 1514 do word="kon.-LK", "koncern-LK.ramme"; 1515 put word; 1516 end; 1517 run; kon.-LK koncern-LK.ramme

Online Status	Offline
Date Last Visited	‎02-11-2019 08:57 AM

Re: Labeling within a macro.

Re: Labeling within a macro.

Labeling within a macro.

Re: Send Email if Nobs - if not, dont.

Send Email if Nobs - if not, dont.

Fail to replace multiple targets using tranwrd using a loop.

Labeling within a macro.

Re: Labeling within a macro.

Re: Send Email if Nobs - if not, dont.

Re: Fail to replace multiple targets using tranwrd using a loop.