cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
subrat1
Fluorite | Level 6 subrat1
Fluorite | Level 6

Create two New Variable

Posted 10-09-2020 07:16 AM (2467 views)

HI I have 3 columns Named ad : ID, Country and Segment.   From these 3 columns I want to create two new columns named as "Ïtem" and "Group"..........So when i find "Premier"  then new column Should contain "1" and "Item1"   in new columns.....Please find attached file as an example .   @sasprogramming 

 

 

 

 

 

0 Likes
Reply
2 REPLIES 2
subrat1
Fluorite | Level 6 subrat1
Fluorite | Level 6

Create two new variable

Posted 10-09-2020 07:11 AM (2477 views)  |   In reply to subrat1
 
0 Likes
Reply
LinusH
Tourmaline | Level 20 LinusH
Tourmaline | Level 20

Re: Create two new variable

Posted 10-09-2020 08:09 AM (2430 views)  |   In reply to subrat1

You should be able to describe your inquiry in the post itself, open attachments is not so popular I think.

Data never sleeps
0 Likes
Reply

CFC_SAS_Communities_400x225.jpgCFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

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
  • 2 replies
  • ‎10-09-2020 07:16 AM
  • 2468 views
  • 0 likes
  • 2 in conversation