How do I create a .csv file from excel to import in a SAS file?

[cm2]

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

[Reeza]

File SAVE AS

Pipe delimited is not CSV, it's a txt file.