Macros for SAS Application Developers
https://github.com/sasjs/core
mm_getpublictypes.sas
Go to the documentation of this file.
1 /**
2  @file mm_getpublictypes.sas
3  @brief Creates a dataset with all deployable public types
4  @details More info:
5  https://support.sas.com/documentation/cdl/en/bisag/65422/HTML/default/viewer.htm#n1nkrdzsq5iunln18bk2236istkb.htm
6 
7  Usage:
8 
9  * dataset will contain one column - publictype ($64);
10  %mm_getpublictypes(outds=types)
11 
12  @param [out] outds= (work.mm_getpublictypes) The library.dataset to create
13 
14  @returns outds= dataset containing all types
15 
16  @version 9.3
17  @author Allan Bowe
18 
19 **/
20 
21 %macro mm_getpublictypes(
22  outds=work.mm_getpublictypes
23 )/*/STORE SOURCE*/;
24 
25 proc sql;
26 create table &outds (publictype char(64)); /* longest is currently 52 */
27 insert into &outds values ('ACT');
28 insert into &outds values ('Action');
29 insert into &outds values ('Application');
30 insert into &outds values ('ApplicationServer');
31 insert into &outds values ('BurstDefinition');
32 insert into &outds values ('Channel');
33 insert into &outds values ('Condition');
34 insert into &outds values ('ConditionActionSet');
35 insert into &outds values ('ContentSubscriber');
36 insert into &outds values ('Cube');
37 insert into &outds values ('DataExploration');
38 insert into &outds values ('DeployedFlow');
39 insert into &outds values ('DeployedJob');
40 insert into &outds values ('Document');
41 insert into &outds values ('EventSubscriber');
42 insert into &outds values ('ExternalFile');
43 insert into &outds values ('FavoritesFolder');
44 insert into &outds values ('Folder');
45 insert into &outds values ('Folder.SecuredData');
46 insert into &outds values ('GeneratedTransform');
47 insert into &outds values ('InformationMap');
48 insert into &outds values ('InformationMap.OLAP');
49 insert into &outds values ('InformationMap.Relational');
50 insert into &outds values ('JMSDestination (Java Messaging System message queue)');
51 insert into &outds values ('Job');
52 insert into &outds values ('Job.Cube');
53 insert into &outds values ('Library');
54 insert into &outds values ('MessageQueue');
55 insert into &outds values ('MiningResults');
56 insert into &outds values ('MQM.JMS (queue manager for Java Messaging Service)');
57 insert into &outds values ('MQM.MSMQ (queue manager for MSMQ)');
58 insert into &outds values ('MQM.Websphere (queue manager for WebSphere MQ)');
59 insert into &outds values ('Note');
60 insert into &outds values ('OLAPSchema');
61 insert into &outds values ('Project');
62 insert into &outds values ('Project.EG');
63 insert into &outds values ('Project.AMOExcel');
64 insert into &outds values ('Project.AMOPowerPoint');
65 insert into &outds values ('Project.AMOWord');
66 insert into &outds values ('Prompt');
67 insert into &outds values ('PromptGroup');
68 insert into &outds values ('Report');
69 insert into &outds values ('Report.Component');
70 insert into &outds values ('Report.Image');
71 insert into &outds values ('Report.StoredProcess');
72 insert into &outds values ('Role');
73 insert into &outds values ('SearchFolder');
74 insert into &outds values ('SecuredLibrary');
75 insert into &outds values ('Server');
76 insert into &outds values ('Service.SoapGenerated');
77 insert into &outds values ('SharedDimension');
78 insert into &outds values ('Spawner.Connect');
79 insert into &outds values ('Spawner.IOM (object spawner)');
80 insert into &outds values ('StoredProcess');
81 insert into &outds values ('SubscriberGroup.Content');
82 insert into &outds values ('SubscriberGroup.Event');
83 insert into &outds values ('Table');
84 insert into &outds values ('User');
85 insert into &outds values ('UserGroup');
86 quit;
87 
88 %mend mm_getpublictypes;