Interested to Buy Any Domain ? << Click Here >> for more details...
for report generation which one you used proc report or
data_null_?
- 3 Answers
- 7809 Views
- Accenture, Quintiles, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / satheesh
proc report only we can use. The second option is used for create null dataset....
thank u
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / dileepb
BOTH WE CAN USE:
The DATA _NULL_ step is a reporting tool that offers extreme flexibility. Because it uses the
power of the DATA step, this methodology enables the user to generate reports in almost any
form.
In PROC REPORT,
the compute block, with its access to the majority of the SAS language elements, such as logic
processing, functions, and assignment statements, takes on some of the role of the DATA
_NULL_ step.
| Is This Answer Correct ? | 1 Yes | 0 No |
Give some examples where proc report’s defaults are different than proc print’s defaults?
How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values?
Diff between proc sql merge and join?
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
What is the difference between one to one merge and match merge? Give an example.
how can u convert this 25-jul-2010 from numeric to charcter?
How many missing values are available? When might you use them?
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.
hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
Do you need to rearrange the order of the data for the report?
what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
Teradata 
