SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
irmst_node_get_analysis_data.sas
Go to the documentation of this file.
1/*
2 Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA
3*/
4
5/** \file
6 \brief Retrieve Analysis Data
7
8 \param[in] ST_PRM.RUN_OPTION parameter table
9 \param[in] %ds_in_config Macrovarload table containing the required parameters ANALYSIS_DATA_KEY and ANALYSIS_DATA_DS_NAME
10 \param[out] %ds_out_sync Output synchronization table for the data view.
11 \param[out] %ds_out_dataInfo Output table containing metadata information about the table that was retrieved.
12 \param[out] %ds_out_partition_list Output table containing the list of partition tables that were retrieved from the data repository.
13
14 \details
15
16 This node makes a call to macro \link irm_rgf_retrieve_analysis_data.sas \endlink to retrieve the requested table from the data repository.
17
18 In addition the following macro utilities are called:
19
20 | Macro name | Description | Further information |
21 |---------------------------|--------------------------------------------------------------------------------------------------------------|-----------------------------------------------|
22 | irm_session_prepare | Reads RUN_OPTION table and sets logging options | \link irm_session_prepare.sas \endlink |
23 | irm_session_cleanup | Removes all non-IRM WORK datasets/views and deletes all user-created macro variables from workspace session | \link irm_session_cleanup.sas \endlink |
24
25 \ingroup nodes
26 \author SAS Institute Inc.
27 \date 2018
28*/
29
30/* Initialize session */
31%irm_session_prepare();
32
33/* Extract the libref from the output table parameter */
34%let out_libref = %scan(&ds_out_sync., 1, .);
35
36%let ticket =;
37%irm_rgf_retrieve_analysis_data(key = &analysis_data_key.
38 , libref = &dr_libref.
39 , dr_library_name = &dr_library_name.
40 , outds_meta = &ds_out_meta.
41 , outds = &out_libref..&analysis_data_ds_name.
42 , outds_partition_list = &ds_out_partition_list.
43 , out_type = deferred
44 , outds_dataInfo = analysis_dataInfo
45 , outds_dataDef = analysis_dataDef
46 , host = &rgf_protocol.://&rgf_host.
47 , server = &rgf_service.
48 , solution = &rgf_solution.
49 , port = &rgf_port.
50 , tgt_ticket = &tgt_ticket.
51 , username = &irm_user_id.
52 , password = &irm_user_password.
53 , outVarTicket = ticket
54 , outSuccess = httpSuccess
55 , outResponseStatus = responseStatus
56 , restartLUA = Y
57 , clearCache = Y
58 );
59
60/* Create synchronization table for downstream processing */
61data &ds_out_sync.;
62 length
63 table_name $100.
64 data_type $20.
65 status $20.
66 ;
67 table_name = "%upcase(&out_libref..&analysis_data_ds_name.)";
68 data_type = "View";
69 status = "Created";
70run;
71
72/* Create dataInfo table */
73data &ds_out_dataInfo.;
74 merge
75 analysis_dataInfo(rename = (key = analysisDataKey name = analysisDataName))
76 analysis_dataDef(rename = (key = dataDefinitionKey name = dataDefinitionName))
77 ;
78run;
79
80/* Cleanup session */
81%irm_session_cleanup;