Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- About NITYA0411
03-06-2024
NITYA0411
Calcite | Level 5
Member since
03-28-2021
- 5 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by NITYA0411
Subject Views Posted 1573 03-06-2024 06:18 PM 750 03-28-2021 06:13 PM 821 03-28-2021 02:36 PM 821 03-28-2021 02:35 PM 823 03-28-2021 02:34 PM -
Activity Feed for NITYA0411
- Posted Re: Orion Star Data on SAS Procedures. 03-06-2024 06:18 PM
- Posted Re: Question 1: Using SAS code (proc sql, data steps, any other functions and procedures), create a on SAS Programming. 03-28-2021 06:13 PM
- Posted Re: Question 1: Using SAS code (proc sql, data steps, any other functions and procedures), create a on SAS Programming. 03-28-2021 02:36 PM
- Posted Re: Question 1: Using SAS code (proc sql, data steps, any other functions and procedures), create a on SAS Programming. 03-28-2021 02:35 PM
- Posted Question 1: Using SAS code (proc sql, data steps, any other functions and procedures), create a data on SAS Programming. 03-28-2021 02:34 PM
03-06-2024
06:18 PM
I am learning SAS by my self. does anyone have any link to orion star data sets?
... View more
03-28-2021
06:13 PM
HI, Thank you for your response. I really appreciate it. Tried using proc summary, but showing this error. ERROR: Variable BALANCE in list does not match type prescribed for this list.
... View more
03-28-2021
02:36 PM
DONT KNOW WHICH DATE FORMAT WIL BE USED, AND HOW TO GET THE TOTAL FOR EACH CUSTOMER
... View more
03-28-2021
02:35 PM
Question 1: Using SAS code (proc sql, data steps, any other functions and procedures), create a dataset showing the total balance in chequing and savings accounts for each customer on November 30, 2020. THIS IS THE QUESTION
... View more
03-28-2021
02:34 PM
DATA ACCT;
INPUT ACCOUNT_ID ACCOUNT_TYPE$ BALANCE$ BALANCEDATE DATE9.;
FORMAT BALANCEDATE DATE9.;
DATALINES;
123 CHEQUING $234 30-NOV-20
234 CHEQUING $100 30-NOV-20
321 SAVING $150 30-NOV-20
456 CHEQUING $10,000 30-NOV-20
678 CARD $435 30-NOV-20
789 INVESTMENT $999 31-OCT-20
123 CHEQUING $155 31-OCT-20
234 CHEQUING $67 31-OCT-20
321 SAVING $0 31-OCT-20
456 CHEQUING $1,000 31-OCT-20
234 CHEQUING $500 30-SEP-20
321 SAVING $250 30-SEP-20
;
RUN;
DATA ACCTXREF;
INPUT ACCOUNT_ID CUSTOMER_ID ACCOUNT_MONTH DATE9.;
FORMAT ACCOUNT_MONTH DATE9.;
DATALINES;
123 3010 30-NOV-20
234 3010 30-NOV-20
234 8788 30-NOV-20
321 4556 30-NOV-20
456 6789 30-NOV-20
678 4510 30-NOV-20
789 3319 30-NOV-20
123 3010 31-OCT-20
234 3010 31-OCT-20
234 8788 31-OCT-20
321 4556 31-OCT-20
456 6789 31-OCT-20
234 3010 30-SEP-20
234 8788 30-SEP-20
321 4556 30-SEP-20
;
RUN;
PROC SORT DATA=ACCT;
BY ACCOUNT_ID;
RUN;
PROC SORT DATA=ACCTXREF;
BY ACCOUNT_ID;
RUN;
DATA MERG;
MERGE ACCT ACCTXREF(RENAME=(ACCOUNT_MONTH=BALANCEDATE));
BY ACCOUNT_ID;
RUN;
DATA TASK1;
SET MERG;
WHERE ACCOUNT_TYPE IN("CHEQUING","SAVING");
WHERE ALSO BALANCEDATE='30NOV-20'D;
RUN;
PROC SORT DATA=TASK1;
BY CUSTOMER_ID;
RUN;
DATA TASK_1;
SET TASK1;
BY CUSTOMER_ID;
IF FIRST.CUSTOMER_ID=1 THEN TOTAL_BALANCE=BALANCE;
ELSE TOTAL_BALANCE=BALANCE+TOTAL_BALANCE;
RUN;
... View more
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
03-06-2024
09:53 PM
|
