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

cm2 — Mon, 19 Jun 2017 16:47:34 GMT

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

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

Reeza — Mon, 19 Jun 2017 16:52:57 GMT

File SAVE AS

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

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

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

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