1) Start your own thread. As the creator of the thread you can then indicate a correct solution to your particular problem for others to find on the forum.
2) Reference this (or the other dozen or so related threads)
3) Provide code of how you create the CSV file, or at least very clearly describe how.
4) Provide example data, best in the form of working data step that replicates your issue.
5) Clearly describe what you expect as the result in the target CSV file.
And in very serious note, never trust what a spreadsheet displays when opening a CSV file. Depending on the particular software and values intended values can change types. And if you allow the spreadsheet software to save the csv file may permanently change the actual values.
... View more