Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
harry ganguly
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
any suggestions?
 
Steve Luke
Bartender
Posts: 4181
22
IntelliJ IDE Java Python
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic