Help using Base SAS procedures

How to copy CARS from SASHELP to WORK

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

How to copy CARS from SASHELP to WORK

[ Edited ]

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.


Accepted Solutions
Solution
‎03-06-2018 01:11 PM
Super User
Posts: 13,583

Re: How to copy CARS from SASHELP to WORK

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.

View solution in original post


All Replies
Solution
‎03-06-2018 01:11 PM
Super User
Posts: 13,583

Re: How to copy CARS from SASHELP to WORK

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.

New Contributor
Posts: 4

Re: How to copy CARS from SASHELP to WORK

Thank you. Yes, I did an import data. Thanks again!
Super User
Posts: 13,583

Re: How to copy CARS from SASHELP to WORK

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.

Highlighted
New Contributor
Posts: 4

Re: How to copy CARS from SASHELP to WORK

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


☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 193 views
  • 1 like
  • 2 in conversation