Hi I have a varibale called "Chosen" that is populated with strings, either "Plane" "Auto" or Transit".
I want to create a new column with the first string in the "Chosen" repeated 3 times, the second string repeated 3 times and so on.
Thanks in advance
Hi,
Its a good idea to post test data, in the form of a datastep and what the output should look like. Here I am I am guessing what you have/want:
data have; chosen="Plane"; output; chosen="Auto"; output; chosen="Transit"; output; run; data want (drop=i); set have; do i=1 to 3; output; end; run;
Hi,
Its a good idea to post test data, in the form of a datastep and what the output should look like. Here I am I am guessing what you have/want:
data have; chosen="Plane"; output; chosen="Auto"; output; chosen="Transit"; output; run; data want (drop=i); set have; do i=1 to 3; output; end; run;
Thanks will do next time
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.