About Kelroy22

Kelroy22 · ‎01-08-2019

It Works if im opening a complete new sas e.g. program but it is not working in an exisiting sas e.g. project? Have you any idea why? Steffan

Kelroy22 · ‎01-08-2019

I have used the proc print inside and outside a macro. Still not working.

Kelroy22 · ‎01-08-2019

Hi. Do you Guys have any idea why the labeling is not working? proc print data=work.CONTROL label; var ProductType PapirNavn isinkode fondskode nominal_base ca_pv_base SystemNr DelBeh NotaNr riskType; label nominal_base = 'Nominelt d.kr.' ca_pv_base = 'Kursvardi d.kr.'; run;

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;

Kelroy22 · ‎06-25-2018

Hi. Ive made a macro that should send an email of there are observations in the dataset control. Unfortunately it doens't wok. Can some of you guys see what im doing wrong? %macro doit; %let id=%sysfunc(open(Control)); %let NObs=%sysfunc(attrn(&id,NOBS)); %syscall set(id); %do i=1 %to &NObs; %let rc=%sysfunc(fetchobs(&id,&i)); filename mymail email subject="Risk Control IRK: Violation in HQLA Concentration Risk" to="SAN@RISK.DK" data _null_; file mymail; put "HQLA"; put "- Paper : &papirnavn"; put "- Nominal : &NominalBase"; put "----------------------"; run; run; % %end; %let id=sysfunc(close(&id)); %mend; %doit;

Kelroy22 · ‎10-04-2017

*There is a earlier topic describing how to replace multiple targets using tranwrd in a loop function. Unfortunately it is somehow not working for all types of Words that I want to replace. In the below code I want to remove. "koncern-LK.ramme" but the function fails to do so. Does anybody know what I am doing wrong?. Thx data x; set y; newName = OldName; do word="kon.-LK", "koncern-LK.ramme"; newName = tranwrd(' '||newName, ' '||strip(word)||' ', ' '); end; newName = compbl(newName ); drop word; run;

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: 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.