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:best.	SEARCHTYPE:$4	SEARCHVAL:$100
DC258467.MPE_X_TEST	-1	CHAR	Some String

No input column may be longer than the length declared in this service - LIBDS 41, SEARCHTYPE 4, SEARCHVAL 100. An input column longer than the declared length stops the step with "Multiple lengths were specified for the variable ...", so the SASjs adapter sends the $char form (eg $char4.), which also preserves any leading blanks.

Service Outputs

cols

• DDTYPE - C=CHARACTER, N=NUMERIC, else DATE / TIME / DATETIME
• FORMAT
• LABEL
• LENGTH
• NAME
• TYPE

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_casload.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.