I am trying to add a variable to my data set

hz16g22 — Tue, 21 Feb 2023 18:17:57 GMT

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;

Re: I am trying to add a variable to my data set

PaigeMiller — Tue, 21 Feb 2023 18:26:17 GMT

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.

topic Re: I am trying to add a variable to my data set in New SAS User

I am trying to add a variable to my data set

Re: I am trying to add a variable to my data set