How to convert .xls file into CSV format?
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
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
what is data governance? : Sas-di
How would you identify a macro variable? : sas-macro
Which are the statements whose placement in the data step is critical?
how to debug and test the sas program? : Sas-administrator
Can you execute a macro within a macro? Describe. : sas-macro
What are the statements that are executed only?
Explain proc sort?
Mention what are the data types does SAS contain?
What is the role of unrestrictive users? : sas-grid-administration
How to limit decimal places for the variable using proc means?
what is sas data set?
Difference between nodup and nodupkey options?
how does sas handle missing values in functions? : Sas programming
What can be the size of largest dataset in SAS?