WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.
Answers were Sorted based on User's Feedback
Answer / h r
proc sql:-
use into:<var_name> to count observation recall by &<var_name>.
table limit in sql now 256(previously its was 32).
proc report now BEST12. format default for numeric value.
before there isn't any default format for numeric value in proc report.
NEW Options noward in proc freq.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rk
There are lots of changes has been made in the version 9
when we compared with the version 8.
The following are the few:
SAS version 9 supports Formats longer than 8 bytes & is not
possible with version 8.
Length for Numeric format allowed in version 9 is 32 where
as 8 in version 8.
Length for Character names in version 9 is 31 where as in
version 8 is 32.
Length for numeric informat in version 9 is 31, 8 in version
8. Length for character names is 30, 32 in version 8.
3 new informats are available in version 9 to convert
various date, time and datetime forms of data into a SAS
date or SAS time.
· ANYDTDTEW. - Converts to a SAS date value
· ANYDTTMEW. - Converts to a SAS time value.
· ANYDTDTMW. -Converts to a SAS datetime value.
CALL SYMPUTX Macro statement is added in the version 9 which
creates a macro variable at execution time in the data step by
· Trimming trailing blanks
· Automatically converting numeric value to character.
New ODS option (COLUMN OPTION) is included to create a
multiple columns in the output.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / gangadhar
and DUPSOUT option in proc sort in ver 9. to output only
dupsvalues... any thing else
| Is This Answer Correct ? | 0 Yes | 0 No |
Mention sas system options to debug sas macros.
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?
How substr function works in sas?
Why is SAS considered self-documenting?
how can u extract,transform and loading?
what is the difference between proc means and proc tabulate?
what is sas enterprise intelligence architecture? : Sas-bi
The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?
Describe 5 ways to do a “table lookup” in SAS?
/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;
what is portability of sas programmes?
What techniques and/or PROCs do you use for tables?