Comma separated not loaded in target

[Helannivas]

Hi,

While loading the data from Text file to Excel file through SAS Data  Integration Studio, the numeric fields with comma separated are not loaded with comma's in the Excel(Target)..

Is there any specific format function need to be applied like comma.s,etc..??

Thanks in Advance

[Patrick]

It's certainly possible to do what you're trying to do but in order to give you some reasonable advice you need to explain much better what you're currently doing and where exactly it's not working (when reading the source or when writing to the target).

You should tell us your DI and SAS version, the OS and any errors and warnings you get in the log. Ideally post a picture of your flow and attache a .spk - or post an attachment with the code generated and another one with the log.