Answer Posted / chandrakanth
change the html file to excel file. let us say if the filename is first.html right click on the file and select rename and type first.xls. Now the file becomes excel and you can import wizard or Proc import
Right now I can think of this solution, there may be another easy one.
Let me know if you have any questions
| Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
What is the use of function Proc summary?
what is sas business intelligence? : Sas-bi
how do you pull data from equifax?tell me the process?
What is the difference between one to one merge and match merge? Give an example.
what is sas application server? : Sas-di
what are some good sas programming practices for processing very large data sets? : Sas programming
how can you put a "trace" in your program? : Sas programming
describe about physical data integration? : Sas-di
How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
what is sas metadata server? : Sas-di
Mention some common errors that are usually committed in sas programming.
what is the purpose of _error_? : Sas programming
What is the differnce between SDTM 3.1.2 to 3.1.1 version