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
- 10677 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 |
what are the scrubbing procedures in sas? : Sas programming
wt is a-z and a--z?
is data integration and etl programming is same? : Sas-di
Explain what is SAS informats?
what are the new features included in the new version of SAS i.e., SAS9.1.3?
5 Answers College School Exams Tests, Wockhardt,
Which are the statements whose placement in the data step is critical?
What is the difference between %local and %global? : sas-macro
Name statements that are execution only.
do you need to know if there are any missing values? : Sas programming
which domain is better in sas? clinical trails or banking
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
Teradata 
