In the VIYA environment, JobExectution to be exact,  how do you add a macro variable to a filename statement?   This is what I have:   %let VA_school_year=2019-20; %let today='12/11/2019;   filename xmlfile filesrvc parenturi="&SYS_JES_JOB_URI" name='_webout.xml' contenttype='application/vnd.ms-excel' contentdisp='attachment; filename=&VA_school_year. MS Promo &today..xml';   ods tagsets.excelXP file=xmlfile options(sheet_name="Overall Schoolwide Progress" frozen_headers='1');   I have tried with double quotes like this:  ...fielname="&VA_school_year." MS Promo "&today.".xml'; ... I have tried with no quotes, single quotes, with period and without period. When the file is produced the macro value is not substituted for the macro variable.   Any suggestions? ... View more

I have grouped headers, and I need the header lines on line two (2) to show completely.  See attached excel file to see what I am talking about.  when I use row_heights='0,0,0,40', both rows 1 and 2 are enlarged rather than just row 2.     data coqui; set sashelp.cars; spacer=' '; run; ods excel file="\\t002pmid03\sasdata\cuevas\example_header.xlsx" <<< change to a location that will work for you  style=plateau options(frozen_headers='2' autofilter='1-4' orientation='landscape' row_repeat='1-2' embed_footnotes_once='On' absolute_column_width='16,16,36,5,5,5,5,5,5,5,5,5,5,5,5,5,5,1,5,5,5,5,5,5,5,5,5,5,5,5' sheet_name='ES PMA 1 - Projection'); proc report data=coqui misssing nowd split='~' spanrows style(header)={font_face=Calibri font_size=13pt just=c vjust=b tagattr='wraptext:no' background=white font_weight=bold borderwidth=2 bordercolor=black} style(column)={font_face=Calibri font_size=10pt just=c color=BLACK tagattr='wraptext:no' background=white borderwidth=1 bordercolor=black} ; columns ( ('SAS Help Cars Data' make model type origin driveTrain) ('SAS Help Cars Data Details' MSRP invoice engineSize cylinders horsepower MPG_city MPG_highway) (' ' spacer ) ('SAS Help Cars: More data' weight wheelbase length ) ); define make / display style(column)={just=l tagattr='wraptext:no' width=100%} 'Region Sup'; define model / display style(column)={just=l tagattr='wraptext:no' width=100%} 'Exec Dir'; define type / display style(column)={just=l tagattr='wraptext:no' width=100%} 'School'; define origin / display style(column)={just=c} style(header)={vjust=m background=#DDEBF7 tagattr='Format:@ rotate:90 wraptext:no' width=100%}'Title 1'; define driveTrain / display style(column)={just=c} style(header)={background=#C2A2EB tagattr='Format:@ rotate:90 wraptext:no' width=100%}'PMA 1 ELA Ach'; define MSRP / display style(column)={just=c} style(header)={background=#C2A2EB tagattr='Format:@ rotate:90 wraptext:no' width=100%}'PMA 1 ELA Gain'; define invoice / display style(column)={just=c} style(header)={background=#C2A2EB tagattr='Format:@ rotate:90 wraptext:no' width=100%}'PMA 1 ELA BQ'; define engineSize / display style(column)={just=c} style(header)={background=#ADDE7D tagattr='Format:@ rotate:90 wraptext:no' width=100%}'PMA 1 Math Ach'; define cylinders / display style(column)={just=c} style(header)={background=#ADDE7D tagattr='Format:@ rotate:90 wraptext:no' width=100%}'PMA 1 Math Gain'; define horsepower / display style(column)={just=c} style(header)={background=#ADDE7D tagattr='Format:@ rotate:90 wraptext:no' width=100%}'PMA 1 Math BQ'; define MPG_city / display style(column)={just=c} style(header)={background=#9BF0F4 tagattr='Format:@ rotate:90 wraptext:no' width=100%}'PMA 1 Science'; define MPG_highway / display style(column)={just=c} style(header)={background=#facff3 tagattr='Format:@ rotate:90 wraptext:no' width=100%}'PMA 1 Total Points Earned'; define spacer / display style(column)={background=white} style(header)={background=white tagattr='Format:@ rotate:90 wraptext:no' width=100%}' '; define weight / display style(column)={just=c} style(header)={background=#C2A2EB tagattr='Format:@ rotate:90 wraptext:no' width=100%}'2018-19 ELA Ach'; define wheelbase / display style(column)={just=c} style(header)={background=#C2A2EB tagattr='Format:@ rotate:90 wraptext:no' width=100%}'2018-19 ELA Gain'; define length / display style(column)={just=c} style(header)={background=#C2A2EB tagattr='Format:@ rotate:90 wraptext:no' width=100%}'2018-19 ELA BQ'; run;   ... View more

I have a stored process that is called from a VA stored process container. I have several radio buttons and dropdowns all working fine, but when I try to call a file, it will not render. I tried calling a second stored process that only contains the link to the file, but that did not work either. The message I keep getting is that the file does not exist. However when I cut and paste that file in the web browser, it will render.  I have tried using, what I thought would be the obvious answer:   %let stpname=/DCPS Departments/Quick Reports/Stored Processes/QR MS Scorecard sp;   %macro display_form; data _NULL_; file _webout; put "<html>"; put " <head>"; put " <style media='screen' type='text/css'>"; put " .border {border-width: 1px; border-style: solid;}";   put "<INPUT TYPE='HIDDEN' NAME='_program' VALUE='&stpname'>";   ---bunch of code here--- put " <input type='submit' value='Generate Excel File' class='generate_report' style='font-weight: bold; font-size: 20px'>"; stop; run; %mend; %macro main;   ---buch of code here--- %mend; %main; ... View more

I have a stored process that is called from a VA stored process container. I have several radio buttons and dropdowns all working fine, but when I try to insert a picture it will not render. If I call a second stored process and use ods PDF layout, then I can get the image to work on that ODS PDF, but I need the image to render in the current stored process. I have tried using, what I thought would be the obvious answer:   %macro display_form; data _NULL_; file _webout; put "<html>"; put " <head>"; put " <style media='screen' type='text/css'>"; put " .border {border-width: 1px; border-style: solid;}"; ---bunch of code here--- put "<img src='//severName/folder/image.png'/>";        <--- what I thought was the obvious answer stop; run; %mend; %macro main;   ---buch of code here--- %mend; %main; ... View more