Hello,
I have a quick question
I have a table which looks like below
SEQ MODE TYPE assign_value
1 m x a, axau
1 m y a,axau
1 m z m, x, n
.....
I would like to get the following such that assignvalue which is separated by commas creates a duplicate row for each assign_value value which is separated by commas
SEQ MODE TYPE assign_value
1 m x a
1 m x axau
1 m y a
1 m y axau
1 m z m
1 m z x
1 m z n
.....
many thanks for your help
Hi,
data want (drop=i old); set have (rename=(assign_value=old)); length assign_value $100; do i=1 to countw(old,","); assign_value=scan(old,i,","); output; end; run;
Hi,
data want (drop=i old); set have (rename=(assign_value=old)); length assign_value $100; do i=1 to countw(old,","); assign_value=scan(old,i,","); output; end; run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.