Update Something like this.... ( a lot of HTML cut do to inclusion of Outlook Form ) data _null_; file outbox      to = ('x@x.com')        from = ("x <x@x.com>")        sender = ("x <x@.com>")      subject = 'TESTING: xxxxxxx'      attach  = "some local location of an attachment…..."      OutlookForm = ‘IsThisPossible’ (Want to display this pre-built Outlook Form)      ; run Possible? J ... View more

If B: is mapped to "abcdefghij on 'Shared File Server (AAAAA-bbb-999)" Then from the PC you should be able to refer to it as \\AAAAA-bbb-999\abcdefhij\ instead of B:\. But from you Unix server there is probably a mount point that would make this visable from the Unix processes.  They might have mounted as something like /net/AAAAA-bbb-999/abcdefghij/ , but you need to check with the Unix admin to see exactly how to find the same data. ... 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

For SAS/EG system option validvarname= is set 'any' by default. You should set it back at the first of your code . validvarname=v7. Ksharp ... View more

Yes. In the menu of EG ,there is a item DATA, cancel the hook before it. ... View more

I would look into proc template and ods tagsets to create an html document for excel to read. http://support.sas.com/rnd/base/ods/excel/index.html ... View more

I had similar problems a few years ago when I was having SAS "talk to" Access a lot. In addition to options validvarname=any that Ksharp mentioned, you will probably need to use name literals (I think that's what their official name is), e.g. "1Quarter"n (note the n following the quote to indicate it is a name, not a string). Try something like options validvarname=any; data new;      set old;      rename "1Quarter"n = Quarter1; run; ... View more

Not sure whether it could work. %do %until(count gt 100);* execute  code for one hundred; ....................... count+1; %include 'c:\report.sas'; call sleep(60,10); /*sleep for 10 minutes */ ............ %end; Ksharp ... View more

Hi: We do this all the time (on z/OS mainframe) First, set the date as in: (the date passed to DB2 needs the double quotes):      CALL SYMPUT('INT_DATE',"'"||PUT(sas_date,YYMMDDD10.)||"'"); Then use in the SQL as in: PROC SQL ; CREATE TABLE DB2Table AS SELECT * FROM CONNECTION TO DB2 (SELECT Var1,                              Var2,                            ...etc...                    FROM    Table            WHERE   Table_Date >= &INT_DATE ); quit; run; ... View more

A user written INFORMAT should do nicely. proc format;    invalue smokes(just)       0=0       1,.=1       other=_error_;    run; data test;    input smokes smokes1. @1 orig $char8.;    cards; . 1 . 2 0 1 ;;;;    run; proc print;    run; ... View more