Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
any suggestions?
 
Bartender
Posts: 4179
22
IntelliJ IDE Python Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
The longest recorded flight time of a chicken is 13 seconds. But that was done without this tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic