BookmarkSubscribeRSS Feed
Ranjeeta
Pyrite | Level 9

Hello,

 

I would appreciate some advice on how I can add or attach the two columns Service Detail 1 and Service Detail 2 from the vas_code_test dataset  into the vas_1819_sum_test dataset 

 

Thanks

3 REPLIES 3
RichardDeVen
Barite | Level 11

The SUM_TEST invtervention code 1KY76 matches 5 different CODE_TEST rows on KCCI_CODE_new, each having different ServiceDetails.

 

What do you want added to SUM_TEST ?

  • 5 new rows for each CODE_TEST with 1KY76
  • The Service Details from the first CODE_TEST row?
  • 10 new columns ? Ie. the Details1&2 from each of the CODE_TEST rows ?

 

 

 

Ranjeeta
Pyrite | Level 9

I woanted option 3 but i will close this track now as there is some info missing from the business side

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 425 views
  • 0 likes
  • 3 in conversation