BLOB data type

Reply
Not applicable
Posts: 0

BLOB data type

Is the BLOB data type available in SAS Base? I am trying to concatenate patient notes for multiple records. For example, a patient has 50 records, each with a clinical note that may be up to 40K characters. If I combine all notes into one record then I could have up to 400K characters. I have written a program in VBA to do this but I am running into a field size issue. Can I use the BLOB data type to combine a patient's multiple notes into one note? Thanks.
Super User
Posts: 5,876

Re: BLOB data type

Posted in reply to deleted_user
There is no actual BLOB data type in Base SAS, but is has been considered for SPDS. You can read BLOB data types from external RDBMS, but the SAS/ACCESS engine will convert them into char variables. Since the maximum length for char in Base SAS is 32K, I guess you have to split your data into several rows/columns. Apart from that, you have an observation lenght limit to handle: 2GB.

/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 791 views
  • 0 likes
  • 2 in conversation