Comma separated not loaded in target

Helannivas — Thu, 02 Jul 2015 21:04:34 GMT

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

Re: Comma separated not loaded in target

Patrick — Thu, 02 Jul 2015 21:57:40 GMT

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.

topic Comma separated not loaded in target in SAS Programming

Comma separated not loaded in target

Re: Comma separated not loaded in target