<div>
<div class="content wysiwyg-content">
Experts, 
 
I have a macro that takes multiple rows and puts them into one comma delimited column: 
Example: 
Code &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Color &nbsp; &nbsp; &nbsp; 
&nbsp; 001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red 
&nbsp; 001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Blue 
&nbsp; 001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Green 
&nbsp; 001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Yellow 
Becomes: 
 
001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red, Blue, Green, Yellow 
 
Can anyone tell me how I can take a column that is comma delimited and split the values out to a separate rows: 
Code &nbsp;Lit 
&nbsp;001 &nbsp; &nbsp;Red, Blue, Green, Yellow 
Becomes: 
Code &nbsp; &nbsp; &nbsp; &nbsp;Color 
001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Red 
001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Blue 
001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Green 
001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yellow 
 
I would like to do this in SAS
</div>
</div>

Experts,

I have a macro that takes multiple rows and puts them into one comma delimited column:
Example:
Code              Color      
  001               Red
  001               Blue
  001               Green
  001               Yellow 
Becomes:

001                   Red, Blue, Green, Yellow

Can anyone tell me how I can take a column that is comma delimited and split the values out to a separate rows:
Code  Lit
 001    Red, Blue, Green, Yellow
Becomes:
Code        Color
001           Red
001           Blue
001          Green
001          Yellow

I would like to do this in SAS

Separating data in a comma delimited column into individual rows in SAS

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.