I found the proc template code that allows this to work. Note however that the macro source needs to be updated to replace:   ods html text = '        ';   with   ods tagsets.html4 text = '       ';   That is the only needed change.   Here is the proc template code that I got to work. Note that I freely acknowledge that I am not at all at expert in PROC TEMPLATE. This code was originally provided to me by Tech Support for a related issue. And I was able to tweak it for this example.   ods path work.tmplmst(update) sashelp.tmplmst(read); proc template; edit tagsets.html4; define event text; start: trigger rowcol; trigger cell_value; finish: trigger cell_value; end; end; run; ... View more

If Twitter still had the old XML service running then the code should continue to work, however, this program does indeed depend on there being an XML Map file created, which was not included in the appendix, you can attempt to contact the paper's author.  Alternatively you could build your own map using the tool from SAS. ... View more

The SAS code is running on the Unix server, so the FILENAME must reference a directory on the Unix server. If the file name is known on the PC (EGuide) side, but not on the Unix side, then the disk will not be seen by Unix and it might hang (as Tom described).  Just being able to navigate to it with 'my computer' is not sufficient to tell if it is known to the Unix server. You probably need to check with your local tech support people. ... View more

try this google search vehicle vin site:sas.com ... View more

Since I work for multiple clients, I don't have a single standard. I try to minimize what it does and typically limit it to defining librefs, filenames, updating the fmtsearch or sasautos option. It looks like you are trying to define macros. If so, I would use the SAS autocall facility to define the path to my macros. And I would use the insert or append options so as to make sure to not remove anything defined in the autoexec for the stored process server itself. Here is a link that talks about the insert and append options: http://www.sascommunity.org/wiki/Dynamically_Insert_and_Append_SAS_Format_and_Macro_Libraries_within_a_SAS_Program ... View more

Hi, Angela what you have given is helpful but i dont think it would work in my scenario. Graham, Your idea of executing the process again will work but i wish to refrain from doing that. A sample code that i was aiming at is as below. in my Stored process i have closed the auto generated stored process macros. *HTML PART START; ods html body=_webout; proc print data=sashelp.class; run; ods html close; *HTML PART END; *CSV PART START; data _null_;    /* Set HTTP headers */     rc = stpsrv_header('Content-type','application/vnd.ms-excel');      /* Prompt to SAVE or OPEN the attachment file named test.xls using Excel */     rc = stpsrv_header('Content-disposition','attachment; filename=test.csv');    run;     data _null_;   file _WEBOUT;     do UNTIL (EOF);     set sashelp.class end=eof;   put @01 name $12.         @17 sex $11.            ;   END;   run; *CSV PART END; ... View more

Hi Folks, I am building row level security model and column level security model, if anyone can suggests me the correct syntax.! Rajesh U ... View more

Message was edited by: LAP Message was edited by: LAP ... View more

You may have to restart the Java Application Server in order for the change to be picked up. See also this new usage note: Usage Note 40210: How to customize the Welcome page for the SAS Stored Process Web Application http://support.sas.com/kb/40/210.html Vince DelGobbo SAS R&D ... View more

I seem to be getting a better result with 28 in my var declaration. I'm brand new to proc statespace, so if you see anything below that is a SAS no-no please let me know. This code sets up the variables I'm using to forecast out the coming 14 days. PROC STATESPACE DATA=TEST1 OUT=TEST2 LEAD=14; VAR LOG(1,28); ID OBS; RUN; ... View more

interesting job. i guess the it is doable with SAS. you will need to explore how to control font and size on an output (e.g. ods rtf), then code the frequency of words and parse to the font and size macro variables. following references are for controling font and size on ods rtf output: http://support.sas.com/rnd/base/ods/templateFAQ/Template_rtf.html http://www.lexjansen.com/pharmasug/2004/HandsOnWorkshops/HW04.pdf ... View more