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.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 881 views
  • 0 likes
  • 2 in conversation