topic Re: How to present text block in Excel using Proc in SAS Procedures

How to present text block in Excel using Proc

hammerman — Fri, 10 Jun 2016 04:35:51 GMT

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.

Re: How to present text block in Excel using Proc

Reeza — Fri, 10 Jun 2016 04:45:15 GMT

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.

Re: How to present text block in Excel using Proc

RW9 — Fri, 10 Jun 2016 09:07:30 GMT

Sorry, what is the question?

Re: How to present text block in Excel using Proc

hammerman — Fri, 10 Jun 2016 09:18:06 GMT

I present a summary report on one sheet and on the other sheet I need to present the information which is attached with the post.
Issue I am having is the way text is needs to presented.

Re: How to present text block in Excel using Proc

Reeza — Fri, 10 Jun 2016 09:28:49 GMT

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?

Re: How to present text block in Excel using Proc

RW9 — Fri, 10 Jun 2016 09:39:20 GMT

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;

Re: How to present text block in Excel using Proc

hammerman — Mon, 13 Jun 2016 03:27:12 GMT

Thanks !!!