Comma separated not loaded in target

Reply
Frequent Contributor
Posts: 101

Comma separated not loaded in target

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

Respected Advisor
Posts: 4,173

Re: Comma separated not loaded in target

Posted in reply to Helannivas

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.

Ask a Question
Discussion stats
  • 1 reply
  • 188 views
  • 0 likes
  • 2 in conversation