|
|
#1
21st Nov 2008, 13:00
|
|||
|
|||
|
How do I save an Excel File with 2 sheets into a two comma delimited (.csv) files, first for the sheet "sheet 1" and second for the sheet "sheet 2"?
Please provide thorough steps, so if I can follow them, easy ten points. Thank you. Also, how do I then read in the comma delimited files by SAS? |
|
#2
21st Nov 2008, 13:08
|
||||||||||||
|
||||||||||||
|
SAS?
__________________
My System: Hybr!d
|
|
#3
24th Nov 2008, 04:19
|
|||
|
|||
|
Click on each sheet in turn.
click on file>save as and select the type of file what could be easier? this works in almost every windows application incidentally, apart from a few that use file> export to do the same thing. reading a csv in excel and most other programs? just open the file l! but you may have to select "all files" under file type in the file open dialogue box. Some programs use file >import however. |
