topic How to copy CARS from SASHELP to WORK in SAS Procedures

How to copy CARS from SASHELP to WORK

floradoc — Tue, 06 Mar 2018 18:09:29 GMT

How do I copy the SAS dataset CARS.csv from SASHELP to WORK? Seems simple enough but I cannot cut and paste and the proc copy command is not cooperating. I was able to copy the dataset to My Folders but not down to WORK.

Re: How to copy CARS from SASHELP to WORK

ballardw — Tue, 06 Mar 2018 18:09:41 GMT

CARS.CSV is not a SAS data set. The libraries are only going to contain SAS data sets, views and catalogs (generally).

One way to copy a SAS data set is code such as:

Data work.cars;

set sashelp.cars;

run;

if Cars.csv is an actual CSV file in the SASHELP directory then it would have to be imported to a SAS data set first.

CUT and paste implies removing the data set from SASHELP is a very poor idea as many of the sets in SASHELP are used by the system. I would expect Copy and Paste to work though.

Show the log of the Proc copy attempt you used. it will likely explain why it failed. To preserve formatting of any error messages post the code in a code box opened using the forum's {I} menu icon.

Re: How to copy CARS from SASHELP to WORK

floradoc — Tue, 06 Mar 2018 18:12:43 GMT

Thank you. Yes, I did an import data. Thanks again!

Re: How to copy CARS from SASHELP to WORK

ballardw — Tue, 06 Mar 2018 20:35:39 GMT

It is a poor idea to store your data in either the SASHELP or SASUSER libraries as updates to SAS may replace the directories entirely and your data is not likely to be moved.

Re: How to copy CARS from SASHELP to WORK

floradoc — Tue, 06 Mar 2018 21:43:55 GMT

Yes, I was just trying create an example of copying datasets from one library to another.