Tutorial by Topics: copy



Xcopy, copies files and directories, including subdirectories.

Example of how to copy existing table structure with/without data

If you're using SAS to produce reporting of some sort, you're going to find yourself needing to copy a file at some point. I've mostly used this method for copying an excel template, and then dumping data via PROC EXPORT into the new file I've created.

This is a great example I've found from Chris Hemedinger (http://blogs.sas.com/content/sasdummy/2011/06/17/how-to-use-sas-data-step-to-copy-a-file-from-anywhere/).

The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.


Page 1 of 1