Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.
- 4 Answers
- 7751 Views
- Genzyme, I also Faced
- E-Mail Answers
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 |
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
how to delete the duplicates by using proc sql?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
what is SAS ACCESS AND SAS CONNECT ? Give an example and data statements used.
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?
why is a stop statement needed for the point=option on a set statement? : Sas programming
what are _numeric_ and _character_ and what do they do? : Sas programming
libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak
Do you need to know if there are any missing values?
What’s the difference between var b1 – b3 and var b1 — b3?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
How would you define the end of a macro? : sas-macro
Teradata 
