BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
fconerj
Calcite | Level 5

Hello! I'm starting with sas base and I have a question.

 

I'm not able to find the way to create a new column which categorizes different words form other column in the same dataset.

I need to create a column (named category) with 3 different variables: "Clothes", "Bags" and "Other". So when the main column says t-shirt in the new category colum would say "clothes" if it says shoes the new columns would say other, etc

Clothes would search words like t-shirts, hats, etc

bags would search bagpacks, packs, etc

and other the rest of words 

 

Thank you for the help!

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

Be aware of handling different cases of text like this:

 

data want;
   set have;

   if lowcase(main_column) in ('t-shirts', 'hoodies', 'hats') then do;
      new_column = 'Clothes';
   end;
   else if lowcase(main_column) in ('bags', 'backpacks') then do;
      new_column = 'Bags';
   end;
   else do;
      new_column = 'Other';
   end;
run;

View solution in original post

8 REPLIES 8
PeterClemmensen
Tourmaline | Level 20

Something like this? 🙂

 

data want;
   set have;

   if main_column in ('T-Shirt' /*, Insert other types of clothes here separated by , */) then do;
      new_column = 'Clothes';
   end;
   else if main_column in ('Shoes') then do;
      new_column = 'Other';
   end;
   else if main_column in ('Some Bags Name') then do;
      new_column = 'Bags';
   end;
run;
mcarmona
Calcite | Level 5
 
PeterClemmensen
Tourmaline | Level 20

Not sure I understand completely, but you can put as many words inside the parenthesis as you want as below? 🙂

 

data want;
   set have;

   if main_column in ('T-Shirt' /*, Insert other types of clothes here separated by , */) then do;
      new_column = 'Clothes';
   end;
   else if main_column in ('Shoes', 'Socks', 'Ties') then do;
      new_column = 'Other';
   end;
   else if main column in ('Some Bags Name') then do;
      new_column = 'Bags';
   end;
run;
fconerj
Calcite | Level 5
I know, thank you again for your fast reply 🙂

I mean, imagine you have 1000 words to put in the parenthesis, is there a way to say this;

T-shirts, hoodies, hats = clothes
bags, backpacks = bags
all the rest of the words = other ?

PeterClemmensen
Tourmaline | Level 20

Ah, now I get it 🙂 Sure:

 

data want;
   set have;

   if main_column in ('T-shirts', 'hoodies', 'hats') then do;
      new_column = 'Clothes';
   end;
   else if main_column in ('bags', 'backpacks') then do;
      new_column = 'Bags';
   end;
   else do;
      new_column = 'Other';
   end;
run;
fconerj
Calcite | Level 5
that's great, thank you! 😄
PeterClemmensen
Tourmaline | Level 20

Anytime. Please mark my answer as a solution if it solved your problem 🙂 Regards.

PeterClemmensen
Tourmaline | Level 20

Be aware of handling different cases of text like this:

 

data want;
   set have;

   if lowcase(main_column) in ('t-shirts', 'hoodies', 'hats') then do;
      new_column = 'Clothes';
   end;
   else if lowcase(main_column) in ('bags', 'backpacks') then do;
      new_column = 'Bags';
   end;
   else do;
      new_column = 'Other';
   end;
run;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

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
  • 8 replies
  • 1046 views
  • 0 likes
  • 3 in conversation