/*====================================================================*/ /* PROGRAM : NIS_Trends_Supplemental_Merge_Driver.sas */ /* TASK : Call macro to import NIS Trends Supplemental Files and */ /* merge to previously created NIS data set. */ /* DATE : 09/11/2006 */ /* PURPOSE : Create new merged data set with additional NIS Trends */ /* Supplemental variables for each previously created NIS */ /* data set created by year. */ /*====================================================================*/ /*====================================================================*/ /* INSTRUCTIONS: Create or copy the NIS Trends Supplemental file */ /* into same location as the core data file. */ /* Update the macro variables year_, corepath_, */ /* corename_, mrgpath_, and mrgname_ . Update the */ /* include statement to the path of the macro program. */ /* Run this driver program. */ /* INPUTS : */ /* year_ - NIS project year. */ /* corepath_ - Folder path location of transport file. */ /* corename_ - Name of current core data set. */ /* mrgpath_ - Folder path location of resulting merge file.*/ /* mrgname_ - Name of resulting merged data set. */ /* OUTPUTS : */ /* SASDATA - Merged data set with NIS Trends Supplemental */ /* data. */ /*====================================================================*/ Options source2 mprint macrogen compress = yes OBS = MAX ; %LET year_ = 1988; * Update year value to year of NIS files to be merged; %LET corepath_ = C:\NIS\&year_.\SASDATA; * Update to path location of current core data set; %LET corename_ = NIS_CORE_&year_.; * Update to name of current core data set; %LET mrgpath_ = C:\NIS\&year_.\SASDATA\Trends_Supplemental; * Update to location to output the merged data set; %LET mrgname_ = NIS_Trends_Supplemental_&year_.; * Update to new name of output merged data set; %INCLUDE "C:\NIS\PGMS\NIS_Trends_Supplemental_Merge_Macro.sas"; * Update to location of the macro program; %NIS(&year_.,&corepath_.,&corename_.,&mrgpath_.,&mrgname_.); RUN;