topic Re: Proc Report or Proc template is Best for custom grouping? in SAS Programming

Proc Report or Proc template is Best for custom grouping?

Stalk — Mon, 26 Jul 2021 15:50:53 GMT

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

Re: Proc Report or Proc template is Best for custom grouping?

Reeza — Mon, 26 Jul 2021 16:18:17 GMT

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.

Yes, you can add STYLE to colour headers.

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

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

Re: Proc Report or Proc template is Best for custom grouping?

Stalk — Mon, 26 Jul 2021 16:58:31 GMT

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

Re: Proc Report or Proc template is Best for custom grouping?

Reeza — Mon, 26 Jul 2021 17:09:54 GMT

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?

Re: Proc Report or Proc template is Best for custom grouping?

Stalk — Mon, 26 Jul 2021 18:21:59 GMT

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.

Re: Proc Report or Proc template is Best for custom grouping?

Reeza — Mon, 26 Jul 2021 19:06:05 GMT

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

Re: Proc Report or Proc template is Best for custom grouping?

Stalk — Fri, 30 Jul 2021 13:26:48 GMT

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