BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
lbogar314
Obsidian | Level 7

My problem is this: I need to create individual reports with all reports being on a company letterhead that I have in a word/pdf file. My first approach to this was copying the header and footer images to put in the report but it distorts the images and makes them blurry.

 

What is the best way to accomplish this?  I've read a lot of documentation but I am still not sure what the most painless way to get this done is and I know I am probably overthinking it at this point.  Basically I just want to generate multiple single page pdf reports onto the same static letterhead template I was given.  If anyone could point me in the right direction I'd really appreciate it.  🙂

1 ACCEPTED SOLUTION

Accepted Solutions
lbogar314
Obsidian | Level 7

I resized the picture before putting it in the report and it seems to be much clearer- I'm not sure why I didn't think of trying that sooner.  

View solution in original post

6 REPLIES 6
Reeza
Super User

You're using the correct approach, get the image as a PNG or SVG file so it scales properly. 

Post the code to show how you're doing it-maybe you're missing a step to control the resolution. 

 


@lbogar314 wrote:

My problem is this: I need to create individual reports with all reports being on a company letterhead that I have in a word/pdf file. My first approach to this was copying the header and footer images to put in the report but it distorts the images and makes them blurry.

 

What is the best way to accomplish this?  I've read a lot of documentation but I am still not sure what the most painless way to get this done is and I know I am probably overthinking it at this point.  Basically I just want to generate multiple single page pdf reports onto the same static letterhead template I was given.  If anyone could point me in the right direction I'd really appreciate it.  🙂


 

lbogar314
Obsidian | Level 7
proc report data = Reporting split= ' ';

	title j=left "^S={preimage='P:\sasusers\lb\Header.png?width=2.5in&height=0.74in'}";

	column user_id description response; 

	define user_id / group noprint ; 
	define description / left width = 200 flow display "Skill Tested" ; 
	define response / display "Result" center; 

	break after user_id / page;



run;

The Word document I got it from says the original image size 2.37" by 8.02" which scaled to 0.74" by 2.5".

lbogar314
Obsidian | Level 7

I resized the picture before putting it in the report and it seems to be much clearer- I'm not sure why I didn't think of trying that sooner.  

Reeza
Super User
One other issue I've seen, Adobe PDF doesn't show it well for some reason so you think the resolution is crap, but when you print it or view in other viewers it's fine. Glad you got it working - especially since it is the right way to do it!
lbogar314
Obsidian | Level 7

Definitely a good thing to note! Is it possible to have text on the same line as the image?  Basically I want to have the logo on the left side and then start a few lines of text in that same area on the right.  Thank you.  🙂

Reeza
Super User
Yes, but then you're likely messing around with ODS LAYOUT but that's not something I'm very familiar with. I would suggest marking this answered -your own answer is fine and then starting a new thread with your new question.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 985 views
  • 4 likes
  • 2 in conversation