aspose file tools*
The moose likes Java in General and the fly likes Conversion of resultset or collection into sas file format(*.sas7bdat) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Conversion of resultset or collection into sas file format(*.sas7bdat)" Watch "Conversion of resultset or collection into sas file format(*.sas7bdat)" New topic
Author

Conversion of resultset or collection into sas file format(*.sas7bdat)

harry ganguly
Greenhorn

Joined: Dec 14, 2010
Posts: 13
Hi,
I've to export resultset or collection which is taken from DB to sas file. extention is *.sas7bdat. Can you please help me out.

I can export to xml or excel file. If i can convert excel or xml to sas file then also my requirement is fulfilled to some extent.

Can anyone give me the solution of anyone of the above in java??
harry ganguly
Greenhorn

Joined: Dec 14, 2010
Posts: 13
any suggestions?
Steve Luke
Bartender

Joined: Jan 28, 2003
Posts: 4181
    
  21

I am not sure exactly what you expect. Surely you searched for a utility for writing the SAS7BDAT format. I assume that you didn't find one for Java. It is a proprietary format that hasn't been released by SAS which means a bit more research is required - and perhaps writing of code on your part. For example, you will have to figure out the file format. There are some 'readers' for the file format (for example dsread: http://www.oview.co.uk/dsread/.) Perhaps one of them can help you figure out the file format necessary to write the format.

SAS apparently can import from CSV or from Excel so you could write to those file formats. And if you have SAS on you could try to automate the IMPORT proc perhaps.


Steve
 
jQuery in Action, 2nd edition
 
subject: Conversion of resultset or collection into sas file format(*.sas7bdat)