topic Re: SAS Excel Plug-in - hex32 format in Microsoft Integration with SAS

SAS Excel Plug-in - hex32 format

AndresVeer — Tue, 22 Nov 2016 15:26:35 GMT

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?

Re: SAS Excel Plug-in - hex32 format

Kurt_Bremser — Tue, 22 Nov 2016 18:03:38 GMT

Do you use the Add-In for MS Office, or do you export from SAS to a Excel format?

Re: SAS Excel Plug-in - hex32 format

AndresVeer — Wed, 23 Nov 2016 08:03:59 GMT

I use the Add-In for MS Office, just browsing in metadata sas file and open it and then in excel this hex32, format column changes,

Re: SAS Excel Plug-in - hex32 format

Kurt_Bremser — Wed, 23 Nov 2016 08:16:36 GMT

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.