Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?


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

Post New Answer

More SAS Interview Questions

What are types of transport files?

2 Answers   PRA Health Sciences, Quintiles,


What is the difference between nodup and nodupkey options?

20 Answers   iFlex, Makro, Talwar,


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

0 Answers  


Name the option to produce a frequency line items rather that a table.

2 Answers  


what is Difference between PROC SQL JOINS and MERGE?

3 Answers   Accenture, 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;

1 Answers   Emerio,


what is the difference btw proc means and proc univariate?

8 Answers   HSBC, TCS,


how does sas handle missing values in formats? : Sas programming

0 Answers  


proc means? proc sort? proc append? proc freq? proc print? proc content?

4 Answers   Oracle,


Describe what are the different levels of administrative users in sas? : sas-grid-administration

0 Answers  


If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?

8 Answers   HCL,


What’s the difference between var b1 – b3 and var b1 — b3?

0 Answers  


Categories