Hi,
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.
Excel file"
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 |