Write SAS codes to compare two datasets. Suppose the
allowable difference is 0.1.
Answers were Sorted based on User's Feedback
Answer / kumar
0.1 diff can be achieved by using criterion= option in
compare.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / reshma
Proc compare to compare to datasets with respect to all
variables.
proc sort data= data1 ;
by var1;
run;
proc sort data= data2 ;
by var1;
run;
Proc comapre base=data1 compare=data2;
run;
don't know abt 0.1 diff
| Is This Answer Correct ? | 5 Yes | 4 No |
what is snowflake schema? : Sas-di
List out some key concept of SAS
how does sas handle missing values in assignment statements? : Sas programming
What are the differences between sum function and using “+” operator?
Give some ways by which you can define the variables to produce the summary report (using proc report)?
what are different type of sas servers ? On which server does the sas code execute ?
What is a pdv and what are its functions?
what is the use of proc contents and proc print in sas? : Sas-administrator
what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter?
36 Answers Accenture, College School Exams Tests, CTS, IBM, IHRD, Infosys, Sylhet Engineering College, TCS, Wipro,
/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
Mention few ways with which a “table lookup’ is done in sas programming.