Dataset has has 0 observations...

mlblac5 — Thu, 14 Jan 2021 23:19:37 GMT

Hi All! Looking for some assistance as a new SAS Studio user. I am attempting to run a conditional if statement to print only the presidents from Ohio based on the 'Home_State' variable. However, it comes back with zero observations. Below I have included the code I used and log.

data OhioPresidents;
	SET MINE.USPRESIDENT;
	
	if Home_State = 'ohio';
	Keep President Wikipedia_Entry Took_Office Left_Office Party Portrait Thumbnail Home_State;
run;
proc print data OhioPresidents;
run;

Re: Dataset has has 0 observations...

Kurt_Bremser — Thu, 14 Jan 2021 23:32:23 GMT

if Home_State = 'ohio';

If home_state is actually "Ohio", this condition will not catch it. The spelling must match exactly.

proc print data=OhioPresidents;

Note the necessary =.

topic Re: Dataset has has 0 observations... in New SAS User

Dataset has has 0 observations...

Re: Dataset has has 0 observations...