Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Filter observations in a string variable

    I would like to filter the observations with the word COCONUT in a variable called BOCdesc. I've tried to follow the codes I've seen elsewhere here, but I seem to be doing something wrong. Is there a simple way of doing this?


    BOCdesc
    82 X 265 KGS COCONUT WATER CONCENTRATE
    USED HOUSEHOLD GOODS AND PERSONAL EFFECTS AND 1 UNIT USED CITROEN C4
    WEARING APPAREL
    ASSORTED FOODSTUFF
    ABACA BASKETS
    MEN'S KNITTED SHIRT
    CANNED MILK FISH
    FROZEN YELLOWFIN TUNA ROUND
    SARDINES

  • #2

    Code:
    gen coconut_found = strpos(BOCdesc, "COCONUT") > 0

    Comment


    • #3
      Thank you very much, Nick!

      Comment

      Working...
      X