How do I read in the comma delimited files by SAS

5 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Sarathannapareddy
    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
    20 pointsBadges:
    report
  • Sarathannapareddy
    http://studysas.blogspot.com/2009/02/how-to-create-comma-separated-file-csv.html
    20 pointsBadges:
    report
  • Jes
    how to copy the text file which has been modified today conditional based using sas
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following