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.
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:
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.