Hello Experts,
Hope you are all doing good
I need to compare the datasets. I am having 5 datasets, Dataset names may vary depend upon the project. In two library the datasets are saved. I need to compare the dataset between those two library.
In Temp library, I am having 7 files( File count won't change between library)
CT_Sales Payment_1 Payment_2 Payment_3 758_Transaction CT758_2_Store Product
In Temp1 Library, I am 7 files
CT_Sales Payment_1 Payment_2 Payment_3 758_Transaction CT758_2_Store Product
As we can compare these files easily by using PROC COMPARE. But, i want to do it using Macro(Dynamically) so that when the file name changes i don't need to update in the code.
Before comparing i need to do some changes in the dataset.
Some time we will have multiple dataset which has different observation but same variable name. So, If i am having multiple dataset means i need to append those dataset and create a new dataset
In my dataset, the original name is(Sales,Payment,Transaction,Store,Product) But I am having some prefix to it and it wont be the same for all dataset. So i need to remove those before comparing. I tried Compress function but, I am not able to achieve the expected result
Once We modify our dataset as mentioned above then I need to compare it dynamically using macro function.
I know it's a lot to ask for. But, I am learning so it would be helpful for my learning
Thanks in advance
... View more