Actually - I think that is the pointer to the real problem...   data _null_; date1a= "05JAN2017:09:58:57.822"dt; date1b= 1799229537.822; put date1a=; put date1b=; put date1a= best32.; put date1b= best32.; put date1a= binary64.; put date1b= binary64.; date2a = sum(date1a,-10); date2b = sum(date1b,-10); put date2a= binary64.; put date2b= binary64.; run; Somewhere in the macro variable assignment, BEST12. is being used.  BEST12. will yield a rounded value to 1 place.   I don't see a way to get SAS to not do that; for example, even this won't listen: %Let date1= %sysfunc(sum("05JAN2017:09:58:57.862342"dt),best32.); %put &=date1; Presumably because the conversion happens immediately seeing the constant and resolving it and bringing it into the macro facility.  So you'll have to do a workaround like data _null_ says, or perhaps a bit simpler, %Let date1= 05JAN2017:09:58:57.822; %let date2= %sysfunc(inputn(&date1.,datetime,26)); %put &=date2; (easier if you leave off all the other stuff and just store the date-as-text in date1). ... View more

SGPANEL is what you want to do here, I think.  You can do this easily with a first transpose to get your US/ROW/both into a variable, then PANELBY that variable.   Play with the options some to get headers/etc. exactly what you want them to be.  http://support.sas.com/documentation/cdl/en/grstatproc/69716/HTML/default/viewer.htm#n0wqazuv6959fnn1fask7mi68lla.htm for starters.   data have; input firm_size_num_employees $ US_plus_ROW ROW_only US_Only; datalines; 0 -28.1 45.2 11.0 1-9 19.4 -10.6 -39.0 10-49 65.4 -27.4 -18.8 50-99 -26.5 19.3 -19.3 100-249 18.9 -44.2 18.5 250-499 15.8 62.9 35.0 500+ 17.9 67.2 10.1 ;;;; run; proc transpose data=have out=have_t; var _numeric_; by firm_Size_num_employees notsorted; run; proc sgpanel data=have_t; label _name_ =" "; panelby _name_/columns=3 nowall noborder sort=data; hbarparm category=firm_Size_num_employees response=col1/ group=_name_; run; ... View more

They should know what to do, if you specify that the ODBC connection should include the specific schema you're looking for.  (and, they should be able to figure out what schema you mean if they know what tables you're accessing, so long as those table names aren't used in mulitple schemas)   You might look at https://support.sas.com/techsup/technote/ts765.pdf for more information about schemas (about halfway down the doc).  This also discusses the code KSharp included. ... View more

Use the `Ew.d` format, perhaps?   data _null_; x= 4.59038E-15; put x= E9.2; run; ... View more