getdata.sas File Reference

Returns a dataset to the editor front end. More...

Go to the source code of this file.

Detailed Description

Service Inputs

SASCONTROLTABLE

LIBDS:$41.	FILTER_RK:$5.
DC258467.MPE_X_TEST	-1

Service Outputs

sasdata

sasparams

Contains info on the request. One row is returned.

• CLS_FLG - set to 0 if there are no CLS rules (everything editable) else set to 1 (CLS rules exist)
• ISMAP - set to 1 if the target DS is an excel map target, else 0

approvers

dqrules

dqdata

cols

Contains column level attributes.

• NAME - column name
• VARNUM - variable position. Source: https://core.sasjs.io/mp__getcols_8sas.html
• LABEL - variable label. Source: https://core.sasjs.io/mp__getcols_8sas.html
• FMTNAME - derived format name. Source: https://core.sasjs.io/mp__getcols_8sas.html
• DDTYPE - derived dropdown type. Source: https://core.sasjs.io/mp__getcols_8sas.html
• CLS_RULE - values include:
  • EDIT - the column is editable
  • READ - the column should be readonly
  • HIDE - the column should be hidden
• memlabel
• desc- augmented with MPE_DATADICTIONARY if exists, else label
• longdesc - from MPE_DATADICTIONARY

maxvarlengths

xl_rules

query

versions

history of DC versions for this particular table

SAS Macros

• dc_assignlib.sas
• dc_getgroupmembers.sas
• mf_existvar.sas
• mf_getattrn.sas
• mf_getvarlist.sas
• mf_existds.sas
• mf_getquotedstr.sas
• mf_getuser.sas
• mf_nobs.sas
• mf_verifymacvars.sas
• mf_wordsinstr1butnotstr2.sas
• mp_abort.sas
• mp_cntlout.sas
• mp_getcols.sas
• mp_getmaxvarlengths.sas
• mp_validatecol.sas
• mpe_accesscheck.sas
• mpe_columnlevelsecurity.sas
• mpe_dsmeta.sas
• mpe_getlabels.sas
• mpe_getversions.sas
• mpe_filtermaster.sas
• mpe_runhook.sas

Version

9.2

Author

4GL Apps Ltd

Copyright

4GL Apps Ltd. This code may only be used within Data Controller and may not be re-distributed or re-sold without the express permission of 4GL Apps Ltd.

Definition in file getdata.sas.