topic Re: Download SAS table in SAS Software for Learning Community

Download SAS table

sasnewbie221 — Thu, 07 Jul 2022 14:21:12 GMT

Hi,
I am trying to download a SAS table as a sasbdat file but I’m unsure of how to do this. I generated the table in SAS. Thank you

Re: Download SAS table

PaigeMiller — Thu, 07 Jul 2022 14:22:18 GMT

Download from where? Download to where?

Re: Download SAS table

sasnewbie221 — Thu, 07 Jul 2022 14:23:14 GMT

Download from SAS studio onto my laptop

Re: Download SAS table

PaigeMiller — Thu, 07 Jul 2022 14:36:47 GMT

Do you want to convert from a SAS data set to Excel or CSV or Text or some other format? A SAS data set downloaded to your laptop is useless unless you also have SAS running on that laptop.

Re: Download SAS table

sasnewbie221 — Thu, 07 Jul 2022 14:38:02 GMT

I want to download it as a sas7bdat file. I have SAS running on the laptop

Re: Download SAS table

Kurt_Bremser — Thu, 07 Jul 2022 14:44:37 GMT

@sasnewbie221 wrote:
I want to download it as a sas7bdat file. I have SAS running on the laptop

So you have both a remote SAS session and the option of running your local SAS?

First, get the path name for the library by using the PATHNAME function. Also look at the path of the Files section in your Studio navigation pane.

If the path of the library is a subdirectory of your Files location, you can navigate there and use the download button of SAS Studio.

If it is not, you need to create a subdirectory in Files, assign a LIBNAME to it, and copy the dataset there (PROC COPY, or a DATA step); then do as above.

Re: Download SAS table

sasnewbie221 — Thu, 07 Jul 2022 14:45:45 GMT

Thank you!!!