About rohithverma

rohithverma · ‎02-01-2020

Hi Ed ,really it's awesome it works .Could you please explain the second datastep match2 working please .I am bit confused what's happening in that .

rohithverma · ‎02-01-2020

you can see the common chequeid .So for the common chequeid we need to find

rohithverma · ‎02-01-2020

logic is when the debit amount is equals to credit amount then the flag should be raised as "MATCH" or else "MISMATCH" should be raised

rohithverma · ‎02-01-2020

I have input sno DEBIT CREDIT CHEQUEID VDATE 2 200 0 1234 1-Jan-20 3 0 200 1234 2-Jan-20 4 400 0 4567 1-Jan-20 5 0 400 4567 1-Jan-20 6 400 0 4567 2-Jan-20 and i need output like sno DEBIT CREDIT CHEQUEID VDATE flag 2 200 0 1234 1-Jan-20 match 3 0 200 1234 2-Jan-20 match 4 400 0 4567 1-Jan-20 match 5 0 400 4567 1-Jan-20 match 6 400 0 4567 2-Jan-20 mismatch when debit = credit the flag should be raised as MATCH else MISMATCH

rohithverma · ‎02-01-2020

NO, here you are creating a duplicate observations

rohithverma · ‎02-01-2020

i have input data like as mentioned below . i want to filter the matched debit and credit observations into one dataset and the discrepent one into another dataset. input sno DEBIT CREDIT CHEQUEID VDATE 1 200 0 1234 1-Jan-20 2 200 0 1234 1-Jan-20 3 0 200 1234 2-Jan-20 4 400 0 4567 1-Jan-20 5 400 0 4567 1-Jan-20 6 400 0 4567 1-Jan-20 7 0 400 4567 2-Jan-20 8 600 0 6789 1-Jan-20 The output should be table 1 output sno DEBIT CREDIT CHEQUEID VDATE FLAG 2 200 0 1234 1-Jan-20 MATCHED 3 0 200 1234 2-Jan-20 MATCHED 6 400 0 4567 1-Jan-20 MATCHED 7 0 400 4567 2-Jan-20 MATCHED table 2 output sno DEBIT CREDIT CHEQUEID VDATE 1 200 0 1234 1-Jan-20 4 400 0 4567 1-Jan-20 5 400 0 4567 1-Jan-20 7 600 0 6789 1-Jan-20

rohithverma · ‎01-31-2020

on day one i have data like as below sno debit credit chequeid vdate 1 200 0 1234 01-jan-2020 2 200 0 1234 01-jan-2020 3 400 0 4567 01-jan-2020 4 400 0 4567 01-jan-2020 5 400 0 4567 01-jan-2020 6 600 0 6789 01-jan-2020 and on day 2 i have data like this as appended to day 1 data the final input as sno debit credit chequeid vdate 1 200 0 1234 01-jan-2020 2 200 0 1234 01-jan-2020 3 0 200 1234 02-jan-2020 4 400 0 4567 01-jan-2020 5 400 0 4567 01-jan-2020 6 400 0 4567 01-jan-2020 7 0 400 4567 02-jan-2020 4 600 0 6789 01-jan-2020 So the final output i required is dataset1 sno debit credit chequeid vdate flag 1 200 0 1234 01-jan-2020 matched 2 0 200 1234 02-jan-2020 matched 3 400 0 4567 01-jan-2020 matched 4 0 400 4567 02-jan-2020 matched dataset2 sno debit credit chequeid vdate flag 1 200 0 1234 01-jan-2020 open 2 400 0 4567 01-jan-2020 open 3 400 0 4567 01-jan-2020 open Please do the needfull Thanks in advance ance

rohithverma · ‎01-23-2020

No it wasn't giving any error but it wasn't creating any data too.In the output there was no data.

rohithverma · ‎01-22-2020

So, now the desired output is loan dbamt cramt cheque 1234 200 0 222 1234 0 200 222 1234 200 0 222 1234 0 200 222 7890 200 0 345 7890 0 200 345

rohithverma · ‎01-22-2020

These are all the possible cases in the data as mentioned below .But here we need to consider only for which the cheque id's are equal for subsequent records should be considered along with that the debit amount should be equal to credit amount and if there are any open accounts like sno 5 & 6 for those the key variable will be loan no. For remaining we need to consider the cheque ids sno loan dbamt cramt cheque 1 1234 200 0 222 2 1234 0 200 222 3 1234 200 0 222 4 1234 0 200 222 5 1456 300 0 333 6 1389 400 0 444 7 7890 200 0 345 8 7890 0 200 345 9 7890 200 0 456

rohithverma · ‎01-22-2020

No, all the rows won't be like this but in between for some of the cheque id's the debit amount and credit are present as i mentioned in the question .So here the comparison should be made between the two rows and if debit is equal to credit then those two records should fetch in the output .Please ignore variable "X"

rohithverma · ‎01-22-2020

i have a input like sno loanno debit credit cheqno 1 1234 200 0 222 2 1234 0 200 222 Here we have to check whether the debit amount is equal to credit amount based on the cheqno only and if it is equal the o/p should be like sno loanno debit credit cheqno x 1 1234 200 0 222 2 2 1234 0 200 222 1

rohithverma · ‎11-27-2019

I just want to know is there any way of creating a library without using LIBNAME statement as I have faced this question in one my interview recently. Thank you

rohithverma · ‎11-27-2019

Is it possible to create a library without using libname statement in sas and also without using the options in menu bar ??

rohithverma · ‎11-27-2019

Thank you very much..!

Online Status	Offline
Date Last Visited	‎09-05-2025 03:24 AM

HASH PROGRAM TO UPDATE VALUES

Re: update master table with transaction table

update master table with transaction table

Re: HOW TO CHECK PREVIOUS ROW IS POSITIVE OR NEGATIVE

HOW TO CHECK PREVIOUS ROW IS POSITIVE OR NEGATIVE

Re: unable to read date value while connected to database

unable to read date value while connected to database

Re: SUM BASED ON ROW BY ROW

Re: SUM BASED ON ROW BY ROW

Re: SUM BASED ON ROW BY ROW

Re: Splitting of observations based on sum

Re: calling macro

Re: calling macro

Re: calling macro

Re: finding odd

Re: finding odd

Re: finding odd

Re: finding odd

finding odd

Re: reconcilation of amount

reconcilation of amount

reconcilation of debit and credit

Re: comparison between different columns in different rows

Re: comparison between different columns in different rows

Re: comparison between different columns in different rows

Re: comparison between different columns in different rows

comparison between different columns in different rows

Re: creating a library without using libname statement

creating a library without using libname statement

Re: calculate discount based on purchase amount