<div>
<div class="content wysiwyg-content">
I have a group of fields in a SAS input dataset. &nbsp;When trying to transpose the fields I get an error message that the fields do not have a numeric suffix. &nbsp;The fields are concatenated one next to the other. I have 33 fields in total. &nbsp;What is the most efficient way to transpose these fields. An example of the names are p_q2a p_q2b p_q2c etc.
</div>
</div>


I have a group of fields in a SAS input dataset.  When trying to transpose the fields I get an error message that the fields do not have a numeric suffix.  The fields are concatenated one next to the other. I have 33 fields in total.  What is the most efficient way to transpose these fields. An example of the names are p_q2a p_q2b p_q2c etc.

Transposing variables in an input file in SAS that do not have numeric suffix

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.