DICTIONARY Table Question

darrylovia — Wed, 02 Apr 2008 19:35:34 GMT

I've been looking into SAS catalogs lately and was wondering if any one knows what the column "alias" means in the DICTIONARY.CATALOGS table/view. All the values are missing.

Thanks

2 + DESCRIBE TABLE DICTIONARY.CATALOGS;
NOTE: SQL table DICTIONARY.CATALOGS was created like:

create table DICTIONARY.CATALOGS
(
libname char(8) label='Library Name',
memname char(32) label='Member Name',
memtype char(8) label='Member Type',
objname char(32) label='Object Name',
objtype char(8) label='Object Type',
objdesc char(256) label='Object Description',
created num format=DATETIME informat=DATETIME label='Date Created',
modified num format=DATETIME informat=DATETIME label='Date Modified',
alias char(32) label='Object Alias',
level num label='Library Concatenation Level'
);

Re: DICTIONARY Table Question

deleted_user — Tue, 08 Apr 2008 12:00:56 GMT

Hi,

Submit code:

data totals;
length dept $ 7 site $ 8;
input dept site quarter sales;
datalines;
Parts Sydney 1 7043.97
Parts Atlanta 1 8225.26
Parts Paris 1 5543.97
Tools Sydney 4 1775.74
Tools Atlanta 4 3424.19
Tools Paris 4 6914.25
;

RUN;

title 'Total Sales';
footnote j=r 'GCHBKSUM ';

proc gchart data=totals gout=sasuser.tmp;
format sales dollar8.;
block site / sumvar=sales name = "XYZ";
run;
quit;

GRSEG catalog entry has alias and it looks like unique ID for entry.

M.

topic Re: DICTIONARY Table Question in SAS Programming

DICTIONARY Table Question

Re: DICTIONARY Table Question