Dynamic Generation of Data Steps动态生成数据的步骤.pptVIP

June 11, 2010 TASS Dynamic Generation of Data Steps on basis of Unique By-Group Permutations Dynamic Generation of Data Steps on basis of Unique By-Group Permutations David Rosenfeld City of Toronto the data the problem a solution the macro the output the conclusion Overview data tass_sample; input division $10. score; label score=Test Score; cards; Division_A 1 Division_B 2 Division_B 8 Division_B 7 Division_B 6 Division_A 5 ; The Data need to export separate worksheets for each division the task has to be repeated every week don’t know which divisions will be in the data file don’t want to hardcode (and have to change) the program every week The Problem dynamically produce the desired datasets use subsetting criteria based on the values of a ‘by’ variable A Solution * Create a Macro to: derived from sample 26140/kb/26/140.html %macro groups(dsn,byvar,export_to); /* First sort the data in order of the */ /* by variable */ proc sort data=dsn.; by byvar.; run; The Macro %macro groups(dsn,byvar,export_to); /* First sort the data in order of the */ /* by variable */ proc sort data=dsn.; by byvar.; run; The Macro /* Then, create a macro variable, VARn, for */ /* each BY-Group and a counter of the number */ /* of new macro variables created. */ data _null_; set dsn. end=eof; by byvar.; if first.byvar. then do; flag+1; call symput(var||put(flag,8. -L),byvar.); end; if eof then call symput(tot,put(flag,8. -L)); run; %macro groups(dsn,byvar,export_to); /* First sort the data in order of the */ /* by variable */ proc sort data=dsn.; by byvar.; run; The Macro /* Then, create a macro variable, VARn, for */ /* each BY-Group and a counter of the number */ /* of new macro variables created.