BookmarkSubscribeRSS Feed
AKHILA
Obsidian | Level 7

 

 

Hi all ,

i have a dataset with two variables. i want to merge two columns into a single one such that the second column will be subgroup for the first.

 

 color$            flower$;

yellow
red
red                 rose
yellow
white             jasmine
white             lilly
red
white
i want my final dataset to look like this ;
yellow
red
    rose
white
    jasmine
    lilly

please help...

1 REPLY 1
PeterClemmensen
Tourmaline | Level 20

Do you want this in a data step? And Why?

 

Also, I don't understand the form of your result data. Please be more specific.

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 593 views
  • 1 like
  • 2 in conversation