Hi. I'm using Proc Tabulate with the Out= option. In my data I keep 3 variables: 1. rule_order 2. ad_dt 3. n   Proc tabulate data=FinalData missing out=testdata (keep=rule_order ad_dt n) ; class Rule_Order ad_dt; table rule_order*(ad_dt all)*n; run;   My problem is that the AD_DT's that are missing have a value of . (missing) but my totals by Rule_Order also have a . (missing). In the data I would like to be able to recode the totals that have a . to be 'Total', but I don't see a way to do this.   I've attached a sample of what my output dataset Testdata looks like.   Any help would be much appreciated. ... View more

  Hi. I have some output that doesn't quite match my requirements. In the Proc Summary below I need to add some missing components:   1.  a total count of all AD_DTs for each Rule_Order 2. AD_DT's should display in a MM/DD/YYY format   Sample data attached.   Any help would be greatly appreciated.   PROC SUMMARY data=FinalData print; CLASS rule_order ad_dt; run;   The SUMMARY Procedure RULE_ORDER AD_DT N Obs ----------------------------------------- 1 14MAR16:00:00:00 5 15MAR16:00:00:00 3 16MAR16:00:00:00 14 17MAR16:00:00:00 13 18MAR16:00:00:00 20 19MAR16:00:00:00 19 22MAR16:00:00:00 4 25MAR16:00:00:00 2 1.5 15MAR16:00:00:00 1 17MAR16:00:00:00 1 18MAR16:00:00:00 2 19MAR16:00:00:00 6 21MAR16:00:00:00 12 22MAR16:00:00:00 4 23MAR16:00:00:00 7 24MAR16:00:00:00 18 25MAR16:00:00:00 110 -----------------------------------------   ... View more

%let RULE=A.ROWID IN (SELECT TABLE_ROWID FROM IV_RPT.COMPARE_ERROR);     I have a macro variable defined as above.  I need to search this value sometimes and replace ' IV_RPT.' with ' IVPRL.' before the macro variable is referenced later in my program.  Does SAS offer a Replace function of some type?  Any suggestions would be greatly appreciated.  Thanks. ... View more

After my Rsubit statement I've been attempting to use the RDisplay statement to show the 'realtime' log output of my server-side program.  The server hostname is ISASPROD. I can't seem to get this working.  Is this what RDISPLAY is suppose to do?  Am I using the RDISPLAY statement in the wrong context or syntax?  Any help would be greatly appreciated. rsubmit; RDISPLAY remote=ISASPROD; ...more endrsubmit;   ... View more

I have a macro named CreateUniqueIndex.  At a certain point in my program I invoke it using the call execute('%CreateUniqueIndex').  But I need to conditionally invoke it only when the index doesn't already existing. I've tried some examples our there, but the conditions seem to be ignored.     Can anyone help me on this?     * Build Unique Index ; %macro CreateUniqueIndex; PROC DATASETS; MODIFY FinalData; INDEX CREATE imb_code / UNIQUE NOMISS; run; %mend CreateUniqueIndex;     * Build unique index if not exist ; DATA _NULL_; call execute('%CreateUniqueIndex'); RUN; ... View more