I have to present this information in excel.
Collection Agent | The collection agents contracted to the Dept are Humanity Corporation Pty Ltd. The role of these agents is to recover debts on behalf of the Dept |
Customer | An individual, group or organisation who has been allocated a Number |
Customer Payment | Customer payments include the following repayment methods: Credit Card Payments, Cash Payments, Cheque Payments, PayPal Payments, EFT Payments, Money Ord Payments or Deductions from the customer's bank account. |
Debt | An overpayment of a customer’s entitlement that is legally recoverable plus any additional charges. |
I have started with this, but need to go in a meeting now - you need to add in the Excel code to move bold text to center of cell.
data have; length col1 col2 $2000; infile datalines dlm="~"; input col1 $ col2 $; datalines; Collection Agent~The collection agents contracted to the Dept are Humanity Corporation Pty Ltd. The role of these agents is to recover debts on behalf of the Dept Customer~An individual, group or organisation who has been allocated a Number Customer Payment~Customer payments include the following repayment methods: Credit Card Payments, Cash Payments, Cheque Payments, PayPal Payments, EFT Payments, Money Ord Payments or Deductions from the customers bank account. Debt~An overpayment of a customer’s entitlement that is legally recoverable plus any additional charges. ; run; ods tagsets.excelxp file="c:\test.xml"; proc report data=have nowd; columns _all_; define col1 / " " order order=data style={cellwidth=5cm just=l font_weight=bold}; define col2 / " " style={cellwidth=10cm just=l}; compute before col1; line ''; endcomp; run; ods tagsets.excelxp close;
Place the data into a dataset, including blank lines, and use proc print to display it.
You can use either ODS Excel or Tagsets.ExcelXP or Proc Export.
Sorry, what is the question?
You need to be more specific please.
What is causing the issue? Have you tried the method suggested - creating a dataset and exporting?
How are you creating file currently?
I have started with this, but need to go in a meeting now - you need to add in the Excel code to move bold text to center of cell.
data have; length col1 col2 $2000; infile datalines dlm="~"; input col1 $ col2 $; datalines; Collection Agent~The collection agents contracted to the Dept are Humanity Corporation Pty Ltd. The role of these agents is to recover debts on behalf of the Dept Customer~An individual, group or organisation who has been allocated a Number Customer Payment~Customer payments include the following repayment methods: Credit Card Payments, Cash Payments, Cheque Payments, PayPal Payments, EFT Payments, Money Ord Payments or Deductions from the customers bank account. Debt~An overpayment of a customer’s entitlement that is legally recoverable plus any additional charges. ; run; ods tagsets.excelxp file="c:\test.xml"; proc report data=have nowd; columns _all_; define col1 / " " order order=data style={cellwidth=5cm just=l font_weight=bold}; define col2 / " " style={cellwidth=10cm just=l}; compute before col1; line ''; endcomp; run; ods tagsets.excelxp close;
Thanks !!!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: