topic Re: Save sas7bdat file on my local pc, using saspy, sas on demand for acedemics in New SAS User

Save sas7bdat file on my local pc, using saspy, sas on demand for acedemics

AnushaShreyas — Fri, 01 Jul 2022 04:32:29 GMT

I have imported .csv file from local pc and converted it into .sas7bdat file using saspy, the result is currently saving on sas server (cloud) , I need the file to be stored in my local system, As I am a new user I dont know much about using saspy please help me with this issue.

Re: Save sas7bdat file on my local pc, using saspy, sas on demand for acedemics

Kurt_Bremser — Fri, 01 Jul 2022 06:23:11 GMT

Log on to SAS On Demand and use the download button in SAS Studio.

In which library (or path) did you create the dataset?

Re: Save sas7bdat file on my local pc, using saspy, sas on demand for acedemics

AnushaShreyas — Fri, 01 Jul 2022 07:25:03 GMT

Thanks for the reply, I am using local path to fetch the dataset (i.e D:/sas_test_data/sas.csv). And I am using python jupyter notebook to get this data and convert it into sas.sas7bdat and its saved in sas server.
But I want it to save in same location (i.e D:/sas_test_data/sas.sas7bdat) using saspy and python only, bec i am using it for automation, I cant always go to sas studio and get it downloaded, if you have any solutions for this please let me know, Thanks.

Re: Save sas7bdat file on my local pc, using saspy, sas on demand for acedemics

sastpw — Fri, 01 Jul 2022 17:58:23 GMT

Sure, just use SASPy's download method of your SASsession object (look for download in the API doc: https://sassoftware.github.io/saspy/api.html#

you would do something like the following:

resutls = sas.download(r'D:/sas_test_data', sas.workpath+'sas.sas7bdat)

give it a try!

Tom

Tried to copy it here:

download(localfile: str, remotefile: str, overwrite: bool = True, **kwargs)

This method downloads a remote file from the SAS servers file system.

Parameters:	localfile – path to the local file to create or overwrite remotefile – path to remote file overwrite – overwrite the output file if it exists?
Returns:	dict with 2 keys {‘Success’ : bool, ‘LOG’ : str}

Re: Save sas7bdat file on my local pc, using saspy, sas on demand for acedemics

AnushaShreyas — Tue, 05 Jul 2022 11:54:03 GMT

Thank you, Tom