cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
chandler
‎08-31-2022
  • 62 Posts
  • 6 Likes Given
  • 0 Solutions
  • 0 Likes Received
About
Bachelor of Science - Alabama State Univ. - June 1978 Business Administration - Management Major, Computer Science Minor. In banking for 37 years. Last 15 years at Regions Bank in Birmingham, AL. Risk Management for last 19 years. Programming SAS last 8 years, for Business Banking - Performance Assessment and Reporting Group, at Regions Bank in Birmingham, AL. SAS Certified Base Programmer for SAS 9 since April 2013. I have used SAS for 8 + years. Comfortable with assigning variable values based on conditional logic, using IF-THEN/ELSE statements. Comfortable with creating datasets from raw data or from merging SAS files. Comfortable with ODS HTML, ODS PDF and ODS Tagsets.ExcelXP. I do a lot of ad hoc reporting on the bank's business loan portfolio. End users prefer output in Excel 2013 spreadsheets, so ODS destinations and PROC REPORT are my primary tools to output my reports to our webpage or email them.

Can PROC EXPORT be used on Base SAS v9.2 for Windows, to send data to ...

by Fluorite | Level 6 in SAS Procedures
‎06-04-2012 04:52 PM
‎06-04-2012 04:52 PM
Need to use proc export to send data to Excel 2007 file with file extension .xlsx.  I have Base SAS v9.2 for Windows, using Windows XP Professional operating system.   Does anybody have a DBMS reference that will work when exporting .xlsx files using proc export? I have tried DBMS = excelcs and it works from time to time but I haven't been able to find anything that will work in every situation. According to some SAS documentation you should be able to use "excel2007". This makes sense but it has not worked for me. I have seen some mention that if you don't have phase 2 of version 9.2 there is no good way, but I wanted to see if anybody here has been able to work around this. ... View more

Re: need help converting COBOL logic statements to SAS equivalent logi...

by Fluorite | Level 6 in ODS and Base Reporting
‎05-17-2012 01:28 PM
‎05-17-2012 01:28 PM
Than you, Cynthia, for your quick response.  I will checkout these links. ... View more

Re: need help converting COBOL logic statements to SAS equivalent logi...

by Fluorite | Level 6 in ODS and Base Reporting
‎05-17-2012 11:02 AM
‎05-17-2012 11:02 AM
Thanks, Cynthia.  I guess I mean the procedure division.  Here is a sample of the code.  I need to do a SAS equivalent to this EVALUATE procedure and COMPUTE procedures below:            IF WS-RESPONSE-CODE = DFHRESP(LENGERR)               MOVE ZEROES TO WS-RESPONSE-CODE            END-IF            EVALUATE WS-RESPONSE-CODE                     WHEN DFHRESP(NOTFND)                         INITIALIZE LO-WORK-GUARANTOR (1)                         INITIALIZE LO-WORK-GUARANTOR (2)                         INITIALIZE LO-WORK-GUARANTOR (3)                         INITIALIZE LO-WORK-GUARANTOR (4)                         INITIALIZE LO-WORK-GUARANTOR (5)                         INITIALIZE LO-WORK-GUARANTOR (6)                     WHEN DFHRESP(NORMAL)                         MOVE WS-LOSBMISC-REC TO WS-LOSBWORK-GAR-REC                         IF LO-WORK-GUARANTOR-OCCURS = +1                            INITIALIZE LO-WORK-GUARANTOR (2)                            INITIALIZE LO-WORK-GUARANTOR (3)                            INITIALIZE LO-WORK-GUARANTOR (4)                            INITIALIZE LO-WORK-GUARANTOR (5)                            INITIALIZE LO-WORK-GUARANTOR (6)                         END-IF                         IF LO-WORK-GUARANTOR-OCCURS = +2                            INITIALIZE LO-WORK-GUARANTOR (3)                            INITIALIZE LO-WORK-GUARANTOR (4)                            INITIALIZE LO-WORK-GUARANTOR (5)                            INITIALIZE LO-WORK-GUARANTOR (6)                         END-IF                         IF LO-WORK-GUARANTOR-OCCURS = +3                            INITIALIZE LO-WORK-GUARANTOR (4)                            INITIALIZE LO-WORK-GUARANTOR (5)                            INITIALIZE LO-WORK-GUARANTOR (6)                         END-IF                         IF LO-WORK-GUARANTOR-OCCURS = +4                            INITIALIZE LO-WORK-GUARANTOR (5)                            INITIALIZE LO-WORK-GUARANTOR (6)                         END-IF                         IF LO-WORK-GUARANTOR-OCCURS = +5                            INITIALIZE LO-WORK-GUARANTOR (6)                         END-IF                     WHEN OTHER                         GO TO U105-EXIT            END-EVALUATE.       *       * BEGIN INTERMEDIATE CALCS FOR GUARANTORS, (JUST LIKE QLOAPP84).       *            COMPUTE WS-GAR-CASH1-COL1 ROUNDED =                                    LO-WORK-GAR-SAL-PER1-AMT (1) +                                    LO-WORK-GAR-INTDIV-PER1-AMT (1) +                                    LO-WORK-GAR-SCHED-C-PER1-AMT (1) +                                    LO-WORK-GAR-CAPGAIN-PER1-AMT (1) +                                    LO-WORK-GAR-RENTS-PER1-AMT (1) +                                    LO-WORK-GAR-DEPR-ADJ-PER1-AMT (1) +                                    LO-WORK-GAR-INT-ADJ-PER1-AMT (1) +                                    LO-WORK-GAR-OTH-INC-PER1-AMT (1) -                                    LO-WORK-GAR-INC-TAX-PER1-AMT (1) -                                    LO-WORK-GAR-LIV-EXP-PER1-AMT (1). 006570*            COMPUTE WS-GAR-CASH1-COL2 ROUNDED =                                    LO-WORK-GAR-SAL-PER2-AMT (1) +                                    LO-WORK-GAR-INTDIV-PER2-AMT (1) +                                    LO-WORK-GAR-SCHED-C-PER2-AMT (1) +                                    LO-WORK-GAR-CAPGAIN-PER2-AMT (1) +                                    LO-WORK-GAR-RENTS-PER2-AMT (1) +                                    LO-WORK-GAR-DEPR-ADJ-PER2-AMT (1) +                                    LO-WORK-GAR-INT-ADJ-PER2-AMT (1) +                                    LO-WORK-GAR-OTH-INC-PER2-AMT (1) -                                    LO-WORK-GAR-INC-TAX-PER2-AMT (1) -                                    LO-WORK-GAR-LIV-EXP-PER2-AMT (1). 006570*            COMPUTE WS-GAR-CASH1-COL3 ROUNDED =                                    LO-WORK-GAR-SAL-PER3-AMT (1) +                                    LO-WORK-GAR-INTDIV-PER3-AMT (1) +                                    LO-WORK-GAR-SCHED-C-PER3-AMT (1) +                                    LO-WORK-GAR-CAPGAIN-PER3-AMT (1) +                                    LO-WORK-GAR-RENTS-PER3-AMT (1) +                                    LO-WORK-GAR-DEPR-ADJ-PER3-AMT (1) +                                    LO-WORK-GAR-INT-ADJ-PER3-AMT (1) +                                    LO-WORK-GAR-OTH-INC-PER3-AMT (1) -                                    LO-WORK-GAR-INC-TAX-PER3-AMT (1) -                                    LO-WORK-GAR-LIV-EXP-PER3-AMT (1). ... View more

need help converting COBOL logic statements to SAS equivalent logic st...

by Fluorite | Level 6 in ODS and Base Reporting
‎05-16-2012 02:02 PM
‎05-16-2012 02:02 PM
I have a text file from a programmer with the COBOL logic statements to perform some ratio calculations.   I need to build a program in SAS to do the same thing.  While I understand some of the COBOL logic, I need some examples to show me the equivalent statment in SAS code.  I would appreciate any link you can give me to documentation or a tutorial. ... View more

Matching or Cross-Referencing Multiple Accounts to One Transaction ID ...

by Fluorite | Level 6 in SAS Programming
‎03-23-2012 12:25 PM
‎03-23-2012 12:25 PM
In the attached spreadsheet you will see that there are three columns (Loan Number, TransID, and Related). What I would like for SAS to be able to do is to link every Loan Number that has the same TransID and put them in the Related column with a comma in between each one. So that if Loans COMM01 and COMM02 had the same TransID, in the Related column it would read COMM01, COMM02 for both of those loans. Loan Number TransID Related COMM0001 560 COMM0001, COMM0002 COMM0002 560 COMM0001, COMM0002 COMM0003 1727 COMM0003, COMM0004 COMM0004 1727 COMM0003, COMM0004 COMM0005 3032 COMM0005, COMM0006 COMM0006 3032 COMM0005, COMM0006 COMM0007 3591 COMM0007, COMM0008, COMM0009, COMM0010 COMM0008 3591 COMM0007, COMM0008, COMM0009, COMM0010 COMM0009 3591 COMM0007, COMM0008, COMM0009, COMM0010 COMM0010 3591 COMM0007, COMM0008, COMM0009, COMM0010 COMM0011 3971 COMM0011, COMM0012, COMM0013, COMM0014, COMM0015 COMM0012 3971 COMM0011, COMM0012, COMM0013, COMM0014, COMM0015 COMM0013 3971 COMM0011, COMM0012, COMM0013, COMM0014, COMM0015 COMM0014 3971 COMM0011, COMM0012, COMM0013, COMM0014, COMM0015 COMM0015 3971 COMM0011, COMM0012, COMM0013, COMM0014, COMM0015 ... View more

How Do You Insert a Title in PROC EXPORT to Excel/HTML?

by Fluorite | Level 6 in SAS Programming
‎03-23-2012 11:51 AM
‎03-23-2012 11:51 AM
I have a colleague who is trying to insert a title in a PROC EXPORT to Excel/HTML file.   Can someone direct me to the SAS documentation for this or give me exact code sample to do this? ... View more

Tips on making programs more efficient - server gives warning: phys...

by Fluorite | Level 6 in SAS Programming
‎03-06-2012 02:24 PM
‎03-06-2012 02:24 PM
We use a server with operating system Windows Server 2008 Standard, 64 bit.  SAS for Windows is loaded as release 9.2,  64 bit version. Our Information Technology department is not well versed on SAS and the needs of the SAS System.  There is a monitoring system in place and it keeps giving us these warnings:  "Spectrum ALARM - Physical Memory Usage Too High".   Has anybody ever dealt with this issue ? Some have suggested that the problem may be a few programmers, new to SAS,  running code that is not efficient, thus, using up a lot of physical memory.   My question is What tips can I give to the new guys about how to write more efficient code, without sending them off to a SAS training course? ... View more

ERROR: Cannot set AUTOCOMMIT=NO due to driver lim...

by Fluorite | Level 6 in SAS Procedures
‎01-27-2012 07:00 PM
‎01-27-2012 07:00 PM
Need help getting rid of this error.   The suggestion in the SAS documentation didn't work for me. ... View more

NOTE: Unable to open SASUSER.PROFILE.

by Fluorite | Level 6 in SAS Programming
‎10-13-2011 11:03 AM
‎10-13-2011 11:03 AM
Thank you, art297, the renaming of the PROFILE.sas7bcat to PROFILE.OLD,  as mentioned in the link http://support.sas.com/kb/12/502.html, worked for me.  ... View more

NOTE: Unable to open SASUSER.PROFILE.

by Fluorite | Level 6 in SAS Programming
‎10-12-2011 04:36 PM
‎10-12-2011 04:36 PM
Using SAS 9.2 TS Level 2M3, on Windows XP Pro platform.   After invoking SAS my autoexec prints this message to the log.  I can't find a support.sas.com listing with the same components as mine, to explain this situation.  Can anyone help me resolve this problem? ... View more

Re: PROC CONTENTS of entire library with all variables detail

by Fluorite | Level 6 in SAS Procedures
‎06-22-2011 05:24 PM
‎06-22-2011 05:24 PM
Sorry, my first post was not clear. I had to put "|" separaters in this message text to show column separation. It wouldn't let me display spaces in tabular format. VARIABLE | TABLE_NAME I borrower_name | Customer | address | Customer | account_num I Loan_Details | loan_amount | Loan_Details | interest_rate I Loan_Details | ... View more

PROC CONTENTS of entire library with all variables detail

by Fluorite | Level 6 in SAS Procedures
‎06-22-2011 05:14 PM
‎06-22-2011 05:14 PM
I am trying to output my results of PROC CONTENTS for an entire library, to a SAS dataset. I want the details of each variable and the dataset it is located in. Then export that dataset to Excel spreadsheet. I am using SAS 9.1.3 on WindowsXP Professional platform. I can't reach the person that did this before, but he got PROC CONTENTS to print variable name in first column followed by table name in second column, then attributes and other details in subsequent columns. This allowed anyone to search for a variable and immediately find the table it is located in. Example of what I want the layout to look like: VARIABLE TABLE NAME borrower_name Customer address Customer account_num Loan_Details loan_amount Loan_Details interest_rate Loan_Details ... View more

Re: Read existing View created by someone else

by Fluorite | Level 6 in SAS Procedures
‎05-11-2011 01:42 PM
‎05-11-2011 01:42 PM
Thanks, SPR, for your quick response. I will proceed with my data step code, as is. ... View more

Read existing View created by someone else

by Fluorite | Level 6 in SAS Procedures
‎05-11-2011 01:14 PM
‎05-11-2011 01:14 PM
I see a lot of SAS documentation on how to create a view, and efficiency and etc. etc., but nothing on syntax to just read the view to create a subset dataset for a report. I have access to a library of data from another department. In that library is a view, already created, and updated each month. I just need data from that view to create a subset that will be used for reporting purposes. I don't want to create the reports directly from that view, for safety and data integrity purposes and to prevent errors or overrwriting data. I want to write a data step to place the data from that view into a dataset in another library as follows: data mylib.acls_curr ; set loan.Month_end_data ; /** NOTE: "month_end_data" is an existing view **/ run; Someone, please help me with the syntax. ... View more

(GENNUM= ) Data Set Option

by Fluorite | Level 6 in SAS Programming
‎03-02-2011 12:37 PM
‎03-02-2011 12:37 PM
I am running SAS v9.1.3 SP4 on Windows XP operating system. In our data mart there are Generational Datasets for each monthend file, ie. MONTHEND, MONTHEND#1 MONTHEND#2 MONTHEND#3 All the SAS documentation I could fined only talks about creating and maintaining generational datasets, and how to do a PROC PRINT on a specific generation number, but no instructions on how to reference and retrieve data from a specific generation number, in a data step. I want to read data from MONTHEND#2, to create a subset of data, based on a where statement. Is this data step, below, the proper way to do that and is the syntax correct ? DATA newfile; set MONTHEND (GENNUM=2) ; where account_numbers gt "1234" ; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-31-2022 09:14 PM
Likes given to
Quick links