<div>
This is exactly what I needed. &nbsp;Since there was no need for the rename after using this code.<br />
<br />
Proc transpose data=diags<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;out=dx(drop=_name_ _label_)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;prefix=DX;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; by claim_id;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var diag;<br />
run:
</div>


This is exactly what I needed.  Since there was no need for the rename after using this code.

Proc transpose data=diags
                 out=dx(drop=_name_ _label_)
                 prefix=DX;
          by claim_id;
          var diag;
run:

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have just run this step in SAS. <br />
<br />
Proc transpose data=diags out=dx;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; by claim_id; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var diag;<br />
run:<br />
<br />
My question is once the file is created I can look at it and see how many diag columns were generated. &nbsp;I was just wondering if there was code to give me the results or to combine the next these two steps without manual intervention. &nbsp;The number of columns will vary relative to the data.<br />
<br />
My next step is: (assuming 10 columns were generated)<br />
Data dx_rename;<br />
&nbsp; &nbsp; &nbsp;Set dx rename=col1-col10=dx10-dx1<wbr />0 drop=_name_ _label_);<br />
run;
</div>
</div>


Experts,

I have just run this step in SAS. 

Proc transpose data=diags out=dx;
          by claim_id; 
          var diag;
run:

My question is once the file is created I can look at it and see how many diag columns were generated.  I was just wondering if there was code to give me the results or to combine the next these two steps without manual intervention.  The number of columns will vary relative to the data.

My next step is: (assuming 10 columns were generated)
Data dx_rename;
     Set dx rename=col1-col10=dx10-dx10 drop=_name_ _label_);
run;

Counting the number of columns in a SAS dataset after a proc transpose.

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.

Databases

The Statistical Analysis System (SAS) programs consist of two steps, the DATA step and the PROC step. The DATA step reads data and prepares it for use by subsequent DATA or PROC steps. A SAS procedure (PROC) is a collection of statements that execute a certain task. SAS procedures have their own statements and commands, but many are shared among procedures. JMP is the graphical user interface for SAS, and is used in applications such as Six Sigma, quality control and engineering, design of experiments and scientific research.