BookmarkSubscribeRSS Feed
Helannivas
Quartz | Level 8

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

1 REPLY 1
Patrick
Opal | Level 21

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 826 views
  • 0 likes
  • 2 in conversation