topic Re: error variable doesn't exist, but it just doesn't remember it in the output in New SAS User

error variable doesn't exist, but it just doesn't remember it in the output

saslearner14 — Sun, 30 Apr 2023 04:14:23 GMT

I am having trouble in my program using multiple created variables at once. I had created two new variables and when I go to use them, only the most recent one gets saved into my output. When I run an analysis, I get an error code that one does not exist, but it will let me run it if I only run that specific one.

data dap1; set epi.hpvd;
if CD4=. then cd=.;
if CD4 lt 500 and cd4 ge 0 then cd ='2';
if CD4 ge 500  then cd='1';
run;

data dap1; set epi.hpvd;
if hiv_load=. then h=.;
if hiv_load le 75 then h= '1';
if hiv_load gt 75 then h='2';
run;

proc univariate data=dap1;
class cd ;
run;

Re: error variable doesn't exist, but it just doesn't remember it in the output

Kurt_Bremser — Sun, 30 Apr 2023 05:00:16 GMT

@saslearner14 wrote:

I am having trouble in my program using multiple created variables at once. I had created two new variables and when I go to use them, only the most recent one gets saved into my output. When I run an analysis, I get an error code that one does not exist, but it will let me run it if I only run that specific one.
data dap1; set epi.hpvd;
if CD4=. then cd=.;
if CD4 lt 500 and cd4 ge 0 then cd ='2';
if CD4 ge 500  then cd='1';
run;

data dap1; set epi.hpvd;
if hiv_load=. then h=.;
if hiv_load le 75 then h= '1';
if hiv_load gt 75 then h='2';
run;

proc univariate data=dap1;
class cd ;
run;
 

Your second DATA step overwrites the result dataset from the first. Combine both steps into one:

data dap1;
set epi.hpvd;
if 0 le CD4 lt 500
then cd = '2';
else if CD4 ge 500 then cd = '1';
if hiv_load = .
then h = ' ';
else if hiv_load le 75
then h = '1';
else h = '2';
run;

I've also removed one unnecessary IF, created the new variables as character, and optimized your code by using ELSE IF where appropriate.

Re: error variable doesn't exist, but it just doesn't remember it in the output

Tom — Sun, 30 Apr 2023 05:08:37 GMT

So you made dap1 with the new variable .

You then overwrote it with a different dataset that makes a different new variable.

If you want both variables in the same dataset that either make them both in the SAME data step.

Or use the output of the first step as the input of the second step.

Re: error variable doesn't exist, but it just doesn't remember it in the output

PaigeMiller — Sun, 30 Apr 2023 10:56:35 GMT

In addition, you can make your coding and typing much easier — there's really no reason to put quotes around 1 and 2, when this would work just as well:

data dap1; set epi.hpvd;
if CD4=. then cd=.;
if CD4 lt 500 and cd4 ge 0 then cd =2;
if CD4 ge 500  then cd=1;
run;