PG - I seem to learn something new from you almost every day... Thx for the technical contribution.... ... View more

Hello,   Here is another way with PROC SQL....   data in; input y:4. m:2. claims:3. ptf:8.; cards; 2014 01 575 250555 2014 02 555 251555 2014 03 501 252256 2014 04 556 252222 2014 05 587 253000 2014 06 595 253599 2014 07 459 254568 2014 08 531 254998 2014 09 598 255998 2014 10 358 256687 2014 11 589 257169 2014 12 456 258859 2015 01 598 259589 2015 02 433 264210 ; run; data in; set in; c1=lag1(claims);c2=lag2(claims);c3=lag3(claims); p1=lag1(ptf); p2=lag2(ptf); p3=lag3(ptf); proc sql; select y,m,claims,ptf,(( claims+c1+c2+c3)/(ptf+p1+p2+p3)) as myratio from in; quit; Good Luck...!!! ... View more

Here is an example that might help you....   Unix Shell Code called "sasparm.sh"   sas sasparm.sas -sysparm "$1" Your SAS program code called "sasparm.sas"   options mlogic mprint symbolgen; %let var1="&sysparm"; data in; input_value=&var1; run; When you invoke the script, you may invoke like this in the command line...   sasparm.sh filename Good Luck...!!! ... View more

 If you're reading a flat file, as Tom mentioned in his post, the TRUNCOVER option can help. However, if you are bringing in a couple of SAS datasets and if you need to have a set of variables in your output dataset, then you're better off in creating an empty dataset and using it as a template along with the other datasets that you are reading in which may or may not have your required variables, so you know for sure that you will have those variables coming from the template  in your output.    Hope this makes sense.    Good Luck...!!! ... View more

Here is a simple check that might be easy to understand.  Good luck to you...!!!   Data check_year; do year_value = 2000 to 2016; length leap $3; leap='no'; If mod(year_value,4)=0 then leap='YES'; If mod(year_value,100)=0 and mod(year_value,400) ne 0 then leap='NO'; output; end; Run; proc print noobs; var year_value leap; run; Here is the result of the code for your reference:    year_value leap 2000 YES 2001 no 2002 no 2003 no 2004 YES 2005 no 2006 no 2007 no 2008 YES 2009 no 2010 no 2011 no 2012 YES 2013 no 2014 no 2015 no 2016 YES   Here is some more literature from where I got the calc....  http://support.sas.com/kb/44/233.html   ... View more