Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 10621 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / karthik
data a;
input var;
cards;
0
1
2
3
-1
-2
-3
;
data report;
set a;
if var>=0 then var1=var;
else var2=var;
drop var;
run;
/*Report output*/
proc print data=report;
run;
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / ravikumar marappan
data test;
input var;
retain sub;
retain ad;
if var < 0 then sub=sum(sub,var);
else ad=sum(ad,var);
datalines;
1
2
3
-1
-2
-3
;
run;
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / ashish
data a;
input num;
cards;
1
2
3
-5
-7
-8
9
10
0
-56
-3
;
run;
data b ;
retain sum_n sum_p;
set a end=last;
if _n_=1 then sum_n = 0;
if _n_=1 then sum_p = 0;
if(num<0) then sum_n= sum(sum_n,num);
else sum_p= sum(sum_p,num);
if last then output;
run;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / arun kumar
proc sql;
create table arun as
select sum(case when var>=0 then var else . end) as num_p,
sum(case when var<0 then var else . end) as num_n
from a;
quit;
proc print;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
how are numeric and character missing values represented internally? : Sas programming
what are some good sas programming practices for processing very large data sets? : Sas programming
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
Are you sensitive to code walk-throughs peer review or QC review?
what is enterprise guide? What is the use of it? : Sas programming
who is the best SAS clinical Trainer in Hyderabad?
Code the MEANS to produce output to be used later.
explain the difference between proc means and proc summary?
how can u create zero observation dataset?
Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..
Are you involved in writing the inferential analysis plan? Tables specifications?
Teradata 
