I have the following dataset   data have; input date_of_birth; datalines; 19600101 190002.. 200002.. 199812.. ; run;   I want to write a program that will create a new dataset, that replaces ‘..’ by the last day of the respective month. Note: I also want to account for leap years. Therefore, for the 2nd value (190002..), I would want this to read 19000229 because this is a Leap Year Appreciate all help! ... View more

I have the following dataset   data have; input profit; datalines; 52 34 60 57 70 ; run;   I want to write a program that will create a new dataset, only containing the difference between the first and last observation? In this case the code would show 70 (last observation) - 52 (first observation), so the output would be 18.     ... View more