topic download sas dataset in SAS Programming

download sas dataset

Prabu — Mon, 13 Nov 2017 08:24:15 GMT

Hi All,

I have my base table in Teradata which is connected with the SAS.

now I need to take the backup of the table as a SAS Dataset.

i.e first I need to convert the Teradata table as a SAS Dataset and then need to download it.

Kindly help me with the approaches.

Re: download sas dataset

andreas_lds — Mon, 13 Nov 2017 08:36:30 GMT

Please specify how SAS and teradata are connected.

If a libref is assigned to the teradata-db, then assigning another libref to the folder in which the datasets should be stored and using proc copy can solve the issue.

Re: download sas dataset

Shmuel — Mon, 13 Nov 2017 08:41:17 GMT

See next link and addapt to your needs:

https://communities.sas.com/t5/Base-SAS-Programming/Subseting-Teradata-table-with-SAS-dataset/m-p/22553/highlight/true#M3656