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 |
File SAVE AS
Pipe delimited is not CSV, it's a txt file.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.