How to copy CARS from SASHELP to WORK

[floradoc]

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.

[ballardw · Accepted solution]

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.

[floradoc]

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

[ballardw]

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.

[floradoc]

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