topic Observation satisfies a condition in SAS Programming

Observation satisfies a condition

skjhzzang — Sun, 24 Nov 2019 07:30:08 GMT

I created a code to read the datalines below,

data STD;
input Name : $5. Var1 Var2 Var3;
Mean = Mean(Var1, Var2, Var3);
STD1 = STD (Var1, Var2, Var3);
STD = round(STD1,0.01);
drop STD1;
datalines;
MATT 145 349 48
Susan 194 578 300
Tom 394 84 291
Jayce 394 58 279
;
run;

How can I create another data set that only contains one data step to show only observations that has STD less than or equal to 150?

Re: Observation satisfies a condition

Kurt_Bremser — Sun, 24 Nov 2019 07:53:42 GMT

Use a subsetting if.

Re: Observation satisfies a condition

Patrick — Sun, 24 Nov 2019 10:25:13 GMT

None of the observations in the data you've posted appears to satisfy the condition - but here how you can write to two different tables in one go.

data STD std2;
  input Name : $5. Var1 Var2 Var3;
  Mean = Mean(Var1, Var2, Var3);
  STD1 = STD (Var1, Var2, Var3);
  STD = round(STD1,0.01);
  drop STD1;
  output std;
  if std<=150 then output std2;
  datalines;
MATT 145 349 48
Susan 194 578 300
Tom 394 84 291
Jayce 394 58 279
;

Re: Observation satisfies a condition

ed_sas_member — Sun, 24 Nov 2019 10:36:51 GMT

Hi @skjhzzang

You can also write one statement to calculate the rounded standard deviation .

data want want2;
	input Name : $5. Var1 Var2 Var3;
	Mean=Mean(Var1, Var2, Var3);
	STD=round(STD (Var1, Var2, Var3), 0.01);
	if std <160 then output want2;
	output want;
	datalines;
MATT 145 349 48
Susan 194 578 300
Tom 394 84 291
Jayce 394 58 279
;
run;

proc print data=want;
run;
proc print data=want2;
run;