Note that to display 12:02:27 AM you want to use a TIMEAMPM11. format, else you get the 0:02:27 time. ... View more

You could use a macro approach with %do loops to generate data set nsmed and logic dynamic. But I agree with @Reeza that splitting data usually is not benificial. Reporting and statistical analysis is supported best by bringing data together, not splitting them apart. ... View more

I agree, manipulate this within the original macro to get the desired variable names.  ... View more

One "design reason" is that many procedures have an OUTPUT statement that enables you to create an output data set that contains ALL the input variables AND the created variables. For example, in PROG REG, if you say OUTPUT out=MYOUT P=Pred R=Resid; then the output data set contains all input variables in addition to the predicted and residual variables from the regression. Because the output from one procedure is often used as the input to another procedure, this prevents doing a separate MERGE between procedure calls.   Furthermore, PROC REG is an interactive procedure, so you can specify a model, then execute the RUN statement.  After the model has run, you can specify the OUTPUT statement to get the output data set.  In other words, the procedure does not know when it encounters the first RUN statement whether there will be an OUPUT statement later in the program.   ... View more

ballardw, thank you. I got the error message   ERROR: There are multiple analysis variables associated with a single table cell in the following nesting : category * value * year * value * sum * f.   actually the real data is not year from 2010 to 2016, it is like female2010, female2011, male2010, male2011, trans2010, trans2011, unknow2010, unknow2011   Would you please provide an adjusted code. And there is no need for including ID. Thanks. It is ordered by frequency. that is already done prevoiusly just keep the order ... View more

data want; set have; where datepart(begindt) > '12dec2015'd; run; ... View more

  data have; infile cards dsd; informat id_key 1. process $1. process_date mmddyy10.; format id_key 1. process $1. process_date mmddyy10.; input ID_key x process$ process_date; cards; 1,1,x,01-01-15 1,2,y,02-01-15 2,1,x,03-01-15 ;run; proc transpose data=have out=tran_have(drop=_name_) suffix=_Process_Date; by id_key ; id process; var process_date ; run;   ... View more

What would a full join look like? It looks like a match merge is getting me close to what I need to accomplish but I need a combo of the two variables as a key value can appear more than once (belong to 2 list_names). ... View more

Run the program in EG (right click and run) it will create the output and show it in your process flow. Create your new program or query off the output table. If the table isn't being shown check your preferences to ensure datasets are added to your project. ... View more