To do the conversion with the datetime informat, you need a colon between the date and the time, e.g.: newdatetime=input(put(sasdate,date9.)||':'||put(time,time.),datetime.); or you can use the dhms function: newdatetime=dhms(sasdate,hour(time),minute(time),second(time)); Date values are the number of days since 01JAN1960. Datetimes are the number of seconds since 01JAN1960:00:00:00. So another possibility is to turn the number of days into seconds and add it to the time: newdatetime=sasdate*24*60*60+time; ... View more

When I submit any of your programs, I get all "equal" messages. I am running on a Windows 64 bits platform, SAS 9.4 TS Level 1M4. ... View more

The differences are rather small, I think the reason they are there is this: SAS uses 8-byte real numbers. The Intel/AMD numeric processor works with 10-byte real numbers. When you call DIVIDE, the division is performed in 10-byte reals, the result is returned as an 8-byte real, and that is again converted to a 10-byte real before the division with 100. When you it with the divide operator, the whole thing, including the division by 100, is done in 10-byte reals before the result is returned to SAS as an 8-byte number.   My guess is therefore that what you get with the divide function call is the same as you would get with chg2=(aval-base)/base; chg2=chg2/100; If you dropped the division by 100, the two values would probably also be the same.   If by "other environments" you mean mainframes, they process 8-byte reals in the numeric processor, so there should not be any differences. ... View more

Obviously, your "finaltest" data set will always be empty when you run this code, because of the last couple of statements: data finaltest; run; ... View more

One possibility is to use keyed access, something like this: proc sql; create index idx on have(roll_number,ref_period); quit; data want; set have; year_ago=ref_period-100; /* or use intnx if your variable is date type */ month_ago=ref_period-1-88*(mod(ref_period,100)=1); set have(rename=(final_price=year_old_price ref_period=year_ago)) key=idx; if _iorc_ then */ no record found */ _error_=0; else pct_chg_year=(final_price-year_old_price)/year_old_price; set have(rename=(final_price=month_old_price ref_period=month_ago)) key=idx; if _iorc_ then */ no record found */ _error_=0; else pct_chg_month=(final_price-month_old_price)/month_old_price; format pct_chg: percent5.2; run; If your ref_period variable is date type, make sure that all the dates are standardized (e.g. to the first daty of the month). ... View more