What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
1721What is the order of application for output data set options, input data set options and SAS statements?
875How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
901
Which command is used to perform sorting in sas program?
What is the work of tranwrd function?
I need level 2 to 5 sas using companies in india
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
Explain what is data step?
how to do user inputs and command line arguments in sas?
what is the basic structure sas administrator? : Sas-administrator
What are the difference between the sas data step and sas procs?
What is the command used to find missing values?
Explain data_null_?
Name validation tools used in SAS
What is the difference between using drop = data set option in data statement and set statement?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
What are the best sas programming practices for handling very large datasets? : sas-grid-administration
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.
