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