Correct!   I was looking for the same and found it.   Thanks.   - Dr. Abhijeet Safai ... View more

See Casey Smith's reply in this thread: https://communities.sas.com/t5/SAS-Enterprise-Guide/Making-EG-Stop-Executing-subsequent-process-flows-based-on-a/m-p/313292#M21132 Project Properties > Code Submission > Action to take on errors during execution ... View more

@Fugue I know, thats an old post, but Maybe someone in the future will see and read this, so I will answer this. When the RegKey is set, there should no longer be any Problems with installing or uninstalling SAS-Software. But be Aware, that you may have to set the RegKey again after any uninstall, since SAS seems to delete the RegKey while its uninstall-task.     ... View more

Thanks for the reply, Juan. As for AMO, we are using the latest 9.4 standalone installer and it detects and installs the correct version based on Office bitness.   My "problem" is that I don't understand what SAS-Office "interoperability" means with respect to Base SAS/EG. As I replied to Patrick, I am able to import/export to/from SAS/Excel regardless of bit match - without any special code, which seems to contradict Chris' blog posts. ... View more

HI,   I found a pretty cool add-in to Base SAS on www.tatesoft.com that may be very usefull to you. The tool called Log Analyser is integrated into Base SAS and can produce Log summary report in a second. You may also analyse log in details if you wish. Really great tool! ... View more

I have a large number of variables so I'll need to go the macro route.    Not sure what I'm doing, this is what I have so far.  What am I doing wrong?   PROC IMPORT OUT= WORK.IDs DATAFILE= "G:\FinUnitReporting\IFASDEMIScombined.xlsx"             DBMS=xlsx REPLACE;      SHEET="sheet1";      GETNAMES=YES; RUN; proc sql; create table RawData as  select *  from work.IDs; *; %macro rpt(area); Proc sql;   Create table t1 as Select * from RawData Where area = “&area.”; %mend; *; %put _user_; /* for testing %rpt(CF1); */ /*************************************************************    loop processing **************************************************************/ *; proc sql;   create table grp1 as   select distinct area   from  RawData   order by 1; quit; filename loops TEMP; DATA _NULL_; FILE LOOPS; SET grp1   PUT '%rpt (' area  ');' / '*;'; run; *; %inc loops; *; ... View more

Cynthia- Thanks for your explanation on 'paged'.  As to excel, if you go to insert tab, then insert object you can embed a pdf. I have some vba code that actually embeds the pdf and then renames it.   I am trying to translate that to vbs w/o much success. If i figure that out, then I will share it.   Unfortunately the Microsoft developers network is nowhere as near as helpful as the SAS community forum and in some cases seems outright nasty in some of the threads.     Glad to be using SAS 98% of the time!    What I am trying to do is the holy grail to some degree but one of my colleagues needs to embed 200+ pdf's into excel documents.    Lawrence           ... View more

One way is to write you own transpose step instead of using the EG template.  Then you can define the number of "GIFT" columns that are defined.  So for example this code will create GIFT1 to GIFT4 and than any other gifts will be summarized in GIFT_REST.   data want ; set have ; by ID ; array G gift1-gift4 gift_rest ; if first.id then do ; call missing(of G(*)); col=0; end; col+1; if last.id then col=5 ; g(col) = sum(g(col),GIFT); if last.id then output; retain gift1-gift4 gift_rest ; keep id gift1-gift4 gift_rest ; run;   ... View more

@ ballardw . . . we rem'd out the style=PrinterListing command and this seems to have resolved the issue with font sizes being too large. Thanks for pointing me in that direction. ... View more