data test1; set a; if find(var,'-') >0 then b=var; else c=v

how to add distinctly var variable values ex..
Data a;
input var;
datalines;
0
1
2
3
-1
-2
-3
;
run;
adding all +ve value in one varibale n do the same for -ve
too

Question Posted / mahesh babu b

5 Answers
10676 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / mahesh babu b

data test1;
set a;
if find(var,'-') >0 then b=var;
else c=var;
run;

Is This Answer Correct ?

3 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain what is SAS informats?

1101

explain what is factor analysis? : Sas-administrator

1118

what is information maps?

2230

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1087

I need level 2 to 5 sas using companies in india

2386

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1163

What is the maximum length of the macro variable? : sas-macro

1103

for what purpose would you use the retain statement? : Sas programming

1102

how can you put a "trace" in your program? : Sas programming

1070

How do dates work in sas?

1147

Hi, If anyone has base SAS certification dumps, please share.

1870

Give an example where SAS fails to convert character value to numeric value automatically?

1094

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2196

What are the scrubbing procedures in sas?

1016

what are _numeric_ and _character_ and what do they do? : Sas programming

1163