taking a single string and converting that to single column in table

[data_null__]

FriedEgg wrote:

I normally do not share code using these 'controversial' functions
 

I looked in Functions and CALL Routines by Category

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000245860.htm

but there was no "Controversial" category.

[FriedEgg]

LOL,

Specifically I was referring to the following ominous piece of the documentation for SAS under the POKE<LONG> Call routine:

CAUTION:The CALL POKE routine is intended only for experienced programmers in specific cases.

If you plan to use this routine, use extreme care both in your programming and in your typing. Writing directly into memory can cause devastating problems. This routine bypasses the normal safeguards that prevent you from destroying a vital element in your SAS session or in another piece of software that is active at the time.  

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000127816.htm

That was very funny though

[data_null__]

Why do you have so much data in a macro variable?  How is the macro variable assigned?  Seems like there are much better places to keep data.