topic Re: Getting missing numeric value(.) in gender when i am trying to create dataset ds1. in SAS Programming

Getting missing numeric value(.) in gender when i am trying to create dataset ds1.

Ananyayadav — Tue, 14 Aug 2018 09:30:51 GMT

My code was this:

data test.ds1;
set test.ds;
age=23;
gender=M;
run;

and my log window is showing this message:

NOTE: Variable M is uninitialized.

NOTE: There were 1 observations read from the data set TEST.DS.

NOTE: The data set TEST.DS1 has 1 observations and 4 variables.

NOTE: DATA statement used (Total process time):

real time 0.23 seconds

cpu time 0.14 seconds

Can anyone please clarify where i am wrong?

Re: Getting missing numeric value(.) in gender when i am trying to create dataset ds1.

RW9 — Tue, 14 Aug 2018 09:51:41 GMT

data test.ds1;
  set test.ds;
  age=23;
  gender=M;
run;

In this code, is there a variable called M in test.ds. There isn't is there, what you are trying to do is set gender to the value of a string of characters, hence you need to enclose that string of characters within quotes either single or double:

data test.ds1;
  set test.ds;
  age=23;
  gender="M";
run;