How to import HTML files which are saved in Excel files bu using sas?

[Cynthia_sas]

Hi:
I really don't know what you mean by "sas integrator". Perhaps you mean SAS Integration Technologies? You are better off searching support.sas.com and the documentation for examples at support.sas.com.

For example, here are some Tech Support notes and documentation links which may be of interest to you (which were found by using the SEARCH engine on support.sas.com and searching on phrases like Integration Technologies web services .NET .COM etc):
http://www.mysas.net/fI8Bx1pMa5/inttech/library/index.html
http://support.sas.com/documentation/onlinedoc/inttech/
http://support.sas.com/rnd/itech/doc9/dev_guide/websrvcs/using.html
http://support.sas.com/rnd/itech/doc9/dev_guide/websrvcs/index.html
http://support.sas.com/rnd/itech/doc9/dev_guide/websrvcs/decide.html
http://support.sas.com/rnd/itech/doc9/dev_guide/websrvcs/program.html
http://support.sas.com/rnd/itech/updates/912/portal_dev.pdf
http://www.eclipse.org/community/casestudies/SASfinal.pdf
http://www.sas.com/technologies/bi/query_reporting/guide/customtasks.html
http://support.sas.com/kb/7/568.html
http://support.sas.com/kb/7/770.html
http://support.sas.com/kb/7/567.html
http://support.sas.com/kb/25/286.html
http://support.sas.com/kb/25/272.html
http://support.sas.com/documentation/tools/oledb/index.htm
http://www2.sas.com/proceedings/sugi31/231-31.pdf
http://www2.sas.com/proceedings/sugi29/037-29.pdf
http://support.sas.com/rnd/appdev/V30/doc/sugi29p24-29.pdf

If you don't feel entirely comfortable searching support.sas.com, a Google search can also net you many SAS Global Forum papers on SAS topics like this or basic overviews of SAS functionaliry. You could also search the books by users at the SAS publication site, where you might find this link to a book by Dr. Pratter about Web Development that includes a discussion of Integration Technologies.
http://www.sas.com/apps/pubscat/bookdetails.jsp?catid=1&pc=59836

At any rate, there is a wealth of information and examples already available at the support.sas.com web site and if you have specific coding or installation or configuration issues, then SAS Tech Support can help you resolve those problems.

cynthia

[deleted_user]

hi synthia,

thanka a lot for providing valuable information.Yeas sas integrator means integrating sas with other softwares like java.dot net etc

[mikersas]

I have  some tables in html.

How do I save them as EXCEL spreadsheets with formatting?

[Cynthia_sas]

Yes, this is all separate client-server software. I do not think the BI platform will work with SAS 8. It was first introduced with SAS 9.

If you go to www.sas.com and investigate some of these links:
http://www.sas.com/technologies/bi/
http://www.sas.com/technologies/bi/entbiserver/index.html
http://www.sas.com/resources/factsheet/sas-enterprise-bi-server-factsheet.pdf

it may give you a better idea about enterprise-level software of this magnitude.

cynthia

[deleted_user]

oh thanks a lot.

kumar

[LinusH]

That is a part of SAS BI Server package. You need to install SAS components with your MS Office client installation. It means that you can use Excel as a client to connect to SAS via Intelligent Architecture Servers. You can access data directly or running Stored Processes, among other thing. See www.sas.com and support.sas.com for more extensive information about this topic.

/Linus

[LAP]

Just a comment.. may be stating the obvious to seasoned users but to new users licensing issues may be a bit confusing.

I believe that Proc Import would only be an alternative if your site licenses SAS/ACCESS for PC files. Our site does not and therefore we typically use the libname options

[LinusH]

Funny, I was pretty sure that the LIBNAME EXCEL engine also required SAS/ACCESS to PC Files, since it's documented in the SAS/ACCESS documentation.

/Linus

[Cynthia_sas]

Hi:
I believe you're correct about needing SAS/Access for the Libname Engine too. But I think it's a moot point, because it's never been determined whether the original ODS HTML file is -resaved- in Excel format or not. If the file is an HTML file that's being OPENED in Excel, but not RESAVED in Excel format, then neither PROC IMPORT nor the LIBNAME Excel engine would read it accurately.

Those 2 methods ONLY read Excel proprietary format files. HTML is not an Excel format file -- it is an ASCII text file with HTML tags delimiting the data.

cynthia

[deleted_user]

Hi synthia,

finally i need i calarification

By using proc import is it possible to import HTML format which is saved in excel file or not.......if yes plz explain with small example.........if not please specify the other method to import with example.


Kumar

[LinusH]

Ok, let's sum it up.

Your options is:

1) open your HTML-file in Excel, and re-save it in Excel workbook format (.xls). Then read it into using either PROC IMPORT or LIBNAME EXCEL.

2) Generate as SAS table directly in your PROC MEANS using the OUT= statement or ODS OUTPUT.

3) Use data step programming to read the HTML directly. Not recommended!

When it comes to examples support.sas.com is full of examples/samples if you care to search.

/Linus

[deleted_user]

hi linus,

thanks for ur information....i will do that........if i dont get i will search for examples.

[deleted_user]

Hi Linus,
this is my code

ods html body= "D:\RC_To Check\NY\NY_Avg\NY_dates.XLS";
proc means data=NY_123_DriverClass_HLTV;
class mkt_name New_Business_Effective_Date;
var annual_premium ;
run;
ods html close;

after this, again i want to convert this NY_dates file to sas by using proc import ..
but am getting some errors...and the sas version using is sas 8

kumar

[LinusH]

Again, why do you want to import your HTML-file? It makes no sense. Use OUT= in PROC MEANS instead.

/Linus

[deleted_user]

Won't a simple copy and paste from Excel into the Editor window work?