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
Describe the ways in which you can create a macro variable?
Mention the difference between ceil and floor functions in sas?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
What is the command used to find missing values?
Differentiate input and infile.
Explain the purpose of retain statement.
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
How do you connect the desktop application to metadata server? : sas-grid-administration
what techniques and/or procs do you use for tables? : Sas programming
Differentiate between format and informat? : sas-grid-administration
why is sas considered self-documenting? : Sas programming
what is the difference between nodup and nodupkey options? : Sas programming
What are the prime responsibilities of data integration administrator? : Sas-di
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 are symget and symput? : sas-macro