topic Re: Rescale pictures inserted in PROC REPORT columns in SAS Programming

Rescale pictures inserted in PROC REPORT columns

hartwell — Mon, 07 Apr 2025 15:41:56 GMT

I am trying to insert pictures within a PROC REPORT. I believe I understand the basic mechanics, but would like the picture to shrink to fit if the cellwidth is not as wide as the picture. Is this something that can be done?

proc report data=dsn nowd;
    column image;
    define image / "TITLE" computed style(column)=[cellwidth=4in];

    compute image / char;
        call define(_col_,'style',"style=[preimage='/path/SGPlot1.png']");
    endcomp;
run;

The code above is what I used to produce the PROC REPORT to insert a single image. It cuts off the right-hand side of the image because the image is just a little bit wider than the 4in cellwidth I declared. I would like it to instead shrink the image.

Re: Rescale pictures inserted in PROC REPORT columns

Cynthia_sas — Mon, 07 Apr 2025 17:15:37 GMT

Hi, My experience using images with PROC REPORT and inserting the image into a cell is that the image does not "autosize" -- so I generally had to use a paint program to get the image to the approximate size I needed before I inserted it into the output. It may also make a difference whether your ODS output destination is HTML, RTF, PDF, etc.
Cynthia

Re: Rescale pictures inserted in PROC REPORT columns

Ksharp — Tue, 08 Apr 2025 01:58:26 GMT

Or you can refit this graph when you are creating "SGPlot1.png". like:

ods graphics/width=500px height=300px image_name="SGPlot" outputfmt=png;