You can solve this in many ways, programmatically. One way is to have data step that evaluates the macro variable, and does explcit OUTPUT. And the PROC APPEND to you target table.   I imagine that you build macro logic to dynamically generate PROC SQL INSERT statments directly into the target table. ... View more

Hi,   I see the error in the SQL   There must not be ',' after  t1.PUTMONTH   Kind regards   Natalja ... View more

Hi, Firstly rank by ID ( MENU TASKS/DATA / RANK) . Secondly create file DUPS with new field Duplicate and put ’DUPS’ where rank_sub_id=2. PROC RANK DATA = active_records TIES=MEAN OUT=WORK.RANKRanked(LABEL="Rank Analysis for WORK.active_records"); BY ID; VAR SUB_ID; RANKS rank_SUB_ID ; PROC SQL; CREATE TABLE WORK.DUPS AS SELECT t1.ID, t1.Category, t1.SUB_ID, /* DUPLICATE */ (CASE when t1.rank_SUB_ID=2 then 'DUPS' end) AS DUPLICATE FROM WORK.RANKRanked t1; QUIT; Kind regards Natalja ... View more

Thank you Nataljak. The image below is how I set it up. Program2 and Program3 both have this condition which work as expected. The macro variable, &ReturnCode_1, is set in Program1.     Email is sent regardless of the condition. The conditions work fine for the selection of which program to run, but the email is sent regardless of the condition. It appears to me that the email process exists in the "Distribution" processing whereas the condition logic only applies to the "Process Flow" processing.      We use server based SAS EG and MS Office365 as our email system. Although I understand that sending email in my program is supposedly possible, I have been unable to locate in the SAS Community a version that works for our situation, yet I can send email easily via the "Send To" - - -> "Email Recipient as a step in the project" methodology.   Regards,   Gary ... View more

The first portion of the code generates fake data. The code to make the graph is the last 3 lines. ... View more

Hi, in PROC TABULATE, you can't highlight one column based on the value of another column. But, as you know, this is easy to do with PROC REPORT using the CALL DEFINE statement and a COMPUTE block. cynthia ... View more

Hi Chris, Thank you for the prompt reply. Unfortunately , my Base SAS (9.3 M1)  have nither targset.tableeditor nor htmlscroll statements in the library. I create a  HTML report using tagset htmlpanel. But this one does not have the options for scroll also. I work with SAS EG installed in a stand-alone  PC. ... View more

you could rewrite the mean function into it's component parts: MOTW=sum(of jan--june)/(n(of jan--june) + nmiss(of jan-june)); This would only be missing if all the flight entries are missing and count the other missing values as 0's. ... View more

Thank you for the real assistance! ... View more