DATA Step, Macro, Functions and more

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

Reply
Occasional Contributor cm2
Occasional Contributor
Posts: 6

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

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 NameCountrySite NumberPI NameSubject IDVisit Visit DateInterview Start TimeInterview End TimeRater   Notepad1. Question 1?If yes, describe If yes, describe:2. Question 2?
D0000000Brazil200Smith, John000999999Visit23-Jun-202610:45:00 AM Smith, John YesDid not recallYes

 

 

Super User
Posts: 17,750

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

File SAVE AS

 

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

Ask a Question
Discussion stats
  • 1 reply
  • 77 views
  • 0 likes
  • 2 in conversation