How are all of these tables related?: Relational database map -: RDB_MAP.SAS

被引:0
|
作者
Losby, E [1 ]
机构
[1] HealthCare COMPARE Corp, Downers Grove, IL 60615 USA
关键词
D O I
暂无
中图分类号
TP31 [计算机软件];
学科分类号
081202 ; 0835 ;
摘要
This simple, yet highly useful SAS(R) program generates a "relational map" of permanent SAS datasets or SAS/ACCESS(R) views within a common libname reference. Basically, RDB MAP.SAS produces a tabular or matrix report showing the common variables shared by all the datasets or views in the libname. The column headings of the report are the SAS dataset or view names and the row headings are all the SAS variable names. An 'X' (or your favorite alpha-numeric character or word) is printed under the dataset or view the variable is found. One can then easily see which tables share a common variable. RDB_MAP.SAS utilizes the SASHELP.VCOLUMN dataset, a PROC SORT, a PROC TRANSPOSE, and a simple PROC PRINT. This is a fast and easy way to display all relationships between multiple tables of information.
引用
收藏
页码:1145 / 1149
页数:5
相关论文
共 17 条
  • [1] How do I map SQL database tables to Java']Java objects?
    Yuan, MJ
    DR DOBBS JOURNAL, 2002, 27 (03): : 89 - +
  • [2] Research on Construction Method of Multi-Dimensional Knowledge Map Based on Relational Database
    Wang, Xiao-Feng
    Ying, Bo-An
    Zhang, Xin
    Song, Xue-Ying
    Qi, Jing
    TEXTILE BIOENGINEERING AND INFORMATICS SYMPOSIUM PROCEEDINGS, VOLS 1 AND 2, 2012, : 713 - 718
  • [3] GENESCAPE - A RELATIONAL DATABASE OF ESCHERICHIA-COLI GENOMIC MAP DATA FOR MACINTOSH COMPUTERS
    BOUFFARD, G
    OSTELL, J
    RUDD, KE
    COMPUTER APPLICATIONS IN THE BIOSCIENCES, 1992, 8 (06): : 563 - 567
  • [4] How would a database help in the interpretation of the Vinland Map ink.
    Olin, JS
    ABSTRACTS OF PAPERS OF THE AMERICAN CHEMICAL SOCIETY, 2004, 228 : U752 - U753
  • [5] A complex XML schema to map the XML documents of distance education technical specifications into relational database
    Zhu X.-H.
    Zeng Q.-L.
    Cao Q.-H.
    International Journal of Digital Content Technology and its Applications, 2010, 4 (08) : 182 - 192
  • [6] Table2Graph: A Scalable Graph Construction From Relational Tables using Map-Reduce
    Lee, Sangkeun
    Park, Byung H.
    Lim, Seung-Hwan
    Shankar, Mallikarjun
    2015 IEEE FIRST INTERNATIONAL CONFERENCE ON BIG DATA COMPUTING SERVICE AND APPLICATIONS (BIGDATASERVICE 2015), 2015, : 294 - 301
  • [7] Map and GIS database of glacial landforms and features related to the last British Ice Sheet
    Clark, CD
    Evans, DJA
    Khatwa, A
    Bradwell, T
    Jordan, CJ
    Marsh, SH
    Mitchell, WA
    Bateman, MD
    BOREAS, 2004, 33 (04) : 359 - 375
  • [8] Fetal map: A gene expression database for predicting potential involvement in developmental toxicity for all druggable genes
    Hurtt, M. E.
    Streck, R. D.
    Kumpf, S. W.
    Stedman, D. B.
    Deng, S.
    BIRTH DEFECTS RESEARCH PART A-CLINICAL AND MOLECULAR TERATOLOGY, 2007, 79 (05) : 352 - 352
  • [9] Echoing the emotions of others: empathy is related to how adults and children map emotion onto the body
    Sachs, Matthew E.
    Kaplan, Jonas
    Habibi, Assal
    COGNITION & EMOTION, 2019, 33 (08) : 1639 - 1654
  • [10] How Do Basic Personality Traits Map Onto Moral Judgments of Fairness-Related Actions?
    Andrejevic, Milan
    Smillie, Luke D.
    Feuerriegel, Daniel
    Turner, William F.
    Laham, Simon M.
    Bode, Stefan
    SOCIAL PSYCHOLOGICAL AND PERSONALITY SCIENCE, 2022, 13 (03) : 710 - 721