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;

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;

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;

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;

Answer / mahesh babu b

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

In SAS explain which statement does not perform automatic conversions in comparisons?

0 Answers  

What do you feel about hardcoding?

1 Answers  

how to delete the duplicates by using proc sql?

3 Answers   Genpact,

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?

3 Answers  

What is difference between N and n????

2 Answers   Sciformix,

explain the concepts and capabilities of business object? : Sas-bi

0 Answers  

data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.

1 Answers  

i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance

2 Answers   Tech Mahindra,

Tell me about % include and % eval? : sas-macro

0 Answers  

What is the difference between Proc tabulate and Proc print

4 Answers   CitiGroup,

what is the diff b/w verification validation in sas

3 Answers   SAS,

What can you learn from the SAS log when debugging?

0 Answers   Quintiles,