how to export multiple datasets into multiple worksheets in single file using dde

[Ravikumarkummari]

i have one doubt in this the variable "new" is which format character or numeric. is it belongs to numeric then not a problem.

if it is character then there is a problem. client need this also into numeric format.

[Ravikumarkummari]

just now i checked  the variable new is in character type. so it is not possible. the resultant dataset is also is in numeric format.

[Ravikumarkummari]

can you give me the syntax of call define for comma and percent format.

[Ksharp]

I think Cythina@sas has already answer your question , Check her code in your post .