Hi All,   I am trying to apply formatting to spanned header rows with the help of format but not able to do so and i am getting warning of Wrong type of format for data type.   The strange thing is that its working fine with SASHELP.class dataset but not working with my original data.   When i place only one dataset in tagset excelxp the things are working fine but my requirement is to have 22 reports in same excelsheet.   As sample code working fine and my required code not working , can you guide how can i move ahead.       ... View more

Hi All;   Below is the data i have.   data have; input idvar subj ; datalines; 1 101 2 102 3 103 4 105 5 106 6 107 7 111 8 112 ; I want to create new 4 variables as subj1 , subj2 ,subj3,subj4 containing two records each and new dataset contain only subj values not idvar values.   Can you please guide how can i keep it dynamic as next time  i do not need to check record count and new variable created automatically by sas program ? ... View more

Hi All,   I have data as below   data have; input subj $ 1-3 AE $5-15; datalines; X1 Fever X2 Fever X3 Cold X4 Cold X5 Chills X6 Nausea ; I need to transpose data as below.   Fever Cold Chills Nausea X1 X3 X5 X6 X2 X4               This seems to be simple one with Proc transpose but i am not getting any idea about by variable as same is not present.   Do suggest.   Regards, Rajesh ... View more

Hi All,   I am looking for borders around each cell in my ODS excel output.   Below is template style i am using from but could not get through.   proc template; define style styles.journal_borders; parent = styles.journal; style header from header/ font_weight = bold foreground = #CC99FF background=yellow ; style header_right from header / borderrightstyle=solid borderrightcolor=black borderrightwidth=2 ; style header_bottom_right from header_right / borderbottomstyle=solid borderbottomcolor=black borderbottomwidth=2 ; style header_thinbottom_right from header_right / borderbottomstyle=solid borderbottomcolor=black borderbottomwidth=1 ; style header_bottom from header / borderbottomstyle=solid borderbottomcolor=black borderbottomwidth=2 ; style data_bottom from data / borderbottomstyle=solid borderbottomcolor=black borderbottomwidth=1 ; style data_bottom_right from data_bottom / borderrightstyle=solid borderrightcolor=black borderrightwidth=2 ; end; run; Please guide.     ... View more

Hi All,   I have below sample data and i want to create report in .xml .But when i output the report blank spaces are not visible.   Below is the sample data, proc report code and screenshot attached. data new; input text $1 -20; datalines; 1000 Fever ; data new; set new; if _n_=2 then text=" "||text; run; ods Tagsets.ExcelXP style=sasweb file='\\C:Users\Desktop\Table.xml' options(orientation='landscape' sheet_name="Index" embedded_titles='yes' ); proc report data=new split='*' headskip spanrows spacing=0 nowd style(header)=[fontweight=bold ]; columns text ; define text /"Sample data" style(column)=[cellwidth=150 just=left]; run; ods Tagsets.ExcelXP close; ... View more