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? 

Alice_Jing_0-1675132584498.png

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:

Patrick_0-1675167306907.png

[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.