topic Re: A TABLE CALLED TRANSACTION TABLE FOR CREDIT CARD CCNO IS GIVEN BELOW WITH CC NUMBER AND TRANSACT in Statistical Procedures

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

sas_university — Thu, 01 Dec 2022 13:59:11 GMT

* 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;

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

PaigeMiller — Thu, 01 Dec 2022 14:03:18 GMT

What variable is: TOTAL TANSACTION VALUE?

Please do not write in ALL CAPITAL LETTERS. Thanks.

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

ballardw — Thu, 01 Dec 2022 15:58:53 GMT

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.