The SAS Output Delivery System and reporting techniques

Copy Formats to Other Libraries (without overwriting)

Accepted Solution Solved
Reply
Regular Contributor
Posts: 228
Accepted Solution

Copy Formats to Other Libraries (without overwriting)

I have two libraries that I want to combine into a single library.  I completed this task as follows:

proc datasets;

      copy in=safety out=dsur;

quit;

proc datasets;

      copy in=demog out=dsur;

quit;

All the datasets copied over just fine.  However, I noticed that after running the first PROC, all the formats in the DSUR library are present.  Then when I run the second PROC, all the formats from SAFETY are replaced by all the formats in DEMOG.  In other words, I am getting all the desired datasets, but I am only getting formats from the last library copied over.  Is there some kind of option that will not overwrite existing formats?

The formats are not even named the same, by the way.  SAFETY has Action, Ctcgrd, Outcome, Relate, and Serious.  DEMOG as Cancertp, Ctry, Ethnic, Gender, and Race.  If that information helps at all.


Accepted Solutions
Solution
‎06-26-2013 10:53 AM
Super User
Super User
Posts: 6,851

Re: Copy Formats to Other Libraries (without overwriting)

Use the MEMTYPE option on the COPY statement in PROC DATASETS so that it will only copy the datasets.

Use PROC CATALOG to copy the members in the format catalogs.  If you have more than one catalog you might need to loop over them.

View solution in original post


All Replies
Solution
‎06-26-2013 10:53 AM
Super User
Super User
Posts: 6,851

Re: Copy Formats to Other Libraries (without overwriting)

Use the MEMTYPE option on the COPY statement in PROC DATASETS so that it will only copy the datasets.

Use PROC CATALOG to copy the members in the format catalogs.  If you have more than one catalog you might need to loop over them.

🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 873 views
  • 0 likes
  • 2 in conversation