Good day all, i want to export 3 datasets into 3 worksheets in singe file using dde. i have datasets like sashelp.class sashelp.cars sashelp.shoes no i want to export these 3 into single work book in different sheets through dde. your valid comments are welcome. ... View more

Hi all, can any one know the format for this i have the dataset like this product amount account value fixed 1,52,132 variable 2,50,478 annual rate product 4.5% variable 5.6% this over all is one dataset. i have read this data from excel using libname statement. and the variable amount is in character type. now i have to convert the data i.e. amount into numeric. can any one know the process please comment. ... View more

Good day all, i have the dataset of emp data. its having different formats for salary variable. comma and percent format. so i  apply proc format for that. PROC FORMAT; VALUE FMT   LOW-0,1-HIGH=[COMMA32.]   OTHER=[PERCENT8.1]   ; RUN; empno     salary aaa          1,52,133 bbb          2,50,111 aaa          25% bbb          50%. in proc report its showing as it is. but while exporting it into excel only percentages format is applying. the comma format is missing. after export into excel the output like this. empno      salary aaa     152133 bbb     250111 aaa     25% bbb     50% how to get the required output with applying comma and percentage format. your valid comments are helps me a lot. Thanks. ... View more

Good day all, I have two datasets. with different variable names. Now i want to export these two datasets into excel within single work sheet. without using set statement and merge and not combining the datasets. is there any method to using ods to export these datasets into excel within single work sheet. i.e. after completion of first dataset output then second dataset output is came. ... View more