06-19-2017 12:47 PM
I have an excel file that I need to read into SAS but my operating system in SAS 9.2 will not allow me to use PROC IMPORT. So I need to create an .csv file that is delimited by '|' and then convert the .csv file to SAS Does anyone know how to convert execl to pipe delimited .csv file? Thanks.
|Protocol Name||Country||Site Number||PI Name||Subject ID||Visit||Visit Date||Interview Start Time||Interview End Time||Rater||Notepad||1. Question 1?||If yes, describe If yes, describe:||2. Question 2?|
|D0000000||Brazil||200||Smith, John||000999999||Visit||23-Jun-2026||10:45:00 AM||Smith, John||Yes||Did not recall||Yes|