jrn9's articles:

Items(4) /1

Appsrv_Header xml output will not open in excel 0 34 (11/2/2011 7:58:01 PM) comp.soft-sys.sas Can anyone tell why my xml output will not open in ms excel? Is there something I am missing from my code? %else %if &r2=EXCEL and &r1 ^= DETAIL %then %do; %LET RV=%SYSFUNC(APPSRV_HEADER(CONTENT-TYPE, APP... JGE023

export xml but not titles 1 24 (11/2/2011 7:44:57 PM) comp.soft-sys.sas Can anyone tell why I am not getting my titles on my xml output? When I print preview I see part of my titles. Why is that? ODS LISTING CLOSE; ODS NOPROCTITLE; OPTIONS ORIENTATION=LANDSCAPE; ODS tagsets.excel... JGE023

macro weekday 3 12 (9/21/2011 9:35:19 PM) comp.soft-sys.sas I worte this code in data step which worked fine but I am getting a error when I put it in a macro. Any suggestions? %Macro LastFriday; * go back past 7 days to find last Friday date; %do I = 1 %to 7; Fridat... JGE023

Lookup table from excel spreadsheet 1 339 (6/17/2010 6:26:46 PM) comp.soft-sys.sas How can I use an Excel spreadsheet instead of my proc format? I would like the user to make update to table adding accpet codes if needed. example of excel sheet called MDD: fmtname type value label MDD... JGE023

jrn9's replies:

Items(1) /1

macro weekday 3 12 (9/21/2011 9:35:19 PM) comp.soft-sys.sas I worte this code in data step which worked fine but I am getting a error when I put it in a macro. Any suggestions? %Macro LastFriday; * go back past 7 days to find last Friday date; %do I = 1 %to 7; Fridat... jrn9 (5)