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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.