topic Re: How to pull specific datasets into a new Library in New SAS User

How to pull specific datasets into a new Library

Hari2 — Tue, 26 Nov 2019 07:33:11 GMT

HI Team,

- I want to connect to connect to a New Library with in SAS, However we have many datasets in that Library and I do not want to pull all

of them rather I want to pull only one data set / Specific 2,3 datasets.
- How can I do this through Libname staement. Please suggest.

Re: How to pull specific datasets into a new Library

Jagadishkatam — Tue, 26 Nov 2019 09:01:56 GMT

Please try the proc copy procedure as below

libname existing '~path';
libname new '~path';

proc copy in=existing out=new memtype=data;
select dataset1 dataset2 dataset3;
run;

Re: How to pull specific datasets into a new Library

Patrick — Tue, 26 Nov 2019 10:44:57 GMT

@Hari2

A libname only establishes the connection to the folder and creates a directory listing. No data gets moved by the libname and for this reason the number of tables in the folder will not cause issues nor impact on performance.