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
Which function is used to count the number of intervals between two sas dates?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
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
How can you create a macro variable with in data step? : sas-macro
what are the scrubbing procedures in sas? : Sas programming
what is ae onset date n what is RDS
What is the function of output statement in a SAS Program?
Explain translate function?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
Are you sensitive to code walk-throughs peer review or QC review?
explain what is factor analysis? : Sas-administrator
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
what is sas metadata repository? : Sas-bi
how many types prompting framework can be broken down to? : Sas-bi
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com