what is the main difference between rename and label? (don't
say that they both perform the same function).
Answers were Sorted based on User's Feedback
Answer / kiran
we can change the name of a variable using both rename and
label options.
when we use label the change will be temporary i.e. only
for printing purpose;
but, when we use rename option the change will be
permanantly stored in the dataset.
and both the options can be used in both datastep and
procstep.
Is This Answer Correct ? | 2 Yes | 8 No |
I need level 2 to 5 sas using companies in india
do you need to know if there are any missing values? : Sas programming
what is SAS/Graph?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
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.
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
Explain the special input delimiters used in sas programming.
In the flow of DATA step processing, what is the first action in a typical DATA Step?
Explain substr function?
what is data governance? : Sas-di
How would you remove a format that has been permanently associated with a variable? ________________