topic Re: How to Export sas7bdat file into excel in SAS Programming

How to Export sas7bdat file into excel

SaraVana — Tue, 05 Jun 2018 10:48:58 GMT

Hi All !,

i have alkoot_gross.sas7bdat file have 300MB . i need to export it into excel file. please give your suggestions.

Re: How to Export sas7bdat file into excel

RW9 — Tue, 05 Jun 2018 11:43:52 GMT

I would suggest reading the extensive documentation and help videos.

http://support.sas.com/documentation/94/

http://video.sas.com/

There are numerous methods, depending on what software you have installed (i.e. what SAS you have, where it is installed etc.) and what output type you want, xlsx, xls, csv etc.

Re: How to Export sas7bdat file into excel

Kurt_Bremser — Tue, 05 Jun 2018 11:47:28 GMT

If your dataset still fits into the limits of Excel spreadsheets (number of rows, number of columns), you just need to do a google search on the theme. There's already gazillions of posts here about export to Excel.

If not, forget it.

Personally I consider it brain-rotten stupid to put that much data into such an unreliable plaything as Excel. Especially when you have SAS at hand anyway. It's like trying to move five tons of boulders on a skateboard.

Re: How to Export sas7bdat file into excel

SaraVana — Tue, 05 Jun 2018 12:38:58 GMT

actually i've installed sas university edition in my system ( it have .ova file) . i didn't used sas before. that's why asking detailed suggestions from you guys.

Re: How to Export sas7bdat file into excel

Kurt_Bremser — Tue, 05 Jun 2018 12:56:49 GMT

The SAS UE website has a host of tutorial videos, at least one covers Export to Excel.

Re: How to Export sas7bdat file into excel

Reeza — Tue, 05 Jun 2018 15:02:16 GMT

@SaraVana wrote:

Hi All !,

i have alkoot_gross.sas7bdat file have 300MB . i need to export it into excel file. please give your suggestions.

The links included have detailed tutorials that illustrate how to export data. But if you really can't figure it out, you can right click the data set in the library, and select Export. It'll pop up a GUI interface that you can use to export the data.

SAS Studio also has the built in tasks that will allow you to do it via a GUI or you can look at the snippets as well, for the skeleton code.

The Tasks are on the left hand pane, under Data I believe.

Re: How to Export sas7bdat file into excel

Tom — Tue, 05 Jun 2018 16:38:42 GMT

I would suggest using the XLSX libname engine. It is simple and will help you begin to learn SAS syntax.

First make a libref that points to the directory that holds your SAS dataset. Then make a second libref that points to the file you want to create.

libname in '/folders/myfolders/';
libname out xlsx '/folders/myfolders/alkoot_gross.xlsx' ;

Then you can use a data step

data out.alkoot_gross;
  set in.alkoot_gross;
run;

or proc copy

proc copy inlib=in outlib=out;
  select alkoot_gross ;
run;