Data task; Input ID ONum notes & $ 30.; cards; 11 10001 This is a Test 11 10001 of SAS 11 10002 Today the weather was good 11 10002 Busy Shopping 44 19999 Fishing 55 77777 Working on car 55 77777 Hunting 55 77777 Swimming ; run; Data task_final; retain id onum ; length new $ 50; do until (last.onum); set task; by onum; new=catx(" ",new,notes); end; Keep ID ONum new; run; ... View more

I run many batch jobs for various time periods. Here is a typical data step to create two macro variables for the start and end of the previous week; data date_parms;   analysis_date=today();   date1=intnx('week',analysis_date,-1);   date2=intnx('week',analysis_date,-1,'end);   call symputx('start_date',date1);   call symputx('end_date',date2);   format analysis_date, date1 date2 date7.;) run; &start_date and &end_date are macro variables for the start and end of the previous week. If you need to rerun the program for a prior week you just need to change the analysis_date to a prior week. ... View more

This is a problem that I have had to deal with so many times (most frequent defect) that I built a macro. Purpose is to identify the most frequent value of a variable for each classification variable. The output is a data table. For your example the usage would be: %freq_class(dsnin=data_table_name, var=death_date, class=id, dsnout=death_dates); %macro freq_class(dsnin=, var=, class=, dsnout=); /* dsnin = input data set name */ /* var = variable to analyze */ /* class = classification variable */ /* dsnout = output data set name */ proc freq data=&dsnin noprint; tables &var*&class /norow nocol nocum nopercent out=&dsnout; run; proc sort data=&dsnout; by &class descending count; run; data &dsnout; set &dsnout; by &class; if first.&class; run; %mend; ... View more

Documentation for Style Editor can be found in the SAS Help and Documentation: - SAS Products - SAS/GRAPH - SAS/GRAPH 9.2 ODS Graphics Designer User's Guide: - Changinfg Appearance of a Graph - Customizing Graph Styles. ... View more

Thanks Matt! I'll massage all the input that I've received, into a template and then send it to you Matt for you to post here. Thanks again. See most of you in Seattle I think. -Joel ... View more

Hi Matt, As far as I know we have at least four, possibly five people from the University of Victoria (two from our Computing Systems dept and at least two of us from Institutional Planning & Analysis) who will attend this year's Global Forum. Cheers, Cheryl ... View more

That would be great, Rup: once you have time, of course! I'd like to try and plan out a series of EG-based mini-talks/workshops, especially at TASS which has now focused some attention very directly on EG. ... View more

I recommend searching the SAS support http://support.sas.com/ website however instead of blackberry, consider using a less-specific search argument such as the ones below: wireless device reporting wap reporting solution I believe you will find technical papers on this topic. Scott Barry SBBWorks, Inc. ... View more