It doesn't work because those are SQL functions, not SAS functions. Find the relevant SAS functions. A SAS datetime is defined as the number of seconds from January 1, 1960.  So exactly how your variable is stored is important. Some functions to consider: intnx intck input put datepart month/year/day timepart ... View more

Try adding style(header obsheader)=[fontsize=12] to the proc print statement. It works on all ODS destinations except Listing or Output. PG ... View more

datepart() -> converts DATETIME variables to date variables year()-> extracts year from date variable month()-> extracts month from date variable YYMMN6. format will change the format from date9. (01Jan2012) to 201206. format your_date yymmn6.; ... View more