How to Load image data into SAS

[Alice_Jing]

Hi Team, 

I'd like to load MSSQL data to SAS datasets, however there's a image format data entries as below highlight, any idea on it? 

Thanks.

[Patrick]

At least with SAS 9.4 there is no matching data type that would allow you to store a mssql image(16) column. 

...but: Given this source column got only a length of 16 the question is "what's in it" and "what do you need it for"?

Depending on content and/or intended use you could eventually cast() it to a data type like varchar() that then can get mapped to a SAS data type.

And what Microsoft says:

[Sajid01]

SAS 9.4 does not have an image format. However the images can be stored into a folder and the dataset can store the path of the image.