If you are subtracting beginning price from end price here you go:   data have; infile cards dsd; input Cusip$ Months$ price; cards; 111111,1985 Aug,2.05 111111,,, 111111,1990 Jul,5.36 100000,1985 Aug,5.8 100000,, 100000,1990 Jul,8.6 ; data prep; set have; if not missing(months) then do; _month = month(input(put(cats('01',scan(months,2,' '),2015),$9.),date9.)); end; _year = scan(months,1,' '); run; proc sort data=prep out=prep2;by cusip _year _month;where not missing(months); data want; set prep2; retain _begin; by cusip _year _month; if first.cusip then _begin = price; if last.cusip then _end = price; return = _end-_begin; drop _:; run; ... View more

Here's something to get throught he redundancy.  I haven't gone through the rest, a little explanation of what you have and what you are trying to achieve would be helpful:   data om1976; set om (keep=name cusip ticker OM1976); year=1976; om=OM1976; newom=input(om,8.); drop om; rename newom=om; run; data om1977; set om (keep=name cusip ticker OM1977); year=1977; om=OM1977; newom=input(om,8.); drop om; rename newom=om; run; %macro first; %do i = 1978 %to 2013; data om&i; set om (keep=name cusip ticker OM&i); year=&i; om=OM&i; run; %end; %mend; %first; /*I would wait to do this drop until after you have it all together, that way you can drop OM:*/ /*I would also wait to sort until everything is combined*/ %macro two; data om_mv; set %do i= 1976 %to 2013; om&i %end;; run; %mend; %two; proc sort data=om_mv;by ticker year; ... View more

This gets the solution you are looking for, edited for length and rename:   data want; length arrears_band $10.; merge have_1 (in=a)            have_2 (in=b rename=(post_date=Current_date Net_Write_off_total_USD=balance)); by account_number bank_number; if missing(arrears_band) then Arrears_Band = 'Write Off'; run; ... View more

I'm not sure if this is what you are asking or not, see if this helps:   proc sql; create table dictionary as select * from dictionary.columns where libname = 'libname_here'; ... View more

You should give an example of the data you have.  An another example of what you want your output to look like.  The way you have it written isn't correct and it's hard to guess what you are trying to do. ... View more

If it has to be an underscore you have a solution above, but it will not be a date field.  If a slash helps this will work and it maintains being a date field for calculation:   data have; infile cards; informat date mmddyy10.; format date mmddyy10.; input date; cards; 09/09/2015 ; run; proc sql; create table want as select date,date as date2 format=yymms5. from have; ... View more

Here you go:   data have; infile cards dsd; input date; informat date mmddyy10.; format date mmddyy10.; cards; 09/09/2015 ; data want; set have; date2 = date; format date2 yymmn4.; run; ... View more

Here is a solution for you: data have; input HHID RespID SpouseID  Couple  'Respondent(Fin resp)'n  'Spouse(Fin Resp)'n; cards; 20       2020      2010         1                 1                               0 20       2010      2020         1                 0                               1 10       1010      0            0                 1                               0 30       3010      3020         1                 1                               0 30       3020      3010         1                 0                               1 ; data want rest; set have; if couple = 0 then output want; else if couple = 1 and 'Respondent(Fin resp)'n = 1 then output want; else output rest; run; Go Pirates ... View more

It's kind of hard to guess what your data looks like without an example.  You'd be better off adding a small sample of what you have and again what you want: data have; input hhid$ person$ head$; cards; 01 lammar 0 01 sally 0 01 renoldo 1 02 Judy 1 02 Leroy 0 02 Jane 0 ; data responsible not; set have; if head = 1 then output responsible; else output not; run; ... View more

No idea, it's in my output.  You 'd have to provide your code for any additional help.  A little note, you didn't mention that anywhere in your initial post.  ... View more

Pretty crude and specific but here is a solution.  Won't work for any broader examples. data want2(keep=a b c); set have; count + 1; retain c; b = 'MM'; if a = 'MM Regional Calls' then count = 0; if count = 4 then count = 1; if count = 1 then c = a; if 4<=_N_<=48; run; Go Pirates ... View more