If something comes through in the correct dataset as missing how is it shown,  How do you know something should be 'correctly' missing? ... View more

Not sure what you want the second part to look like but this might get you there.  This takes care of 1 and 2: data have; infile cards dsd; length date $10.; input date$; cards; 01_01_2015 ; run; data want(rename=(date2 = date)); format date2 mmddyy10.; set have; date2 = input(put(tranwrd(date,"_","/"),$10.),mmddyy10.); do i = 1 to 50; count + 1;output; end; drop date i; run; ... View more

I have a start here but I'm not sure what you are trying to do. data have; infile cards dsd; informat date date9.; format date date9.; input Unit$ Date Part$ Qty_used ; cards; 345,01jan2014,5d3423,5 2034,23feb2015,6t5453,10 ; run; data have2; infile cards dsd; input Year Part$ Expected_Qty_used; cards; 2015,5d3423,400 2015,6t5453,700 ; run; proc sql; create table start as select a.*,b.year,b.Expected_Qty_used from have a left join      have2 b on a.part = b.part; ... View more

Are you referring to the P value or is there another value that is significant for your purposes?  I'm not sure I"ll be able to help much more.  ... View more

If all you want is the difference between the two averages this will get you there.  I'm guessing more information is valuable you can tweak the code.  Let me know if this helps: data have; infile cards; input year ratea; cards; 2012 2.5 2013 5.6 2014 5.9 ; run; data prep; set have; by year; lratea = lag(ratea); diff_ratea = ratea-lratea; run; proc sql; create table part1 as select *,avg(diff_ratea) as avga from prep; data have2; infile cards; input year rateb; cards; 2012 1.7 2013 4.7 2014 0.7 ; run; data prep2; set have2; by year; lrateb = lag(rateb); diff_rateb = rateb-lrateb; run; proc sql; create table prep_diff as select *,avg(diff_rateb) as avgb from prep2; proc sql; create table want as select distinct a.avga-b.avgb as avg_diff from  part1 a inner join       prep_diff b on a.year=b.year; ... View more

Here is a solution for the first part.  If there is more than one record per year you would add group by year at the end.  In this solution it's the average of every year. data have; infile cards; input year rate; cards; 2012 2.5 2013 5.6 2014 5.9 ; run; data prep; set have; by year; lrate = lag(rate); diff_rate = rate-lrate; run; proc sql; create table part1 as select *,avg(diff_rate) as avg from prep; ... View more

Two things to point out.  You your length assignments are incorrect and you are only loading one column when you have three. Hope this helps: data have; infile datalines dsd; length policynumber1 policynumber2 policynumber3 $10.; input policynumber1$ policynumber2$ policynumber3$; datalines; m2227eqw,wy3747387,hsdahah schaxnbbxc,, 847e7w87,, 47ew7837,, ds6778989,, fg848484,rt222222,y72378w ; run; proc sql; create table want as select sum(count(policynumber1),count(policynumber2),count(policynumber3)) as count from have; ... View more

This seems like a lot for your purpose but I'm sure it'll work.  If it's a large dataset I'd put in a where clause too.  Scan() will separate by the blank you want to keep and catx() will strip each variable but use the space as a deliminator. Hope it helps: data have; infile cards dsd; input char $; cards; abc 25 spc 26 xy 20 ; run; data want; set have; cchar = scan(char,1,''); nchar = scan(char,2,''); if _N_ => 1 then do; new_var = catx(' ',cchar,nchar); end; run; ... View more