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

Answers were Sorted based on User's Feedback



how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 ..

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

how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 ..

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

how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 ..

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

how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 ..

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

how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 ..

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

Post New Answer

More SAS Interview Questions

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

0 Answers  


Does anybody has lastest SAS certification dumps,if anybody has please mail me at akshara_SAS@ymail.com Thanks Akshara

55 Answers  


explain what is data set in sas? : Sas-administrator

0 Answers  


hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

0 Answers   SAS,


In proc transpose and data step with arrays which one you pick?

0 Answers   Accenture, Quintiles,






Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?

1 Answers   HCL,


what the use of proc glm

1 Answers   Accenture, C Marc,


What sas features do you use to check errors and data validation?

0 Answers  


what is enterprise guide? What is the use of it? : Sas programming

0 Answers  


How are the analysis data sets structured?

3 Answers  


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

0 Answers  


How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C

3 Answers   Accenture, Oracle,


Categories