SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

SAS Excel Plug-in - hex32 format

Reply
New Contributor
Posts: 2

SAS Excel Plug-in - hex32 format

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? 

Esteemed Advisor
Posts: 5,920

Re: SAS Excel Plug-in - hex32 format

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 2

Re: SAS Excel Plug-in - hex32 format

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,

Esteemed Advisor
Posts: 5,920

Re: SAS Excel Plug-in - hex32 format

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Post a Question
Discussion Stats
  • 3 replies
  • 161 views
  • 0 likes
  • 2 in conversation