How to determine proper file name with Proc Export?

IvyMcKee — Thu, 14 Nov 2019 21:16:20 GMT

I am trying to use proc export to export a SAS file to excel. The issue is that the file is not something that I created; it existed already in a library accessible via SAS, so I don't know what to call the file I need.

Here is what I am doing:

proc export

data= FILE NAME THAT I DON'T KNOW

DBMS = XLSX

Outfile = "place I want the file to go"

replace;

run;

I can see and look at the file I need via the library it is in, but I don't know how to write the file name - if that makes sense? I have copy and pasted the actual file name without any extra library information, and that did not work, and now I am at a loss. This file is pretty deep into a bunch of folders, so the path would be something like "sasApp/folder1/201601/estimate/revision/data/FILE I NEED".

Re: How to determine proper file name with Proc Export?

ballardw — Thu, 14 Nov 2019 21:34:05 GMT

@IvyMcKee wrote:

I am trying to use proc export to export a SAS file to excel. The issue is that the file is not something that I created; it existed already in a library accessible via SAS, so I don't know what to call the file I need.

Here is what I am doing:

proc export

data= FILE NAME THAT I DON'T KNOW

DBMS = XLSX

Outfile = "place I want the file to go"

replace;

run;

I can see and look at the file I need via the library it is in, but I don't know how to write the file name - if that makes sense? I have copy and pasted the actual file name without any extra library information, and that did not work, and now I am at a loss. This file is pretty deep into a bunch of folders, so the path would be something like "sasApp/folder1/201601/estimate/revision/data/FILE I NEED".

What is the name of the library? Way to reference SAS data sets is to use Libname.Datasetname. Note that the period between the library name and the data set is required. If your set is in the WORK library then you skip the library if you want to. SAS by default assumes that single names are in the Work library.

So your code would look something like:

Proc Export data=somelib.thedataset 
    outfile="c:\path\folder\filename.xlsx"
   dbms = xlsx
   replace
;

You may also find that if you right click on a data set that you get a menu with an EXPORT item that would use a wizard that already knows which set you want to export.

The library concept means that SAS code is somewhat operating system independent. Once you have defined a Library in the current operating system syntax then all the SAS code that uses that library knows where to find or place things like data sets.

If you do not provide an input data set most SAS procedures that expect an input data set will use the last created set. So it is quite possible that if you did not provide any name that something else gets placed into your exported data file.

topic How to determine proper file name with Proc Export? in SAS Procedures

How to determine proper file name with Proc Export?

Re: How to determine proper file name with Proc Export?