I am working on a project that requires me to send out hundreds of emails from SAS. I am able to create and attach attachments and send out the email via SAS, no problem there. The problem is there are images that need to be added to the body of the email. One thought is to have all these images placed on a DMZ web server and have me use html tags to point to the images... However the email body is already a 'Outlook Form' (not familiar with forms in outlook) and if I can just access the form in my SAS code that would be great. I have been poking around for papers on including a 'Outlook Form' but have not had any luck as of yet. Is it possible to access a 'Outlook Form' stored in Outlook(?) from SAS code? TIA, Jay ... View more

EG: SAS Enterprise Guide 4.1 (4.1.0.1019) I need to read in *.pdf file names off of our corporate share drives from EG / UNIX and create a SAS Dataset with the names. The mapped share I need to connect to from EG has this type of string when mapped: abcdefghij on 'Shared File Server (AAAAA-bbb-999)' (That is how it looks mapped to my B: Drive) There is a folder structure under that that looks like ... B:\Level1\Level2\Level3\*.pdf Below code is what I have for PC SAS where I have access to the Mapped Drive (B:) and it works perfect. I need to connect to the Share Drive and be able to do the same from EG running on the UNIX box.. Below Works Fine: %let dirname = B:\scorecards\12-2011_Data\Scorecards_Dec11_Data_V1; filename DIRLIST pipe "dir /B &dirname\*.pdf"; data dirlist ;      length fname $256;      infile dirlist length=reclen ;      input fname $varying256. reclen ; run; When I run the above code on EG I get a DirList SAS DataSet with the following value in the fname field: /bin/ksh: dir:  not found Any ideas? TIA, J ... View more

Proc Report ODS Format Question I need to have the text “Header I Want In Merged Row” in a merged cell (Or new row) that spans the entire table(s) of 4 columns. The text “Header I Want To Span Var1 and Var1” should only span the two columns Var1 and Var2. Like this: _______________________________________Header I Want In Merged Row________________________________              Header I want to Span Var1 and Var2           Header I want to Span Var1 and Var2        Var1           Var2                                     Var1             Var2 Here is the code I am using, right now the first two text lines are showing up under the 2 columns. ods layout start columns=2; option center; ods region; /* First Table */ proc report data=XXX split='*' nowd   style(header)=[backgroundcolor=#FAF3D4 foreground=Black just=center   ];   column (“Header I Want In Merged Row**Header I Want To Span Var1 and Var1' Var1 Var2 ) ;   define Var1 / style(column) = {cellwidth=1.5in just=center  }                  style(header)= {cellwidth=1.5in just=center background=white foreground=black };   define Var2 / style(column)= {cellwidth=1.5in just=center }                      style(header)= {cellwidth=1.5in just=center  background=white foreground=black }; run; /* Second Table */ ods region; proc report data=XXX split='*' nowd   style(header)=[backgroundcolor=#FAF3D4 foreground=Black just = center ];   column ((“Header I Want In Merged Row** Header I Want To Span Var1 and Var3' Var1 Var3) ;   define Var1 / style(column) = {cellwidth=1.5in just=center  }                  style(header)= {cellwidth=1.5in just=center background=white foreground=black  };   define Var3 / style(column)= {cellwidth=1.5in just=center }                      style(header)= {cellwidth=1.5in just=center  background=white foreground=black }; run; ods layout end; TIA.. J ... View more

EG 4.1 imports a MS Access table which has invalid column names, as an example 2009 subs total Total # Of Subs .... etc.... I look at the generated code by sas and it creates  _T_ value to process the observations, and creates the SAS Dataset. The strange thing is that SAS outputs the dataset with non-standard variable names, which causes me the problem. I would have thought SAS would have kept the _T_ or someting like that... I want to re-name all the variables to someting like: Rename 2009 subs total = Y2009_Subs_Total; But SAS looks at the 2009 as a numeric not as a variable name... Any ideas on how I can take a variable named 2009 subs total and rename it to Y2009_Subs_Total? TIA, Jay ... View more

We have small look up table, with some dates and completion factors, about 10 rows in total... We are looking to have users in a specific UNIX group, who have write access to the SAS Datasets, open the Dataset in EG and update a completion factor through EG. They can do it by code via EG but they are asking to just bring up the dataset in (edit / write mode) when they view the dataset in project designer. Is there a setting in EG that lets the user open up the dataset in edit mode when they have update access via UNIX? TIA.. ... View more

We have a bunch of EG SAS jobs that write out *.csv files, no problem there. We are now looking to write the output into an existing blank (template) *.xls sheets. The xls sheet has a lot of formula's within it, we can not seem to write the data into a cell and retain the formula. Any ideas? SAS Enterprise Guide 4.1 (4.1.0.1019) AIX UNIX TIA Jay ... View more

We have a job that reads in an MS Access table with a variable named 1Quarter. Not having any luck renaming the variable to a SAS compliant name. Any ideas? Our last option would be to go back into MS Access and rename it before the import, just want to check to see if there is another way to rename. TIA J ... View more

I have a request to build a SAS Macro that fires off a SAS Program every day, in 10 minute intervals. I am aware of the &SysDate, &SysDay and &SysTime variables and figure they will be used to calcuate the Day and Time (Not sure I need to worry about the &SysDate), but do not have much experience with SAS Macro's and %Do loops. I know I'll need to add 10 minutes to the &SysTime variable and basically hold until the system clock and the &SysTime+10Min = the SystemTime. I'm working on this now, but any insight or code would be helpfull. Job will be running on UNIX and I am coding in SAS EG. TIA, Jay ... View more