04-19-2020
Lvp8906
Fluorite | Level 6
Member since
04-15-2020
- 4 Posts
- 4 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by Lvp8906
Subject Views Posted 1023 04-18-2020 07:43 PM 1102 04-18-2020 06:29 PM 1053 04-15-2020 05:18 PM 1099 04-15-2020 04:54 PM -
Activity Feed for Lvp8906
- Liked Re: How to transform accounts and balances are on one line for SASKiwi. 04-18-2020 11:11 PM
- Posted Re: How to transform accounts and balances are on one line on SAS Programming. 04-18-2020 07:43 PM
- Posted How to transform accounts and balances are on one line on SAS Programming. 04-18-2020 06:29 PM
- Liked Re: How to make SAS read date for SASKiwi. 04-15-2020 05:52 PM
- Liked Re: How to make SAS read date for novinosrin. 04-15-2020 05:48 PM
- Liked Re: How to make SAS read date for novinosrin. 04-15-2020 05:19 PM
- Posted Re: How to make SAS read date on SAS Programming. 04-15-2020 05:18 PM
- Posted How to make SAS read date on SAS Programming. 04-15-2020 04:54 PM
-
Posts I Liked
Subject Likes Author Latest Post 2 1 1 2
04-18-2020
07:43 PM
If i use PROC transpose how should it be done? like this? PROC transpose data= ACCOUNTS out=output-Accounts ; var Customer ; by Balance; run; PROC PRINT DATA= output-Accounts; RUN;
... View more
04-18-2020
06:29 PM
Here's the photo of my data And here's my code DATA ACCOUNTS;
infile datalines dsd dlm=',';
INPUT Customer $ Account $ Balance;
DATALINES;
Smith ,Checking ,1000.00
Smith, Saving ,4000.00
Smith ,Mortgage ,150000.00
Smith ,Credit Card ,500.00
Jones ,Checking ,973.78
Jones ,Savings ,2613.44
Jones ,Mortgage , .
Jones ,Credit card ,140.48
Brown ,Checking ,200.23
Brown ,Savings ,402.88
Brown ,Mortgage ,74000.00
Brown ,Credit Card , .
RUN;
PROC PRINT DATA= ACCOUNTS;
Run; Beginner here... the question above are confusing, she want us to have accounts balance credit mortgage into one line and the rest of column show the balance. in the input line, should I just type in INPUT: Customer checking savings Mortgage credit card and retype the datalines with balance? How is this work
... View more
04-15-2020
05:18 PM
Thank you so much!, why do you use $3 instead $4 i don't understand the $ sign, is that mean by columns? 3rd column?
... View more
04-15-2020
04:54 PM
Sorry beginner here How to make SAS read the date, when I proc print there's nothing print for dates DATA bp; INFILE DATALINES; input id ; $4 dob : mmddyy10. $4 admit : mmddyy10. $4 dischrg : mmddyy10. fee ; DATALINES; 001 10/21/1946 12/12/2004 12/14/2004 8000 002 05/01/1980 07/08/2004 08/08/2004 12000 003 01/01/1960 01/01/2004 01/04/2004 9000 004 06/23/1998 11/11/2004 12/25/2004 15123 run; PROC PRINT DATA= bp; RUN;
... View more