A TABLE CALLED TRANSACTION TABLE FOR CREDIT CARD CCNO IS GIVEN BELOW WITH CC NUMBER AND TRANSACTION

[sas_university]

* A TABLE CALLED TRANSACTION TABLE FOR CREDIT CARD CCNO IS GIVEN BELOW WITH
CC NUMBER AND TRANSACTION MODE*/
/* AGAINST EACH CCNUM.*/

/* WRITE THE CODE TO GET TOTAL TRANSACTION VALUE, TOTAL TANSACTION VALUE FOR
ONLINE CHANNEL*/
/* AND NO OF CARDS USED FOR OFFLINE CHANNEL IN A SINGLE QUERY*/

data Test;
infile datalines;
input SL_NO 1-14 CC_NO 22-24 TRANSACTION_MODE$;
datalines;
1 101 Online
2 101 Online
3 101 Offline
4 101 Offline
5 101 Offline
6 102 Offline
7 102 Offline
8 103 Online
9 103 Online
10 103 Online
;
run;

[PaigeMiller]

What variable is: TOTAL TANSACTION VALUE?

Please do not write in ALL CAPITAL LETTERS. Thanks.

[ballardw]

Since this appears to be homework what have you attempted and why do you think your attempt isn't working.

Any question needs to relate to variables. I don't see a clearly defined relationship between variables "CCNUM" and your data as well as the transaction value. I suppose that you have a different data set with transaction values somewhere as you don't show any. If someone provides you poor examples then it will be up to you to translate that poor description for others as we are not privy to any of the information other than what you show us. "Poor description" in this case is use of CCNO "CC Number" and CCNUM in a single sentence as it is not impossible that each refers to a separate thing but you only have one variable likely. So which interpretation could be important.