viewdata.sas File Reference

Provide the raw view of the data. More...

Go to the source code of this file.

Detailed Description

Pass a LIBDS and FILTER_RK to return a dataset for viewing. VIEW datasets include all columns / rows (unlike EDIT, which are filtered for current records and don't include the SCD2 etc cols).

Service Inputs

SASCONTROLTABLE

LIBDS:$41.	FILTER_RK:$5.	SEARCHTYPE:$4	SEARCHVAL:$1000
DC258467.MPE_X_TEST	-1	CHAR	Some String

Service Outputs

cols

• DDTYPE
• FORMAT
• LABEL
• LENGTH
• NAME
• TYPE
• VARNUM

sasparams

• FILTER_TEXT
• NOBS
• PK_FIELDS - string seperated list of primary key fields, if they exist
• TABLENAME
• TABLEURI
• VARS

versions

history of DC versions for this particular table

viewdata

The raw data from the target table.

SAS Macros

• dc_assignlib.sas
• dc_createdataset.sas
• dc_gettableid.sas
• mf_existds.sas
• mf_getvarcount.sas
• mf_nobs.sas
• mf_verifymacvars.sas
• mp_abort.sas
• mp_cntlout.sas
• mp_getcols.sas
• mp_getpk.sas
• mp_jsonout.sas
• mp_searchdata.sas
• mp_validatecol.sas
• mpe_columnlevelsecurity.sas
• mpe_dsmeta.sas
• mpe_getversions.sas
• mpe_filtermaster.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 viewdata.sas.