This is my code. I am unable to calculate today and days. It's not printing anything. What format do i need to use ? proc report data=profile (where=(state in('NY' , 'CA'))); column Acct_ID Name today days Birthday Age Sex State Cust_Type Product Balance Last_Tran_Date; define state / order; define Acct_ID / order width=6; define Name / order "Name" width=5; define today /computed format= date9. ; define days / computed format=mmddyy10. ; define Birthday / order format=mmddyy10. ; define Sex / order noprint; define Cust_Type / order noprint; define Product / order noprint; define Age / computed format= mmddyy10.; Define Balance / order width=5; define Last_Tran_Date / order format=mmddyy10.; compute after today; today = date(),anydtdte.; endcomp; compute before days; days = today - Birthday; endcomp; compute before Age; Age = floor(days / 365); endcomp; /*BREAK AFTER Balance / SUMMARIZE;*/ run; quit;
... View more