I am trying to add a variable to my data set

[hz16g22]

For some reason it keeps creating a new sheet in the folder with zero observations, I would like to know where I'm going wrong.

data female_names;
	set female_names;
	fraction = count/180623104;
run;

[PaigeMiller · Accepted solution]

In SAS, there are no "sheets", there are data sets.

The code you provided probably means you have somehow over-written the original female_names data set with an empty one, and so you need to re-create the non-empty female_names data set. The code uses a poor practice of overwriting a data set with a new data set of the same name. Better is this:

data female_names1;
	set female_names;
	fraction = count/180623104;
run;

In this case, a brand new data set female_names1 is created, and female_names is unchanged.

From now on, when you get errors in the log, show us the ENTIRE log for the step (PROC or DATA step) that has the errors. When I say ENTIRE log, I mean every single line, whether it contains the error, or not.