Unit under Test: combineddataset.sas
Test Coverage: 100%

Color Legend:
dummy Text
  Covered code
  Non covered code
  Comments
  Code marked as non contributing by option mcoverage


RowNumberOut pgmSourceColumn
00001 /**
00002 \file
00003 \ingroup SASUNIT_EXAMPLES_PGM
00004
00005 \brief Create combined dataset for a database
00006
00007
00008 \version \$Revision: 315 $
00009 \author \$Author: klandwich $
00010 \date \$Date: 2014-02-28 10:25:18 +0100 (Fr, 28 Feb 2014) $
00011 \sa For further information please refer to SASUnit User's Guide
00012 \sa \$HeadURL: https://svn.code.sf.net/p/sasunit/code/trunk/example/saspgm/combineddataset.sas $
00013 \copyright Copyright 2010, 2012 HMS Analytical Software GmbH.
00014 This file is part of SASUnit, the Unit testing framework for SAS(R) programs.
00015 For terms of usage under the GPL license see included file readme.txt
00016 or https://sourceforge.net/p/sasunit/wiki/readme.v1.2/.
00017
00018 */ /** \cond */
00019
00020 %MACRO combineddataset;
00021
00022 proc sql noprint;
00023 create table work.combineddataset as
00024 select CustomerName
00025 ,Customer.CustomerNumber
00026 ,Contracts.ContractNumber
00027 ,ContractType
00028 from work.Customer left join work.CustomerContracts
00029 on Customer.CustomerNumber=CustomerContracts.CustomerNumber
00030 left join work.Contracts on CustomerContracts.ContractNumber=Contracts.ContractNumber;
00031 quit;
00032
00033 %MEND combineddataset;
00034 /** \endcond */


Generated on Friday, 21 March 2014, 11:40:00 by SASUnit SASUnit Version 1.3.0 (320)