BookmarkSubscribeRSS Feed
JEET6
Calcite | Level 5

How will create all Variables in one row. .. Like
Site |subjid |race |sex |Date_d |start_date | end_date|.
So i need to create like
Site/subjid/race/sex/site |Date_d |start_date | end_date|.
How???

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Show some example test data (in the form of a datastep) and what it should create, your post is unclear.  You can concatenate strings using functions like cats, catt, or in this case:

result=catx('|',catx('/',v1,v2,v3,v4,v5,v6,v7);

If v1 refers to site, v2 to subjid etc.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 1091 views
  • 0 likes
  • 2 in conversation