SAS: TRANSPOSE without using PROC TRANSPOSE?
<p>I have SAS data like this.</p>

<pre><code>dog cat mice camel pigeon cow goat fish horse donkey monkey lion rat
DOG CAT MICE CAMEL PIGEON COW GOAT FISH HORSE DONKEY MONKEY LION RAT
</code></pre>

<p>Non-capital name is column names. And Capital letters are observations.</p>

<p>And I want to make a table like below WITHOUT using PROC TRANSPOSE function. Column names are AnimalName and LastAlpha. The LastAlpha is the last alphabet for the AnimalName observations.</p>

<pre><code>AnimalName LastAlpha
DOG        G
CAT        T
MICE       E
CAMEL      L
PIGEON     N
COW        W
GOAT       T
FISH       H
HORSE      E
DONKEY     Y
MONEKY     Y
LION       N
RAT        T
</code></pre>

<p>I was attempting using ARRAY function to make this table, but no luck. I would appreciate if you could help.</p>