topic Re: Assign variable with missing valuesd in SAS Programming

Assign variable with missing valuesd

s_manoj — Tue, 28 Jul 2020 08:17:28 GMT

Hi there,

Here I have a situation that I am anticipating variables A to Z in dataset, if we have any variable missing in a resultant dataset then need to initialize that missing variable with a missing value

example: Expecting A B C D E F G variables in data set, but I got only A B C F variables in a resultant dataset in this case I need to initialize missed out variables D E G with missing value in the resultant dataset.

Any help would be very much appreciated and helps me very much

Thanks in advance

Manoj

Re: Assign variable with missing valuesd

Kurt_Bremser — Tue, 28 Jul 2020 08:35:10 GMT

Create a blueprint dataset without observations, and prepend that in a SET statement to the actual data:

data expect;
input a b c d e f g;
datalines; 
;

data have;
input a b c f;
datalines;
1 1 1 1
2 2 2 2
;

data want;
set
  expect
  have
;
run;

Assign variable with missing valuesd??

LennoxConner — Wed, 29 Jul 2020 10:01:10 GMT

Hi there,

Here I have a situation that I am anticipating variables A to Z in dataset, if we have any variable missing in a resultant dataset then need to initialize that missing variable with a missing value

Any help would be very much appreciated and helps me very much

Thanks in advance

Re: Assign variable with missing valuesd??

ballardw — Wed, 29 Jul 2020 10:15:22 GMT

Check this link

https://communities.sas.com/t5/SAS-Programming/Assign-variable-with-missing-valuesd/m-p/672750

Then check to see if you can guess who in your class the other poster may be.

Re: Assign variable with missing valuesd??

Kurt_Bremser — Wed, 29 Jul 2020 10:55:43 GMT

I merged these identical questions.