I want to read a POLICY Description from a dataset into a macro variable and then print it into an RTF file using ODS TEXT , formatted with Times New Roman and 11pt font size. Code I Tried proc sql noprint; select POLICY into :POLICY from sample_data; quit; ods text="^S={font_face='Times New Roman' font_size=11pt just=left} &POLICY"; The code runs but I don't see the correct formatting or output in the RTF file. Am I missing something in the ODS RTF setup? PFA Climate Change.docx is i want output ... View more

I am currently working on a SAS Visual Analytics dashboard and would like to provide users with the ability to download the underlying data shown in a chart (like bar, line, or pie charts) directly from the report interface.   Is there a built-in option in SAS Visual Analytics (SAS Viya) to enable a download or export feature (e.g., to CSV, Excel, etc.) from charts or report objects? Any step-by-step guidance or examples would be really helpful. Thanks in advance ... View more

I’m using PROC TABULATE in SAS to create a table with nested row headers (e.g., sec_sr_no='Sr. No.', SECTOR_NAME='Sector', subsec_sr_no='Sr. No.', SUB_SECTOR_NAME='Sub-Sector') and a summarized variable (Ext_tot_Outlay with SUM). My current code is:   PROC TABULATE DATA=dataset FORMAT=COMMA12.; CLASS sec_sr_no SECTOR_NAME subsec_sr_no SUB_SECTOR_NAME; VAR Ext_tot_Outlay; TABLE sec_sr_no='Sr. No.' * SECTOR_NAME='Sector' * subsec_sr_no='Sr. No.' * SUB_SECTOR_NAME='Sub-Sector', Ext_tot_Outlay='Annual' * SUM='Exp'; RUN; I’d like the headers (Sr. No., Sector, Sr. No., Sub-Sector) to "shift up" in the output   i want  Is there an option in PROC TABULATE to adjust the vertical placement or spacing of row headers? If not, what’s the best alternative (e.g., PROC REPORT) to achieve this customization? Thank you! ... View more

I have been assigned some tasks, including adding new users. However, I have limited knowledge about SAS Viya administration. Could someone please provide me with a step-by-step process for creating a new user? ... View more

proc export data=sashelp.class outfile="TEST1" dbms = xlsx replace; run; proc export data=sashelp.class outfile="TEST1" dbms=xlsx replace; run; I'm trying to append an existing file using Proc export, but it didn't work. i want this ouput   ... View more

I have a custom proc template for the table frame to be border lines, but it did not work properly. I want the table to have border lines.   proc template; define style styles.mystyle1; parent = Styles.Default; style body / /* background = white*/ foreground = black ; style systemtitle / font_face = 'DVOT-SurekhMR' font_weight = bold background = white font_size = 12pt ; style systemfooter / font_face = 'DVOT-SurekhMR' font_size = 8pt ; style data / fontfamily = 'DVOT-SurekhMR' font_size = 10pt foreground = black /* borderwidth = 1px */ /* bordercolor = black*/ JUST=CENTER VJUST=C ; style header / fontfamily = 'DVOT-SurekhMR' font_size = 10pt foreground = Black font_weight = bold /* background = #A9D0F5 */ /* background = white*/ ; style summary / fontfamily = 'DVOT-SurekhMR' font_size = 10pt foreground = Black font_weight = bold /* background = #A9D0F5 */ background = white ; style table / cellpadding = 5px cellspacing = 0px borderwidth = 1px bordercolor = black borderstyle = solid font_weight = bold ; end; run; Output i want    ... View more

How to create a tabulated report based on data: Column CATEGORY in H means a horizontal report. TITLE_LEVELS indicate how many levels of title there are. TITLE_LEVEL1 is the main header, TITLE_LEVEL2 is the sub-header of TITLE_LEVEL1, and TITLE_LEVEL3 is the sub-header of TITLE_LEVEL2. All columns are Character data type proc tabulate data=datset; class TITLE_LEVEL1 TITLE_LEVEL2 TITLE_LEVEL3 Column1 ; table TITLE_LEVEL1* TITLE_LEVEL2*TITLE_LEVEL3; run; i have data i want  PFA ... View more