Hi, I cannot test your code right now but please check if what i say works.... In your proc report statement just add an out= and run the code once PROC REPORT DATA= TEST3 out=check_file; View the data set check_file Since you have used an across variable i think you would be able to see certan columns like _C6_ , _C7_ So in your proc report your compute block should look something like compute pct_cum; _c8_ = _c7_ / _c6_; _c11_ = _c10_ / _c9_; endcomp; And also i think you Donot need to repeat your calculation in the COMPUTE AFTER block. Hope it helps ... View more

Hi Milts, Do update this post if you do find a solution.... I too wanted to try and remove the authentication for web reports / dashboards Though this could be done for STP could not replicate the same for web reports ... View more

Hi, You have used the below statement in one of you proc reports where put(SR_NO,num.)="&&SR_NO&i"; The NUM. is a user defined format which may have created by the person who has written this code. Since i cannot see any code for the format in your program i would assume that the format has been added to the library.formats catalog. So when you run this in EG. You donot get an error as sas is able to read the format. I believe you can look at creating and storing the format again  in a predefined library or a libref and then use the fmtsearch= option in your STP.. or Add your proc format code to this program. That should solve your problem.. Hope this helps.... ... View more

Hi, What i usually use is . PROC TRANSPOSE DATA=target OUT=WANT; BY ID YEAR; RUN; Please check if it helps.. But you do need to keep in mind your data size and the processing time. ... View more

It should be space with quotes. Please look at the sample that i have provided data maildset; email_id = " 'id@mail.com' 'id2@mail.com' 'id3@mail.com' "; run; However there seems to be a problem in the macro  Email that you have defined. You need to change the TO =  your &semailid should be in brackets and not quote. Please check the sample provided above. ... View more

Please forgive me maybe i am unable to understand your problem... Is it that you have a single cell in your table that will have all the emailids.....? data maildset; email_id = " 'id@mail.com' 'id2@mail.com' 'id3@mail.com' "; run; data _null_; set MailDset; call symput("SEmailid",trim(eMAIL_ID)); run; %put &v_email_id; %MACRO email(SEmailid);   FILENAME mymail EMAIL /*"NULL" */   TO= ( &SEmailid );    data _null_;     FILE mymail;        /*  END; */ run; %MEND; %email(&SEmailid); If this does not help then probably you should post your log with the Mprint and Symbolgen so that the experts can look at it provide a solution. ... View more

Hi, Is your objective to send the same mail to all the Ids in your data set ? Then something that works for me is proc sql; select distinct quote(strip(email_id)) into : semailid separated by " " from maildest; quit; %MACRO email(SEmailid);   FILENAME mymail EMAIL /*"NULL" */   TO= ( &SEmailid ) from="myid@mail.com";      data _null_;     FILE mymail;     /*    END; */ run; %MEND; %email(&semailid); ... View more

Hi, Two Possible ways that you can have a look at... Hope it helps data a; input mailid : $50. subject : $10.; cards; id1@mail.com test1 id2@mail.com test2 id3@mail.com test3 ; run; *solution 1; filename message email from = "mainid@mail.com"; data _null_; file message; set a; put '!EM_TO!' mailid; put '!EM_SUBJECT!' subject; put "This is just a test"; put '!EM_SEND!';       put '!EM_NEWMSG!';     put '!EM_ABORT!'; run; *Solution 2; %MACRO email(pEmailid,psubject); FILENAME mymail EMAIL TO="&&pEmailid"  SUBJECT="&&pSubject" from="mainid@mail.com" ct='text/html'; data _null_; FILE mymail;  run; %MEND; DATA _NULL_ ; set a; call execute('%email('||mailid||' ,'||subject||')'); run; ... View more

Hi, I think what you are looking for is a title before your ods layout... I cannot test this right now but i remember using something like the below code. ods escapechar="~"; title "~{style [ just=center] This is my title}";  Hope it helps. ... View more

Hi, If you are adding the %put to your filename statement.. Would the Semi colon not end the filename statement? I think if you are trying to send the mail to all three ids then you should have a space instead of semicolon. %let a=%str("ak.gmail.com" "lkp.gmai.com" "rk@gmail.com"); %put &a; ... View more

Hi gregg, The libname statement gives the following error ERROR: Library DB is not in a valid format for access method RANDOM. ERROR: Error in the LIBNAME statement. I think what you have suggested would work on windows. But since i am on a Unix platform maybe it doenot work here. Thanks... ... View more

Hi Cynthia, The colurs for the rbreak and break that i get differ with your output. Have attached a screenshot Since you seem to be getting the correct output . Then this may be a bug.. As Ksharp said shall have to raise a track. Thanks Ksharp... I was already using what you have suggested .. I just wanted to know why my report was incorrect when using compute before. Thanks a lot.. ... View more