How to convert .xls file into CSV format?
- 6 Answers
- 21285 Views
- Quintiles, I also Faced
- E-Mail Answers
Answer Posted / manjunath wadi
It is very simple.
1. Click on "FILE" menu of the MS Excel file
2. Select "Save As" Option and click on that
3. Now you can see a dialog box "Save As", type the file
name select location to save
4. Select the option CSV(comma delimited)option from Save as
Type drop down box and click Save button.
Its Done!
Note: Only active worksheet can be saved if you are saving
your file in CSV format
| Is This Answer Correct ? | 16 Yes | 5 No |
Post New Answer View All Answers
How to specify variables to be processed by the freq procedure?
What are the default statistics for means procedure?
How would you identify a macro variable?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
For what purpose would you use the RETAIN statement?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
Mention sas system options to debug sas macros.
why a stop statement is needed for the point= option on a set statement?
Difference between informat and format?
How would you invoke a macro? : sas-macro
name several ways to achieve efficiency in your program? : Sas programming
How do you add a number to a macro variable? : sas-macro
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Explain what Proc glm does?
