Hi, could you try this, please (I added a 'd' at the end of your "dt" variable (see in red) data temp; curr_date = "10Mar2013"d; first_day_prev_month = intnx('month',curr_date,-1,'B'); last_day_prev_month = intnx('month1',curr_date,-1,'E'); call symput('dt', "'"||put(first_day_prev_month, mmddyyd10.)||"'d"); call symput('dt1', "'"||put(last_day_prev_month, mmddyyd10.)||"'d"); format curr_date first_day_prev_month last_day_prev_month mmddyyd10.; run; proc sql; connect to Access as db (path="T:\CCMS Production\CCMSProduction.accdb"); create table Dep as select * from connection to db (select * from [tbl_depositcompliance] where tbl_depositcompliance.Scheduled_Settle between &dt. and &dt1. ); quit; Let me know if this works. Good luck Anca. ... View more

Can it be like this? ID          TEXT_3 001        aaaaabbbbb 002        cccccddddd then: text_3 = compress(text_1,text_2); or do you want it like this? ID          TEXT_3 001        aaaaa 001        bbbbb 002        ccccc 002        ddddd proc transpose data = in out = want;     by id;     var text_1 text_2; run; data really_want;     set want(rename = (col1 = text_3 ) drop =  _NAME_); run; ... View more

Thank you, Pierre. It worked great. It was the format.... Thanks! ... View more

I shall try, and let you know. Thank you! ... View more

Hi. So, in the first step there is a proc means on the data, by year, that will list the average of a variable for each year. That said average is then plotted. So, the format is a number. ... View more

Thanks! ... View more