Hi Ballardw!
Have already brought the data into SAS?
Yes, the data is already in SAS.
Do you need the original variable with multiple values when done?
Yes, I need, because later I will join the result dataset with another one.
Are there any other variables to consider?
Not now. I just need these two right now.
What to do if the column 2 variable is blank?
There is no blank values in variable 2 because I treated that situation when I was importing the data into SAS.
Should there be any output (remove the record) or have the line basically output as is?
Yes, I need an output just with the 2 variables.
BTW, the image of your example data seems to show a period between the values on the third row. Can that possibly occur?
Actually that is a comma, I want to break the data using that comma.
For example, write the value o var1, if var2 has two values separated by comma, I want to repeat var1 for each value in var2 that are separated.
Thanks for your attention and support! 🙂
Here is the code for sample data:
data sample_data;
input number $ PreExecution $20.;
datalines;
5044 5297,5367
5055 5297,5367,5467
;
LeoGaller
... View more