Hi experts,    I have a requirement to compare 200+ datasets with other datasets.  The variable are different for each dataset and i need to compare them one by one and store the results in excel file The Results I need are  1) No of observations between both datasets 2) no of Variables 3) any unmatched observations   I know we need to sort the datasets before comparing, I am looking for Macro which will do this as manually it takes time and not efficient. Any idea or solution will be appreciated   Thanks, Vicks ... View more

Hi Experts,   Could someone can please guide me to understand the already built SAS VA reports. where to open the reports for that designer or explorer ?  I want to find the underlying variables used and what is the calculation done if it was new measure. and last one can I see the underlying query for that report that ran by selecting filter or any object I select.   Really appreciate your response.   Many Thanks in advance, Thanks, Vicks   ... View more

Hi guru's Could some one help me to code one of our requirement. I tried my not iterative and have some challanne as I am new. I have this data in CSV file below are the cell numbers i.e data in one column and three rows. There are some thousands of rows. I have to remove that delimiter <tt> and load the data to corresponding fileds. Attaced is the input file but in notepad   1ST CELL A1:A1 Name: abc<tt> Product: loan<tt> accno: 123456<tt> amount: 389.56<tt> bonus: 3000<tt> Product: CCard_plat<tt> accno: 5689<tt> amount: 478.96<tt> Product: gold_insurance<tt> accno: 1010102<tt> amount: 103<tt> bankcde: ICI<tt> payment: 3094   2nd CELL A1:B2 Name: vbsd<tt> Product: CCard_plat<tt> accno: 74123<tt> amount: 56.21<tt> Product: gold_insurance<tt> accno: 2020201<tt> amount: 189<tt> bankcde: hdfc<tt> payment: 605 3rd CELL A1:B3 Name: klhj<tt> Product: gold_insurance<tt> accno: 3030312<tt> amount: 563<tt> bankcde: kk<tt> payment: 489 I am expecting the output of the data as below: Where there is no data for any of the product then it should load with blank and fill the remaining fields.   Name Product Accno Amount Bonus Card_type CC_Accno CC_Amount_no Insurance_Type Insurance_No Insurance_Amt Bank_Cde Payment abc      loan    123456     389.56      3000     ccard_plat     5689      478.96       gold_insurance       1010102     103      ICI      3094 vbsd                                                              ccard_plat     74123      56.21       gold_insurance        2020201     189     hdfc     605 klhj                                                                                                                      gold_insurance        3030312     563     kk        489   Really appreciate your inputs.  Thanks in advance. ... View more

Hi Guys,  I know its simple but just wondering why the below code in creating the metadata table is creating at database but not in my sas lib.   I ran the following user written code at DI   LIBNAME abc ORACLE; data abc.want set abc.have(obs=0); run;   By this  the table is created at database but metadata table is not created at DI. Could some one let me know why it is not created. or any solution to create a metadata table in SAS DI with user written code.   Many thanks in advance. Vicks   ... View more