Hi folks,   I'm trying to find age of customer by using a column which has Julian date as the date of birth.   Below is my input,   customer_dob = 92138 changed_dt = 17-05-1992   dob = intck('year',today,changed_dt);   I want to know a way to get the changed_dt in the above format stored as a numeric.   any thoughts?? ... View more

Hi,   I have scenario where I need to export multiple datasets to  a Excelsheet into different tabs.   Ex: I have three datasets A,B,C and i want to export into an excel workbook "Output" under sheets x,y,z correspondingly,   A ---> X B ---> Y C ---> Z     %macro Export(ouput1=,input1=,ouput2=,input2=,ouput3=,input3=); ods excel file="/External/Output.xlsx" options (sheet_name = "&input1.") style=statistical; Proc report data= &output1. style(header)=[background=LightGray]; columns col1 col2 col3; define col1 /display ; define col2 /display ; define col3 /display ; run; ods excel options(sheet_name = "&input2"); proc report data= output2. style(header)=[background=LightGray]; columns col1 col2 col3; define col1 /display ; define col2 /display ; define col3 /display ; run; ods excel options(sheet_name = "&input3"); proc report data= output3. style(header)=[background=LightGray]; columns col1 col2 col3; define col1 /display ; define col2 /display ; define col3 /display ; run; %mend Export;   %Export(ouput1=A, input1=X, ouput2=B, input2=Y, ouput=C, input3=Z);   Out of my 3 input datasets, lets take B is an empty dataset but I wanted that corresponding sheet Y to be created as a blank one in my output excel file. Because the dataset B can be empty or have values based on that particular run on a given day.   Suggestions are highly appreciated!!   Thanks in advance, Vigneswar ... View more

Hi,   Here is the scenario,   I am trying to create a macro code that produces xml file for different businesses that will have multiple sheets.   Example,   Business : Snacks, Diary, Choco and each business has multiple sub cat that comes in the sheets of the xml file.   When I execute the macro, the output should be three different xml files for each business (Snacks.xml, Diary.xml, Choco.xml) and with the sub cat in their respective sheets.   Below is the code I created, ----------------------------------------------------------------------------------------------------------------------------------------------- %MACRO TABLES(INPUT=, OUTPUT1= , OUTPUT2= ,OUTPUT3= ,COND1= , c1= ); %Local INPUT OUTPUT1 output2 COND c1 c2; PROC SQL NOPRINT; CREATE TABLE &OUTPUT1. AS SELECT * FROM &INPUT. WHERE &c1="&COND1."; QUIT; proc sql noprint; CREATE TABLE &OUTPUT2. AS SELECT * FROM &OUTPUT1. WHERE country in ('India'); QUIT; proc sql noprint; CREATE TABLE &OUTPUT3. AS SELECT * FROM &OUTPUT1. WHERE country in ('USA'); QUIT; %MEND TABLES;   %macro Export(output1=, input1=, output2=, input2=, output3=, input3=); ods tagsets.ExcelXP file="/sasconfig/Lev1/External/&file..xml" style=meadow options (sheet_name = "&input1."); ods results on; proc report data= &output1. style(header)=[background=LightGray font_weight=Bold borderwidth=1] ; columns a b c d e; define a /display ; define b /display ; define c /display; define d /display; define e /display; run;   ods tagsets.Excelxp options(sheet_name = "&input2."); proc report data= &output2. style(header)=[background=LightGray font_weight=Bold borderwidth=1] ; columns a b c d e; define a /display ; define b /display ; define c /display; define d /display; define e /display; run;   ods tagsets.Excelxp options(sheet_name = "&input3."); proc report data= &output3. style(header)=[background=LightGray font_weight=Bold borderwidth=1] ; columns a b c d e; define a /display ; define b /display ; define c /display; define d /display; define e /display; run; . . . . ods _all_ close; %mend Export;     %Export(output1=Snacks_A,output2=Snacks_B, output3=Snacks_C, input1=India, input2=USA, input3=Australia);   %Export(output1=Choco_A,output2=Choco_B, output3=Choco_C, input1=India, input2=USA, input3=Australia); --------------------------------------------------------------------------------------------------------------------------------- Here I am using multiple proc reports for exporting multiple sheets into single business file.  The sheets for different businesses varies and max of 6 sheets (country).   I am trying to modify the code with a single proc report.  Any suggestions are highly appreciated!     Thanks in advance!!! Vigneswar     ... View more