Can you clarify what documentation you are referencing? ... View more

With the ODS EXCEL destination, you need to use the EMBEDDED_TITLES= suboption as shown below: ods excel file="C:\Users\Name\Documents\EPI 612\Lab1Table1Excel.xlsx" options (sheet_name="Rates" embedded_titles='yes'); The documentation shows the other suboptions that are useful: ODS EXCEL Options  ... View more

Please include your SAS log that shows the code you are running and any messages you are getting. If you can provide sample data that would also be helpful. ... View more

The following is in the documentation under Required arguments: report-item specifies a data set variable, a computed variable, or a statistic to associate the compute block with. You must include the report item in the COLUMN statement. If the item is a computed variable, then you must include a DEFINE statement for it. Note The position of a computed variable is important. PROC REPORT assigns values to the columns in a row of a report from left to right. Consequently, you cannot base the calculation of a computed variable on any variable that appears to its right in the report. I would also suggest the following paper: https://support.sas.com/resources/papers/proceedings15/SAS1642-2015.pdf      ... View more

Here is a good explanation from the documentation: Processing a DATA Step: A Walk-Through  ... View more

That does not give a Division by zero Note. What are you expecting in this case? data test; a=25; b=-1E-16; if b ne 0 then percentage=(a-b)/b; else percentage=0; run; proc print; run; ... View more

You could use an IF condition like the following: data test; a=25; b=0; if b ne 0 then percentage=(a-b)/b; else percentage=0; run; proc print; run; ... View more

Please send the complete log that shows the code you are running and the messages you are getting. ... View more

Can you try adding the $ to your ARRAY statements as I mentioned in my previous post: /* Array for diagnosis codes */ array dx_vars {*} $ I10_DX1-I10_DX25; /* Array for procedure codes */ array pr_vars {*} $ I10_PR1-I10_PR10; ... View more

Since the variables are character, you need to use $ in the ARRAY statement. Also Array pr_vars is missing an underscore. /* Array for diagnosis codes */ array dx_vars {*} $ I10_DX1-I10_DX25; /* Array for procedure codes */ array pr_vars {*} $ I10_PR1-I10_PR10;   ... View more

If you are using PROC IMPORT to import the Excel file, you will need to use a UTF-8 encoded session of SAS. This will preserve the special symbols, but it will not preserve the line breaks. The following worked for me as an example, and then I just added line breaks in the Word file as desired. An alternative would be to hard-code the text using your own ODS TEXT= statements or PROC ODSTEXT. proc import datafile='your_path\sample data.xlsx' out=sample_data dbms=xlsx replace; run; /* may need to remove embedded quotes to not conflict with resolving macro variable in double quotes */ data sample_data; set sample_data; policy=compress(compress(policy,'"'),"'"); run; proc sql noprint; select POLICY into :POLICY from sample_data; quit; %put &policy; ods listing close; ods escapechar='^'; ods rtf file='your_path\test.rtf'; ods text="^S={font_face='Times New Roman' font_size=11pt just=left} &POLICY"; proc print data=sashelp.class; run; ods rtf close; ods listing; ... View more

You can use dictionary tables and create a macro variable of the list of desired variable names. proc sql noprint; select name into :varlist separated by ' ' from dictionary.columns where libname='WORK' and memname='MYDATA' /* must be uppercase */ and upcase(name) like "Q%"; quit; %put &varlist; data myout; set mydata; keep &varlist; run; proc print data=myout; run; ... View more