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 */ |