Procedure features: |
PROC
CATALOG statement:
|
COPY statement options:
|
DELETE statement options:
|
EXCLUDE statement options:
|
ENTRYTYPE= or ET= |
|
(ENTRYTYPE=) or (ET=) | |
QUIT statement |
RUN
statement |
SELECT statement options:
|
|
This example demonstrates all the following
actions:
-
copies entries by excluding a few entries
-
copies entries by specifying a few entries
-
protects entries from being
edited
-
moves entries
-
deletes entries
-
processes entries from multiple catalogs
-
processes entries in
multiple run groups
The SAS catalog PERM.SAMPLE contains the following entries:
DEFAULT FORM Default form for printing
FSLETTER FORM Standard form for letters (HP Laserjet)
LOAN FRAME Loan analysis application
LOAN HELP Information about the application
BUILD KEYS Function Key Definitions
LOAN KEYS Custom key definitions for application
CREDIT LOG credit application log
TEST1 LOG Inventory program
TEST2 LOG Inventory program
TEST3 LOG Inventory program
LOAN PMENU Custom menu definitions for applicaticm
CREDIT PROGRAM credit application pgm
TEST1 PROGRAM testing budget applic.
TEST2 PROGRAM testing budget applic.
TEST3 PROGRAM testing budget applic.
LOAN SCL SCL code for loan analysis application
PASSIST SLIST User profile
PRTINFO KPRINTER Printing Parameters
The SAS catalog PERM.FORMATS contains the following entries:
REVENUE FORMAT FORMAT:MAXLEN=16,16,12
DEPT FORMATC FORMAT:MAXLEN=1,1,14
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
options nodate pageno=1 linesize=80 pagesize=60 source; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
LIBNAME perm 'SAS-library'; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
proc catalog cat=perm.sample;
delete credit.program credit.log;
run; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
copy out=tcatall;
run; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
copy out=testcat;
exclude test1 test2 test3 passist (et=slist) / et=log;
run; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
copy out=logcat move;
select test1 test2 test3 / et=log;
run; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
copy out=perm.finance noedit;
select loan.frame loan.help loan.keys loan.pmenu;
run; |
![Note about code](../../../../common/63294/HTML/default/images/snbut.gif) |
copy in=perm.formats out=perm.finance;
select revenue.format dept.formatc;
quit; |
1 LIBNAME perm 'SAS-library';
NOTE: Directory for library PERM contains files of mixed engine types.
NOTE: Libref PERM was successfully assigned as follows:
Engine: V9
Physical Name: 'SAS-library'
2 options nodate pageno=1 linesize=80 pagesize=60 source;
3 proc catalog cat=perm.sample;
4 delete credit.program credit.log;
5 run;
NOTE: Deleting entry CREDIT.PROGRAM in catalog PERM.SAMPLE.
NOTE: Deleting entry CREDIT.LOG in catalog PERM.SAMPLE.
6 copy out=tcatall;
7 run;
NOTE: Copying entry DEFAULT.FORM from catalog PERM.SAMPLE to catalog
WORK.TCATALL.
NOTE: Copying entry FSLETTER.FORM from catalog PERM.SAMPLE to catalog
WORK.TCATALL.
NOTE: Copying entry LOAN.FRAME from catalog PERM.SAMPLE to catalog WORK.TCATALL.
NOTE: Copying entry LOAN.HELP from catalog PERM.SAMPLE to catalog WORK.TCATALL.
NOTE: Copying entry BUILD.KEYS from catalog PERM.SAMPLE to catalog WORK.TCATALL.
NOTE: Copying entry LOAN.KEYS from catalog PERM.SAMPLE to catalog WORK.TCATALL.
NOTE: Copying entry TEST1.LOG from catalog PERM.SAMPLE to catalog WORK.TCATALL.
NOTE: Copying entry TEST2.LOG from catalog PERM.SAMPLE to catalog WORK.TCATALL.
NOTE: Copying entry TEST3.LOG from catalog PERM.SAMPLE to catalog WORK.TCATALL.
NOTE: Copying entry LOAN.PMENU from catalog PERM.SAMPLE to catalog WORK.TCATALL.
NOTE: Copying entry TEST1.PROGRAM from catalog PERM.SAMPLE to catalog
WORK.TCATALL.
NOTE: Copying entry TEST2.PROGRAM from catalog PERM.SAMPLE to catalog
WORK.TCATALL.
NOTE: Copying entry TEST3.PROGRAM from catalog PERM.SAMPLE to catalog
WORK.TCATALL.
NOTE: Copying entry LOAN.SCL from catalog PERM.SAMPLE to catalog WORK.TCATALL.
NOTE: Copying entry PASSIST.SLIST from catalog PERM.SAMPLE to catalog
WORK.TCATALL.
NOTE: Copying entry PRTINFO.XPRINTER from catalog PERM.SAMPLE to catalog
WORK.TCATALL.
8 copy out=testcat;
9 exclude test1 test2 test3 passist (et=slist) / et=log;
10 run;
NOTE: Copying entry DEFAULT.FORM from catalog PERM.SAMPLE to catalog
WORK.TESTCAT.
NOTE: Copying entry FSLETTER.FORM from catalog PERM.SAMPLE to catalog
WORK.TESTCAT.
NOTE: Copying entry LOAN.FRAME from catalog PERM.SAMPLE to catalog WORK.TESTCAT.
NOTE: Copying entry LOAN.HELP from catalog PERM.SAMPLE to catalog WORK.TESTCAT.
NOTE: Copying entry BUILD.KEYS from catalog PERM.SAMPLE to catalog WORK.TESTCAT.
NOTE: Copying entry LOAN.KEYS from catalog PERM.SAMPLE to catalog WORK.TESTCAT.
NOTE: Copying entry LOAN.PMENU from catalog PERM.SAMPLE to catalog WORK.TESTCAT.
NOTE: Copying entry TEST1.PROGRAM from catalog PERM.SAMPLE to catalog
WORK.TESTCAT.
NOTE: Copying entry TEST2.PROGRAM from catalog PERM.SAMPLE to catalog
WORK.TESTCAT.
NOTE: Copying entry TEST3.PROGRAM from catalog PERM.SAMPLE to catalog
WORK.TESTCAT.
NOTE: Copying entry LOAN.SCL from catalog PERM.SAMPLE to catalog WORK.TESTCAT.
NOTE: Copying entry PRTINFO.XPRINTER from catalog PERM.SAMPLE to catalog
WORK.TESTCAT.
11 copy out=logcat move;
12 select test1 test2 test3 / et=log;
13 run;
NOTE: Moving entry TEST1.LOG from catalog PERM.SAMPLE to catalog WORK.LOGCAT.
NOTE: Moving entry TEST2.LOG from catalog PERM.SAMPLE to catalog WORK.LOGCAT.
NOTE: Moving entry TEST3.LOG from catalog PERM.SAMPLE to catalog WORK.LOGCAT.
14 copy out=perm.finance noedit;
15 select loan.frame loan.help loan.keys loan.pmenu;
16 run;
NOTE: Copying entry LOAN.FRAME from catalog PERM.SAMPLE to catalog PERM.FINANCE.
NOTE: Copying entry LOAN.HELP from catalog PERM.SAMPLE to catalog PERM.FINANCE.
NOTE: Copying entry LOAN.KEYS from catalog PERM.SAMPLE to catalog PERM.FINANCE.
NOTE: Copying entry LOAN.PMENU from catalog PERM.SAMPLE to catalog PERM.FINANCE.
17 copy in=perm.formats out=perm.finance;
18 select revenue.format dept.formatc;
19 quit;
NOTE: Copying entry REVENUE.FORMAT from catalog PERM.FORMATS to catalog
PERM.FINANCE.
NOTE: Copying entry DEPT.FORMATC from catalog PERM.FORMATS to catalog
PERM.FINANCE.
![](../../../../common/63294/HTML/default/images/spacer.gif) |
![](../../../../common/63294/HTML/default/images/spacer.gif) |
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.