Monday, May 31, 2021

Dropping string observations starting with a number

Hi. I have the following data and want to delete all observations where the Product starts with a number. The Product variable is a string variable. I’d appreciate any help. Thanks.

Code:
"1 ANTI-INFECTIVES"       
"1 ANTI-INFECTIVES"       
"1 ANTI-INFECTIVES"       
"105 MISCELLANEOUS AGENTS"
"105 MISCELLANEOUS AGENTS"
"105 MISCELLANEOUS AGENTS"
"105 MISCELLANEOUS AGENTS"
"105 MISCELLANEOUS AGENTS"
"105 MISCELLANEOUS AGENTS"
"105 MISCELLANEOUS AGENTS"
"105 MISCELLANEOUS AGENTS"
"105 MISCELLANEOUS AGENTS"
"105 MISCELLANEOUS AGENTS"
"115 NUTRITIONAL PRODUCTS"
"115 NUTRITIONAL PRODUCTS"
"122 RESPIRATORY AGENTS"  
"122 RESPIRATORY AGENTS"  
"122 RESPIRATORY AGENTS"  
"122 RESPIRATORY AGENTS"  
"20 ANTINEOPLASTICS"      
"20 ANTINEOPLASTICS" 
"ACCOLATE"
"ABILITY"
"ACCU-CHECK"

No comments:

Post a Comment