Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SAS Interview Questions

For what purposes have you used sas macros? : sas-macro

0 Answers  


Explain the difference between nodup and nodupkey options?

0 Answers  


how would you create multiple observations from a single observation? : Sas programming

0 Answers  


How do you read in the variables that you need?

5 Answers  


Can you explain the process of calendar?

0 Answers  


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

0 Answers  


What SAS statements would you code to read an external raw data file to a DATA step?

6 Answers   Accenture,


Can we use where and having clauses in a single SAS program. ex: proc sql;     select a,b,c from test      where state in 'KA'      and having <some condition>. Is the above program run correctly, if not why ?     

4 Answers   UHG,


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

7 Answers  


How to display duplicate observations in data?

1 Answers  


how many types prompting framework can be broken down to? : Sas-bi

0 Answers  


what is conditional processing?

4 Answers   Accenture,


Categories