how to remove duplicates using proc sql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SAS Interview Questions

Explain the purpose of retain statement.

0 Answers  


/* 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;

1 Answers   Emerio,


Can you suggest us materials for sdtm mapping?

0 Answers   TCS,


Give e an example of..

0 Answers  


How can you limit the variables written to output dataset in data step?

0 Answers  


How do you delete duplicate observations in sas?

0 Answers  


What are the applications primarily used by business analyst? : Sas-bi

0 Answers  


how can u convert this 25-jul-2010 from numeric to charcter?

3 Answers  


What is difference between Global n Local Macro Variables..?

6 Answers   TCS,


Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore

1 Answers  


What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?

1 Answers   Quintiles,


What is proc sql pass through facility?

4 Answers   L&T,


Categories