Hi Team,
I have a dataset as below:
SKU
Dataset
Path
Store_number
4535345
product
/c:/user/new/path1/path2/path3/path4/
4354355
product
/c:/user/old/new/path1/path2/path3/path4/
7567456
product
/c:/user/new/path5/path2/path3/path4/
5647645
product
/c:/user/old/new/path5/path2/path3/path4/
Given above is the sample dataset but there are about 200+ observation. where we have path given for the relevant SKU, we need to fetch Store_Number from Product dataset which is residing in the given path for relevant SKU.
SKU id is the primary variable for lookup b/w have dataset and product dataset. All 200+ obs are unique, and there relevant path are unique.
Since we have 200+ observation, it need to lookup 200 paths and update the have dataset with Store_number referring to the path which is mentioned in have table, each product there is only one SKU record for which we need to lookup Store_Number.
Ex: For the first record the lookup table (product.sasbdat) we have i the below path is
/c:/user/new/path1/path2/path3/path4/
SKU
Store_number
4535345
112
Ex: For the second record the lookup table (product.sasbdat) we have i the below path is
/c:/user/old/new/path1/path2/path3/path4/
SKU
Store_number
4354355
432
Likewise final table after lookup it will now be as below:
SKU
Data_set
Path
Store_number
4535345
product
/c:/user/new/path1/path2/path3/path4/
112
4354355
product
/c:/user/old/new/path1/path2/path3/path4/
432
7567456
product
/c:/user/new/path5/path2/path3/path4/
563
5647645
product
/c:/user/old/new/path5/path2/path3/path4/
729
Please provide macro based solution, which can fetch and perform in less time consumption.
Regards,
GK
... View more