how do i export to a sas7dat file

[robm]

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?

[Reeza]

You need proc import.

[robm]

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

[Reeza]

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.

[Kurt_Bremser · Accepted solution]

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.

[RW9]

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;

;