Attempting to create a new variable in a data step called top breed based on a breed column in previous data set. Data in breed column of old data varies, ie English Bulldog, American Bulldog, Labrador Mix, Labrador Retriever, Jack Russel Terrier, etc.
Trying to write if then index code so that if breed contains Bulldog, Lab, Terrier, Beagle, or Shepherd topbreed = 1. If not 0. I have only been able to figure out the the coding for one breed I am trying to assign a value for. Is there any ways to add multiple if then index clauses within the same data step?
Current code:
data new variable;
set old variables;
if index(breed, 'Bulldog') then topbreed = 1;
else topbreed = 0;
run;
Trying to get: if index(breed, 'Bulldog', 'Lab', 'Terrier', 'Shepherd', 'Beagle') then .... with no success
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.