Columns of the views
vallopt
1 optname char 32 Option Name
2 opttype char 8 Option type
3 offset num 8 Offset into option value
4 setting char 1024 Option Setting
5 optdesc char 160 Option Description
6 level char 8 Option Location
7 optstart char 8 Option Set
8 group char 32 Option Group
vcatalg
1 libname char 8 Library Name
2 memname char 32 Member Name
3 memtype char 8 Member Type
4 objname char 32 Object Name
5 objtype char 8 Object Type
6 objdesc char 256 Object Description
7 created num 8 Date Created DATETIME.
8 modified num 8 Date Modified DATETIME.
9 alias char 32 Object Alias
10 level num 8 Library Concatenation Level
vcformat
1 fmtname char 32 Format Name
vchkcon
1 constraint_catachar 32 Constraint Catalog
2 constraint_schechar 8 Constraint Schema
3 constraint_namechar 32 Constraint Name
4 check_clause char 256 Check Clause
vcncolu
1 table_catalog char 8 Libname
2 table_schema char 8 Table Schema
3 table_name char 32 Table
4 column_name char 32 Column
5 constraint_catachar 32 Constraint Catalog
6 constraint_schechar 8 Constraint Schema
7 constraint_namechar 32 Constraint Name
vcntabu
1 table_catalog char 8 Libname
2 table_schema char 8 Table Schema
3 table_name char 32 Table
4 constraint_catachar 32 Constraint Catalog
5 constraint_schechar 8 Constraint Schema
6 constraint_namechar 32 Constraint Name
vdatait
1 libname char 8 Library Name
2 memname char 32 Member Name
3 name char 32 Column Name
4 dataitemname char 1024 Data Item Name
5 id char 1024 Data Item ID
6 path char 1024 Data Item Path
7 class char 8 Data Item Classification
8 aggregation char 64 Data Item Default Aggregation
9 iscalc char 3 Data Item is Calculated?
10 isusable char 3 Data Item is Usable?
11 promptid char 1024 Data Item Prompt ID
12 description char 1024 Data Item Description
vdctnry
1 memname char 32 Member Name
2 memlabel char 256 Data Set Label
3 name char 32 Column Name
4 type char 4 Column Type
5 length num 8 Column Length
6 npos num 8 Column Position
7 varnum num 8 Column Number in Table
8 label char 256 Column Label
9 format char 49 Column Format
10 informat char 49 Column Informat
vdest
1 destination char 100 Destination
2 style char 32 Style
vengine
1 engine char 8 Engine Name
2 alias char 8 Alias
3 description char 40 Description
4 preferred char 3 Preferred?
5 properties char 1024 Engine Dialog Properties
vextfl
1 fileref char 8 Fileref
2 xpath char 1024 Pathname
3 xengine char 8 Engine Name
4 modate num 8 Date Modified DATETIME.
5 filesize num 8 Size of File
6 level num 8 File Concatenation Level
7 directory char 3 Directory?
8 exists char 3 Exists?
9 temporary char 3 Temporary?
vfilter
1 libname char 8 Library Name
2 memname char 32 Member Name
3 name char 32 SAS Name for Filter
4 filtername char 1024 Filter Name
5 id char 1024 Filter ID
6 path char 1024 Filter Path
7 promptusage char 6 Filter Prompt Usage
8 usagepromptid char 1024 Prompt ID Usage with Filter
9 description char 1024 Filter Description
vformat
1 libname char 8 Library Name
2 memname char 32 Member Name
3 path char 1024 Pathname
4 objname char 32 Object Name
5 fmtname char 32 Format Name
6 fmttype char 1 Format Type
7 source char 1 Format Source
8 minw num 8 Minimum Width
9 mind num 8 Minimum Decimal Width
10 maxw num 8 Maximum Width
11 maxd num 8 Maximum Decimal Width
12 defw num 8 Default Width
13 defd num 8 Default Decimal Width
vfunc
1 source char 1 Format Source
2 fncname char 32 Function name
3 minarg num 8 Minimum args to function
4 maxarg num 8 Maximum args to function
5 fnctype char 1 Function type
6 fncargs num 8 Argument attributes
7 fncprod char 1 Function implementation type
vgopt
1 optname char 32 Option Name
2 opttype char 8 Option type
3 offset num 8 Offset into option value
4 setting char 1024 Option Setting
5 optdesc char 160 Option Description
6 level char 8 Option Location
7 optstart char 8 Option Set
8 group char 32 Option Group
vindex
1 libname char 8 Library Name
2 memname char 32 Member Name
3 memtype char 8 Member Type
4 name char 32 Column Name
5 idxusage char 9 Column Index Type
6 indxname char 32 Index Name
7 indxpos num 8 Position of Column in Concatenated Key
8 nomiss char 3 Nomiss Option
9 unique char 3 Unique Option
vinfomp
1 libname char 8 Library Name
2 memname char 32 Member Name
3 mapname char 60 Information Map Name
4 repository char 128 Information Map Repository
5 path char 1024 Information Map Path
6 promptid char 1024 Information Map Prompt ID
7 description char 1024 Information Map Description
vlocale
1 locale char 5 Locale name
2 language char 60 Language $UESCE60.
3 region char 60 Region $UESCE60.
4 currsym char 360 Currency Symbol $UESCE360.
5 icurrsym char 3 International Currency Symbol
6 currrad char 6 Currency Radix $UESCE6.
7 currsep char 6 Currency Separator $UESCE6.
8 currfrac num 8 Number of Digits for Fraction
9 currifrac num 8 Number of Digits for International Fract
vmacro
1 scope char 32 Macro Scope
2 name char 32 Macro Variable Name
3 offset num 8 Offset into Macro Variable
4 value char 200 Macro Variable Value
vmember
1 libname char 8 Library Name
2 memname char 32 Member Name
3 memtype char 8 Member Type
4 dbms_memtype char 32 DBMS Member Type
5 engine char 8 Engine Name
6 index char 3 Indexes
7 path char 1024 Pathname
voption
1 optname char 32 Option Name
2 opttype char 8 Option type
3 offset num 8 Offset into option value
4 setting char 1024 Option Setting
5 optdesc char 160 Option Description
6 level char 8 Option Location
7 optstart char 8 Option Set
8 group char 32 Option Group
vprmxml
1 libname char 8 Library Name
2 memname char 32 Member Name
3 id char 1024 Prompt ID
4 order num 8 Order Number of XML String
5 length num 8 XML String Length
6 xml char 33E3 Prompt XML String
vprompt
1 libname char 8 Library Name
2 memname char 32 Member Name
3 name char 32 SAS Name for Prompt
4 promptname char 1024 Prompt Name
5 id char 1024 Prompt ID
6 text char 1024 Prompting Text
7 type char 4 Prompt Value Type
8 length num 8 Prompt Value Length
9 prompttype char 64 Prompt Value SQL Type
10 dependentpid char 1024 Dependent Prompt ID
11 description char 1024 Prompt Description
vrefcon
1 libname char 8 Library Name
2 memname char 32 Member Name
3 constraint_catachar 32 Constraint Catalog
4 constraint_schechar 8 Constraint Schema
5 constraint_namechar 32 Constraint Name
6 unique_constraichar 32 Unique Constraint Catalog
7 unique_constraichar 8 Unique Constraint Schema
8 unique_libname char 8 Unique Library Name
9 unique_memname char 32 Unique Member Name
10 unique_constraichar 32 Unique Constraint Name
11 match_option char 8 Match Option
12 update_rule char 12 Update Rule
13 delete_rule char 12 Delete Rule
vrememb
1 libname char 8 Library Name
2 memname char 32 Member Name
3 offset num 8 Offset into Text Remembered
4 rtext char 200 Text Remembered
5 pw char 8 Password
vsacces
1 libname char 8 Library Name
2 memname char 32 Member Name
vscatlg
1 libname char 8 Library Name
2 memname char 32 Member Name
vslib
1 libname char 8 Library Name
2 path char 1024 Pathname
vstable
1 libname char 8 Library Name
2 memname char 32 Member Name
vstabvw
1 libname char 8 Library Name
2 memname char 32 Member Name
3 memtype char 8 Member Type
vstyle
1 libname char 8 Library Name
2 memname char 32 Member Name
3 style char 32 Style Name
4 crdate num 8 Date Created DATETIME.
vsview
1 libname char 8 Library Name
2 memname char 32 Member Name
vtabcon
1 table_catalog char 8 Libname
2 table_schema char 8 Table Schema
3 table_name char 32 Table
4 constraint_catachar 32 Constraint Catalog
5 constraint_schechar 8 Constraint Schema
6 constraint_namechar 32 Constraint Name
7 constraint_typechar 8 Constraint Type
8 is_deferrable char 1 Is Deferred?
9 initially_deferchar 1 Initially Deferred?
vtable
1 libname char 8 Library Name
2 memname char 32 Member Name
3 memtype char 8 Member Type
4 dbms_memtype char 32 DBMS Member Type
5 memlabel char 256 Data Set Label
6 typemem char 8 Data Set Type
7 crdate num 8 Date Created DATETIME.
8 modate num 8 Date Modified DATETIME.
9 nobs num 8 Number of Physical Observations
10 obslen num 8 Observation Length
11 nvar num 8 Number of Variables
12 protect char 3 Type of Password Protection
13 compress char 8 Compression Routine
14 encrypt char 8 Encryption
15 npage num 8 Number of Pages
16 filesize num 8 Size of File
17 pcompress num 8 Percent Compression
18 reuse char 3 Reuse Space
19 bufsize num 8 Bufsize
20 delobs num 8 Number of Deleted Observations
21 nlobs num 8 Number of Logical Observations
22 maxvar num 8 Longest variable name
23 maxlabel num 8 Longest label
24 maxgen num 8 Maximum number of generations
25 gen num 8 Generation number
26 attr char 3 Data Set Attributes
27 indxtype char 9 Type of Indexes
28 datarep char 32 Data Representation
29 sortname char 8 Name of Collating Sequence
30 sorttype char 4 Sorting Type
31 sortchar char 8 Charset Sorted By
32 reqvector char 24 Requirements Vector $HEX48.
33 datarepname char 170 Data Representation Name
34 encoding char 256 Data Encoding
35 audit char 3 Audit Trail Active?
36 audit_before char 3 Audit Before Image?
37 audit_admin char 3 Audit Admin Image?
38 audit_error char 3 Audit Error Image?
39 audit_data char 3 Audit Data Image?
40 num_character num 8 Number of Character Variables
41 num_numeric num 8 Number of Numeric Variables
vtitle
1 type char 1 Title Location
2 number num 8 Title Number
3 text char 256 Title Text
vview
1 libname char 8 Library Name
2 memname char 32 Member Name
3 memtype char 8 Member Type
4 engine char 8 Engine Name
vxattr
1 libname char 8 Library Name
2 memname char 32 Member Name
3 name char 32 Column Name
4 xattr char 32 Extended Attribute Name
5 xtype char 4 Extended Attribute Type
6 xoffset num 8 Offset Into Extended Attribute Value
7 xvalue char 200 Extended Attribute Value
Extracting the columns
These columns were extracted with the following script:
%macro sashelp_view_columns(viewname);
%local viewname_lc;
%let viewname_lc = %sysfunc(lowcase(&viewname));
filename out "/share/home/tq84/sas/sashelp_views/&viewname_lc";
data _null_;
set sashelp.vcolumn(where=(libname="SASHELP" and memname="&viewname"));
file out;
put varnum 2. @+2
name $15.
type $6.
length 4. @+2
label $40.
format $20.;
run;
filename out clear;
%mend sashelp_view_columns;
proc sql;
create table work.sashelp_views as
select memname
from dictionary.members
where libname = 'SASHELP' and
memtype = 'VIEW';
quit;
data _null_;
set work.sashelp_views;
call execute(cat('%sashelp_view_columns(', memname, ')'));
run;
systask command "sed -i 's/ *$//' /share/home/tq84/sas/sashelp_views/*" shell="sh";