Importing Spreadsheet in sas

Frequent Contributor
Posts: 89

Importing Spreadsheet in sas


I am trying to import open document spreadsheet(LibreOffice Calc) document into sas

but iam unable to import

how can i import spread sheet document into sas

Respected Advisor
Posts: 4,736

Re: Importing Spreadsheet in sas

If you have SAS/Access to ODBC installed then it should be possible to directly access your document.

Else: You could save your document in Excel format (according to what I've read on the Internet this appears to be possible). Then use the EG import wizard. If you would want to do it with code then again you would need the SAS/Access to PC File Formats licensed.

And if nothing of this works: Store your document as .csv and then use either the EG import wizard or a infile/input statement in code.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation