Haikuo and PGStats, thank you, you both were very close to what I needed. Haikuo--I like that I was able to use yours without defining the lengths ahead of time--although I am still checking to make sure there was no truncation due to something I missed. And it is a little frustrating to have to essentially take this long variable out of the dataset, parse it, and transpose it, and join it back to the original dataset. But it is possible, since I have a unique ID to transpose by. Astounding......I am intrigued by your option, and I will see if I can apply at least the first part. I had tried assigning a macro variable via call symput (using a countc of ; and : ) and applying that to the array statement, but SAS was pretty insistent that I could not use the macro variable in setting up the array---but it may have been the way I was applying it. The lengths of the numeric parts don't matter (as long as the entire number comes in), in the end I will be inputing them to numeric variables. And the character variables need to be large enough to accommodate whatever text ends up being pieced into them--so as dynamic as possible. And yes, I want the data to appear as in the diagram--simply var1-varx, with the text followed by the number. This has to do with the type of analysis that it will be used for down the road--a job exposure matrix, where we need the department and time spent on one line associated with a specific employee. Thank you all!!!!!
... View more
![SASGF 2020 [Virtual] Attendee](/html/@A53A708409112314CE528E074D4C8C1F/badge_icons/badge_sasgf20_attendee.png "SASGF 2020 [Virtual] Attendee"){kind=icon}
