how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?
11 37981How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
2 5612How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student.
TCS,
4 8707How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
3 7586
Differentiate input and infile.
Mention how to limit decimal places for the variable using proc means?
Tell e how how dealt with..
what is sas database server? : Sas-di
What are the features of SAS?
What is the use of stop statement?
What is your favorite all time computer book? Why?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
which date function advances a date, time or datetime value by a given interval? : Sas programming
Enlist the functions performed by sas.
What is SAS? What are the functions does it performs?
how can you create zero observation dataset? : Sas programming
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.
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
How do dates work in sas?