Yes,  you are right ! i didn't see the etc,..one i thought its only few  ... View more

Use variables selection in the order you want after the final merging data.   Like   Proc sql; create table final_order as select Patient_id, admitDate1, DischargeDate1, admitDate2, DischargeDate2 from Discharges.DetailFinal ; quit;   ... View more

I agree with @novinosrin  to use proc format to store the values and use it any time you want . when it comes to pull the data in dynamic way i usually prefer to store them in macro variables , so i can pull the data dynamically irrespective of the number of observations and the data in it.    proc sql; select count(1) into :cnt from have; run; %let cnt= %sysfunc(compress(&cnt.)); %let i=1; Proc sql; select myvariable into :a&i. - :a&cnt. from have; quit; %put a1= &a1. a2= &a2. a3=&a3. a4=&a4. ; #and so on .. ... View more

I agree with @Kurt_Bremser , and still if you want to combine three SQL tables and put it together and generate ODS results use proc append procedure and close the macro .  use the new data set in your ods results.   Proc append base=New data=SMCD_PD_&fileyear&filemth. ; run;   i hope it helps!       ... View more

Hello,   as in the attached document , it is the value of column "how" which is adding after each category .   Its like  Total &category. , if the category value equals "Digital" then dynamically it will allocate the value as "Total Digital" otherwise  you may need to hard code the value which will appear  after all categories.     Thanks Vish ... View more

you have to create stored process  with input parameters as you required.  Refer to stored process guide ... View more

Pass a parameter by creating a macro variable.   data _null_; call symput('prev_month_end',put(intnx('month', today(), -1,'e'), date9.)); /*replace date9. format with your required format. */ run; ... View more

Try this:   %macro State (year, DName,combined_sample); %do number = 1 %to 10;   data i&year ; set &combined_sample.; where interview='1';   where decile_equiv_inc=&number; run; *title &Year &number; *proc means data=i&year median mean ; *class decile_equiv_inc; *var measure_error_tot measure_error_disp; *by decile_equiv_inc; *output out=analysis_&year median= measure_error_tot_1 measure_error_disp_5 ; /*run;*/ %end;   /*data h; set analysis_2013 analysis_2014 analysis_2015 ;run;*/ *proc sort data=i&year ; *by decile1;   　 proc means data=i&year median mean sum ; where interview='1';   weight euroweight; var eq_inc1nat eq_inc1nat_admin eq_totinc_survey eq_totinc_admin; by decile_equiv_inc var ; output out=med_inc_state_&year. ;   median= eq_totinc_survey_median eq_inc1nat_median eq_totinc_admin_median eq_inc1nat_admin_median mean= eq_totinc_survey_mean eq_inc1nat_mean eq_totinc_admin_mean eq_inc1nat_admin_mean sum= eq_totinc_survey_sum eq_inc1nat_sum eq_totinc_admin_sum eq_inc1nat_admin_sum; run; data med_inc_state_&year.; set med_inc_state_&year.; year=&year.;   proc append base=analysis data= med_inc_state_&year. force;   run; %mend State; %State (2013,i2013,combined_sample_2013_7); %State (2014,i2014,combined_sample_2014_7); %State (2015,i2015,combined_sample_2015_7);   ... View more

replace the below code: data analysis; set med_inc_state_2013   med_inc_state_2014 med_inc_state_2015;run;     with this code:   proc append base=analysis data= med_inc_state_&year. force; run;   Thanks, Vish ... View more

I think its because of missing '.' .use &x. if not resolved try to see other options if the macro variable "X" is declared outside of macro and you are trying to invoke that within a macro. ... View more

complete  macrotized code, based on the run date you mention or today's date it will pick the dates as you mentioned and create the data. see if this is helpful.   data _null_; call symputx('run_dt',compress(put(intnx('day',today(),0),yymmn6.)));/*Start date--use %let run_dt=value if want other dates*/ call symputx('dtp6mon1',compress(put(intnx('month',today(),-6),yymmn6.))); /*6months previous date to current date**/ call symputx('dtp6mon2',compress(put(intnx('month',today(),-12),yymmn6.)));/*6months previous date to dtp6mon1...**/ call symputx('dtp6mon3',compress(put(intnx('month',today(),-18),yymmn6.))); call symputx('dtp6mon4',compress(put(intnx('month',today(),-24),yymmn6.))); call symputx('dtp6mon5',compress(put(intnx('month',today(),-30),yymmn6.))); call symputx('dtp6mon6',compress(put(intnx('month',today(),-36),yymmn6.))); run; %put run_dt=&run_dt.; %put dtp6mon1=&dtp6mon1.; %put dtp6mon2=&dtp6mon2.; %put dtp6mon3=&dtp6mon3.; %put dtp6mon4=&dtp6mon4.; %put dtp6mon5=&dtp6mon5.; %put dtp6mon6=&dtp6mon6.;   data new; set s_&dtp6mon6. s_&dtp6mon5. s_&dtp6mon4. s_&dtp6mon3. s_&dtp6mon2. s_&dtp6mon1.; run;   Thanks, Vish ... View more

Try this.   %macro all(dt,dt1);   data new_&dt1.; set sample.new_&dt.;   run; proc append base=sample.new_sum data= new._&dt1. force;   run; %mend; %all(201501,201502); %all(201502,201503);   ... View more