Also, my solution assumes there is a dz_date. ... View more

I took a guess at what output you wanted but here is a solution.    data have; infile cards dsd; informat pid $3. test_date dz_date mmddyy10.; format pid $3. test_date dz_date mmddyy10.; input PID     test_date     dz_date; cards; 101,4/1/2013, 101,8/22/2013, 101,11/10/2013, 101,,6/18/2013 102,2/11/2013, 102,8/14/2013, 102,12/23/2013, 102,,2/4/2014 203,6/21/2013, 203,,2/5/2013 ; proc sort data=have;by pid test_date dz_date; data prep; set have; by pid; retain date; if not missing(dz_date) then date = dz_date; test = abs(intck('month',test_date,date)); drop date; run; proc sql; create table want as select distinct pid, case when min_test < 4 then '1' else '0' end as BiVar from( select *,min(test) as min_test from prep group by pid); ... View more

  data want; set have; new_field = cat('T',_N_); run; ... View more

data table; infile cards; input Product$     Week     Store_1     Store_2     Store_3; cards; 1     1     44     88     68 1     1     57     65     14 1     1     3     35     37 1     2     48     100 58 1     2     81     9     39 1     2     19     17     13 ; proc summary data=table; var store:; by product week; output out=want(drop=_type_ _freq_) mean=; run; ... View more

What you are describing sounds like the log summary in Enterprise Guide.  If you have the new version go to 'view' and select 'log summary'.  It is a new feature and will not be available with older versions. ... View more

Here is another solutions:   data  have; infile cards; input  address $25.; cards; 38b Elgin road Kolkata-30 25 Main St Pittsburgh PA ; run; data count; set have; count+1; if missing(address) then count = 0; run; data prep; set count; by address notsorted; %macro lag;     %do i = 1 %to 5;         lag_address_&i = lag&i(address);     %end; %mend; %lag; run; data prep2; set prep; %macro deletes;     %do i = 1 %to 5;     %let j = %eval(&i+1);     if missing(lag_address_&i) then call missing(lag_address_&j);     %end;     %mend;     %deletes; run; data want; set prep; if count = 0 then do; address2 = catx(' ',of lag_address_5-lag_address_1); end; run; ... View more

you should use datepart()   date = datepart(DDMMMYYY:00:00:00)   These are not special characters, sas views this as a time and is formated to display date and time.  Datepart() will drop the time. ... View more