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
do you prefer proc report or proc tabulate? Why? : Sas programming
what are several options for creating reports in web report studio? : Sas-bi
Describe the function and untility of the most difficult SAS macro that you have written.
what is change analysis in sas di ? : Sas-di
What is PDV?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
Explain the purpose of retain statement.
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
What is substr function?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
How do you add a number to a macro variable? : sas-macro
Are you sensitive to code walk-throughs peer review or QC review?
How we can call macros with in data step? : sas-macro
for report generation which one you used proc report or data_null_?
What is maximum storage capability of SAS?