I am using proc export to export data into .csv file and facing some problem. In my data " is present.When I am exporting it using proc export , it is getting repeated 4 times and " becomes """". I have seen some solutions on this but unfortunately I need to fix this using proc export only. This happens only with " (unmatched double quotes). All other special characters like @,#,$ are exported correctly. I am using SAS 9.2 EG on Unix environment.
Can anyone helps me why proc export behaves like this and what is a solution for this?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.