If using "send to", i'm able to "send to excel" but how about export or export as a step in project? ... View more

I have two set of data which are policy (table 1) and claim (table 2) data. Multiple claims have been subtotal by policy no. I have merged these data by policy no. level yet there are blank cell in between when I pull only policy no. from table 1 and vice versa. How do I merge policy no. from table 1 and table 2 into one column other than doing formulae by adding new column? ... View more

I am having a problem of date output format when sending my list report to excel, the date format originally set in SAS EG has changed from DD/MM/YYYY to mixure of DD/MM/YYYY and MM/DD/YYYY. Any solution for this? ... View more