Dear friends I have the following request. I have an excel file that conatins monthly outputs in same sheet (output from Jan2017 until Nov2017) This file was creates manually by copy and paste SAS output from input excel file that I receive every month. The challenge now is to perform automatics process that includes following steps: Import monthly excel raw data into SAS Create analysis on this file with summary statistics output Import  into  SAS the cumulative output excel file that contains information from JAN2017 until Previous month  Add the new summary statistics information to  cumulative output excel file Export  the updated  cumulative output  to excel file    I will explain it now in more details: Step1- Every month I will receive an excel file(let’s call it input file) with data on it. I need to import the excel file into sas data set and perform calculations in order to get output file. This output file information includes for example 1 column. Let’s say that the last month of analysis was DEC2017 Step2- There is existing cumulative periods excel file that includes ouputs from Jan2017 until  NOV2017 I need to import this file and add a column with results of  DEC2017 Step3- Export  the updated cumulative periods excel file that includes now months JAN2017-DEC2017   May someone send an easy example  code  how to do it ... View more

Hello This code export 5 tables to one excel sheet and put them as a panel (3 side by side and then 2 side by side). I want to adjust the code to export 3 tables to "sheet1"  that will be side by side and 2 tables to "sheet2" that will be side by side     /*Create panel of tables in one excel file and one sheet*/ ods tagsets.msoffice2k_x file="/usr/local/SAS/MidulOld/UserDir/Ron.xls" options(panelcols="3") style=normal; proc print data=sashelp.prdsale(obs=3); var actual predict country region; where country="CANADA"; title "Canada Sales"; run; proc print data=sashelp.prdsale(obs=3); var actual predict country region; where country="U.S.A."; title "USA Sales"; run; proc print data=sashelp.prdsale(obs=3); var actual predict country region; where country="GERMANY"; title "Germany Sales"; run; ods tagsets.msoffice2k_x options(panelcols="2") ; proc print data=sashelp.prdsale(obs=3); where region="EAST"; title "East Sales"; run; proc print data=sashelp.prdsale(obs=3); where region="WEST"; title "West Sales"; run; ods tagsets.msoffice2k_x close; ... View more

Hello friends, I have 5 SAS tables. I want to export them to one excel file as following: Tables Pop1 ,Pop2,Pop3  to have in sheet1 (side by side to each other) Tables Ref1  ,Ref2 to have in sheet2 (side by side to each other) Please mention that I want all tables to be in one excel file (with two sheets as I explained before)         Data pop1; input x; cards; 1 2 ; Run; Data pop2; input x; cards; 3 4 ; Run; Data pop3; input x; cards; 5 6 ; Run; Data Ref1; input w; cards; 10 20 ; Run; Data Ref2; input x; cards; 30 40 ; Run;   %macro mmacro1; %do k=1 %to 3; Title "pop&k."; proc print data=pop&k. noobs; footnote; Run; %end; %mend; %mmacro1; %macro mmacro2; %do k=1 %to 2; Title "Ref&k."; proc print data=Ref&k. noobs; footnote; Run; %end; %mend; %mmacro2; ... View more

Hello Can someone tell me how to export multiple SAS outputs to one excel file and one sheet. I want that the outputs will be  side by side in one excel sheet.   thanks You   ... View more

Hello I want to print 3 tables  side by side in one excel sheet. When I run my code 3 different excel sheets are created but I want to have only one sheet.     ods path work.temptemp(update) sasuser.templat(update) sashelp.tmplmst(read); ods path show; ods tagsets.excelxp file="/usr/local/SAS/MidulOld/UserDir/Example.xls" style=htmlblue;   ods tagsets.excelxp options(embedded_titles='yes' sheet_interval='none' sheet_name='tables' absolute_column_width="12,13"); Title; proc print data=a1 noobs label; Run; Data a1; input x y; cards; 1 10 2 20 3 30 ; Run; ods tagsets.excelxp options(embedded_titles='yes' sheet_interval='none' sheet_name='tables' absolute_column_width="12,13"); Title; proc print data=a1 noobs label; Run; Data a2; input x y; cards; 4 10 5 20 6 30 ; Run; ods tagsets.excelxp options(embedded_titles='yes' sheet_interval='none' sheet_name='tables' absolute_column_width="12,13"); Title; proc print data=a1 noobs label; Run; Data a3; input x y; cards; 7 10 8 20 9 30 ; Run;       ... View more