define table lookup and how may ways it can be done...explian3 4187
HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?3 7031
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE4 5138
hi guys ...i have one query... data abc; input s w k g o t a m; cards; 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 9 ; run; i want the output to be the sorted order(only variables).observations should not be changed..14 10949
what is the difference between sas and other datawarehousing languages?what are the advantages of sas over them?2 6953
Briefly explain input and put function?
what are the categories that sas informats are used to the place the data? : Sas-administrator
what are _numeric_ and _character_ and what do they do? : Sas programming
explain the difference between proc means and proc summary?
What are the difficulties u faced while doing vital signs table or dataset?
How necessary is it to be creative in your work?
Explain the difference between using drop = data set option in set and data statement?
how many data types in sas? : Sas-administrator
what is treatment emergent events and treatment emregent adverse event
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
explain the main difference between the nodup and nodupkey options? : Sas-administrator
how does sas handle missing values in sort order? : Sas programming
Do you need to rearrange the order of the data for the report?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
Explain how merging helps to combine data sets.