Home > IT Answers > Database > How do I read in the comma delimited files by SAS
Mimi111111
5 pts.
 How do I read in the comma delimited files by SAS
CSV, Delimited function, Microsoft Excel, SAS
How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed "sheet 1" and second for the sheet tabbed "sheet 2"? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read into the SAS program

Software/Hardware used:
ASKED: November 20, 2008  5:36 PM
UPDATED: February 9, 2010  2:17 PM
RELATED QUESTIONS
Answer Wiki:
As for the Excel part, saving each sheet as a different CSV file is the only option, because excel will just save the current sheet, so you need to go to the first sheet, go to files->save as and select the CSV format. Then you need to do the same with the second sheet. <b>About SAS, I don't know that program, so I hope someone else can provide help in that respect.</b><i></i>
Last Wiki Answer Submitted:  November 20, 2008  7:04 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

IN SAS programming, we often require outputting the dataset in different formats like EXCEL and CSV etc and here are the five different ways to export the SAS dataset into .csv file.

Example:
read more at….

http://studysas.blogspot.com/2009/02/how-to-create-comma-separated-file-csv.html

Sarathannapareddy
 20 pts.
 
Sarathannapareddy
 20 pts.
 

how to copy the text file which has been modified today conditional based using sas

Jes
 15 pts.