Hi I am very new to SAS and coding. I have a situation I have two datasets as below 1) Dataset 1:(with 86 variables and 7095 observation) Var 1 var 2 WEEK var 4 STORE var 5 a f 1 0 1 x b k 6 0 53 x c z 66 0 2 x d x 50 0 53 x e y 3 0 8 x Here WEEK column above have values from week 1 to week 100 2) Dataset 2:(with 2 variables and 621 unique observation) STORE TIER 1 Tier A 2 Tier C 3 Tier B 8 Tier B 9 Tier C 53 Tier A 18 Tier C 98 Tier B Here Tier column has values as Tier A,B,C for all 621 unique store numbers I want to add a new column in dataset 1 as store type with below logic: Tier A Tier B Tier C Pre-week (week 1 to Week 50) 11 12 13 Post-week (week 51 to Week 100) 21 22 23 So the new column will have numerically encoded values as 11,12,13,21,22,23 based on range of week from WEEK column in dataset 1 and mapped Tier from dataset 2. Kindly help me with some sort of function code for this.
... View more