topic Re: How to Load image data into SAS in SAS Programming

How to Load image data into SAS

Alice_Jing — Tue, 31 Jan 2023 02:36:42 GMT

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 — Tue, 31 Jan 2023 12:16:13 GMT

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 — Tue, 31 Jan 2023 16:39:53 GMT

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.