Proc Report or Proc template is Best for custom grouping?

[Stalk]

I am generating .pdf report and have three questions?

1) I am getting error for .pdf file. What file is it looking for?

 ods pdf FILE="C:\Temp\MVS.pdf";
ERROR: Physical file does not exist, C:\ProgramFiles\SASHome94\ReportFontsforClients\9.4\saswcur.ttf.

2) can we add style to the column headers and make it blue color for .PDF report?

3) How do I group after certain fields. Calc.Conc.Mean, recovery Mean, Conc Cv, R from Curve?

Test	Quality	Dilution	Concentration	Well	Calc.	%	Calc.			R
					Concentration	Recovery	Conc.	Recovery	Conc.	from
							Mean	Mean	CV	curve
NTL	QC1.1	5000	229	A03	190.58	83.22	191.88	83.79	0.96	1
				B03	193.18	84.36	191.88	83.79	0.96	1
	QC1.2	5000	39	C03	32.18	82.51	31.99	82.03	0.84	1
				D03	31.8	81.54	31.99	82.03	0.84	1
	QC1.3	5000	12.5	E03	10.01	80.11	9.86	78.86	2.25	1
				F03	9.7	77.6	9.86	78.86	2.25	1
DDD	QC1.1	5000	976	A03	751.33	76.98	769.27	78.82	3.3	0.9999
				B03	787.21	80.66	769.27	78.82	3.3	0.9999
	QC1.2	5000	288	C03	250.43	86.96	252.39	87.64	1.1	0.9999
				D03	254.36	88.32	252.39	87.64	1.1	0.9999

Here is my code..

options orientation=landscape;
ods pdf FILE="c:temp\test.pdf";
proc report data=qc_final Headline headskip nowd split='*' ;
columns Test Quality Dilution Conc well
mean_calc_conc mean_pct_recovery
mean_Calc_Conc_Mean mean_PCT_RecMean
mean_Calc_Conc_CV mean_RSquared ;

define Test / order "Test" width=20;
define Quality / order "Quality" width=30;
define Dilution / order width=10;
define Conc / order "Concentration" width=10;
define Well / order "Well" width=7;
define mean_calc_conc / order "Calc. * Concentration " width=10;
define mean_pct_recovery / group /*order*/ " Recovery" width=7;
define mean_Calc_Conc_Mean / group /*order*/ "Calc. * Conc. * Mean" width=10;
define mean_PCT_RecMean / group /*order*/ "% * Recovery * Mean" width=7;
define mean_Calc_Conc_CV / group /*order*/ "Calc. * Conc. * CV" width=10;
define mean_RSquared / group /*order*/ "R * from * curve" width=7;

run;
ods pdf close;

Thank you

[Reeza]

1. Are you using SAS On Demand or SAS installed in a server installation? If so, it does not have access to your C drive and you need to save the file somewhere you do have access to. It depends on your installation so you need to provide more information for us to answer this.
2. Yes, you can add STYLE to colour headers.

   style(Header) = Header{background = Blue};

3. No idea what you mean, please clarify by showing a picture of what you have versus what you need.

---

@Stalk wrote:

I am generating .pdf report and have three questions?

1) I am getting error for .pdf file. What file is it looking for?

 ods pdf FILE="C:\Temp\MVS.pdf";
ERROR: Physical file does not exist, C:\ProgramFiles\SASHome94\ReportFontsforClients\9.4\saswcur.ttf.

2) can we add style to the column headers and make it blue color for .PDF report?

3) How do I group after certain fields. Calc.Conc.Mean, recovery Mean, Conc Cv, R from Curve?

Test	Quality	Dilution	Concentration	Well	Calc.	%	Calc.			R
					Concentration	Recovery	Conc.	Recovery	Conc.	from
							Mean	Mean	CV	curve
NTL	QC1.1	5000	229	A03	190.58	83.22	191.88	83.79	0.96	1
				B03	193.18	84.36	191.88	83.79	0.96	1
	QC1.2	5000	39	C03	32.18	82.51	31.99	82.03	0.84	1
				D03	31.8	81.54	31.99	82.03	0.84	1
	QC1.3	5000	12.5	E03	10.01	80.11	9.86	78.86	2.25	1
				F03	9.7	77.6	9.86	78.86	2.25	1
DDD	QC1.1	5000	976	A03	751.33	76.98	769.27	78.82	3.3	0.9999
				B03	787.21	80.66	769.27	78.82	3.3	0.9999
	QC1.2	5000	288	C03	250.43	86.96	252.39	87.64	1.1	0.9999
				D03	254.36	88.32	252.39	87.64	1.1	0.9999

Here is my code..

options orientation=landscape;
ods pdf FILE="c:temp\test.pdf";
proc report data=qc_final Headline headskip nowd split='*' ;
columns Test Quality Dilution Conc well
mean_calc_conc mean_pct_recovery
mean_Calc_Conc_Mean mean_PCT_RecMean
mean_Calc_Conc_CV mean_RSquared ;

define Test / order "Test" width=20;
define Quality / order "Quality" width=30;
define Dilution / order width=10;
define Conc / order "Concentration" width=10;
define Well / order "Well" width=7;
define mean_calc_conc / order "Calc. * Concentration " width=10;
define mean_pct_recovery / group /*order*/ " Recovery" width=7;
define mean_Calc_Conc_Mean / group /*order*/ "Calc. * Conc. * Mean" width=10;
define mean_PCT_RecMean / group /*order*/ "% * Recovery * Mean" width=7;
define mean_Calc_Conc_CV / group /*order*/ "Calc. * Conc. * CV" width=10;
define mean_RSquared / group /*order*/ "R * from * curve" width=7;

run;
ods pdf close;

Thank you

---

[Stalk]

Thank you Reeza for your reply.

I have Base SAS on my machine. I guess I need to download the font?

Once my .pdf is working, I will try the style options.

Regarding the 3rd questions..

In my table last 4 columns have duplicate values. Is there a way to group them and show as follows?

Test	Quality	Concentration	Well	Calc.		Calc.			R
				Concentration	Recovery	Conc.	Recovery	Conc.	from
						Mean	Mean	CV	curve
NTL	QC1.1	229	A03	190.58	83.22	191.88	83.79	0.96	1
			B03	193.18	84.36
	QC1.2	39	C03	32.18	82.51	31.99	82.03	0.84	1
			D03	31.8	81.54

[Reeza]

Assigning those as GROUP variables should work. But you need to make sure they're exact duplicates ie 191.881 versus 191.882. I'm not sure if column ordering also matters here - it would make intuitive sense to have all GROUPING variables first, but not sure if PROC REPORT enforces that.

Are there warning or notes in the log?

[Stalk]

My .pdf is still not working because of font issue. HTML output is working, but..

No errors or warnings but the grouping is also not working for the last 4 columns.

[Reeza · Accepted solution]

Why do you think you have a font issue if you have no warnings or errors?
Have you tried switching fonts as well?

[Stalk]

Fonts are missing in my default location. I got the following solution from SAS support and it's resolved.

Download to your local Windows machine a copy of the following zip file:

sasfonts94.zip

Via the following URL:

http://ftp.sas.com/techsup/download/graph/sasfonts94.zip

After downloading this .zip file, unzip the contents of it into the following directory:

C:\Program Files\SASHome94\ReportFontsforClients\9.4