when I open my sas file in excel then format hex32. is incorrect in sas file: E7F0DFB3F28A1E7617752FED65B1232F in excel: EFBFBDEFBFBDDFB3EFBFBD1E7617752F just all values are changed to something else any ideas what to check?
My recommendation would be to convert the data to a character variable containing the formatted hex values, and provide that dataset for opening in Excel.
You have to keep in mind that the COM connection and the AMO transfer raw values, and you might have numeric or character conversions happening during that.
With EG we have also noticed that character variables that contain a 00x are cut off at that point; this is most probably due to the fact that many programming languages consider 00x to be a end-of-string marker.
$HEX32. makes me suspect you are working with UUID strings. In that case I'd recommend to convert to the standard 36-character UUID notation before the data transfer.
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.