topic Re: how do i export to a sas7dat file in SAS Procedures

how do i export to a sas7dat file

robm — Wed, 26 Mar 2014 01:41:29 GMT

I have a dataset I save as

PROC export

outfile="\\abccsrv1\dept\IM\Information and Service Requests\irsas14$dir\IR14006\Vers_1\Deliverables\ir14006.xls" dbms=XLS replace

2003;

;

how would I save as a sas7dat?

Re: how do i export to a sas7dat file

Reeza — Wed, 26 Mar 2014 02:12:59 GMT

You need proc import.

Re: how do i export to a sas7dat file

robm — Wed, 26 Mar 2014 03:31:13 GMT

do you have an example proc export seems counter intuitive since I an creating a dataset

Re: how do i export to a sas7dat file

Reeza — Wed, 26 Mar 2014 04:41:45 GMT

In SAS go to File>Import Data and click through selection, at the end it will give you the option to save the code to a file.

Re: how do i export to a sas7dat file

Kurt_Bremser — Wed, 26 Mar 2014 07:51:41 GMT

You don't need to export it, you already have a .sas7bdat in SAS. If you want to copy it somewhere, assign a library there and use proc copy.

Re: how do i export to a sas7dat file

RW9 — Wed, 26 Mar 2014 09:41:28 GMT

As KurtBremser has stated you should have the data somewhere, and your proc export is incomplete:

PROC export

/* Missing */ data=... /* this statement would tell you where the dataset is, if you are using the functionality of processing a previous dataset (and I would still recommend putting the data= statement in regardless for clarity - then look at that datastep */

outfile="\\abccsrv1\dept\IM\Information and Service Requests\irsas14$dir\IR14006\Vers_1\Deliverables\ir14006.xls" dbms=XLS replace

2003;

;