else if loop in SAS studio

[KatieMessi]

I'm using the online SAS Studio I'm trying to create a new variable while doing a then do loop but it doesn't seem to work, any suggestions?

This  is my code....

Data golf;
	infile '/home/c153469110/golf.txt';
	input Distance_yards 18-22
		  Golfer_ID 28-29
		  Brand $ 39;
run;

proc print data=golf;
run;

Data golf;

	 set golf;
	 
	 
	 
	 if Distance_Yards<290 then Distance_Catagory='Poor';
	 
	 else if Distance_Yards >=290 then Distance_Catagory='Average';
	
	 else if Distance_Yards >310 then Distance Catagory='Above Average';
	 
	 
run;

[Kurt_Bremser · Accepted solution]

Your third option will never be reached. Expand your second condition:

else if Distance_Yards >=290  and Distance_Yards <= 310 then Distance_Catagory='Average';

[KatieMessi]

It’s not working for me

[Kurt_Bremser]

It seems you have an invalid variable name, change the last assignment: 

then Distance_Catagory='Above Average';

Note the underline that replaces the blank.

If that was not the reason,  be more specific what "does not work" and post the log. Use the {i} button for that.