Does it have to be in PROC SQL? PROC CONTENTS will give you that information as well. ... View more

Yes that is also a good idea. In live environments where we have end users with access to files it may just be helpful to give permissions once the entire job processing is complete. Wouldn't want someone opening a file in SAS while process is running. May cause job to abend. So the method you would want to use may be subjective to the type or environment setup and your process. ... View more

Hi Vijay, As per the proc content screenshot, we believe the date is in character format. In order to perform the calculation on the date, we need to convert the date to numeric, so we need to read the date in numeric format, you can use the informat anydtdte. to read the date converting it to sas date value on which you can perform the calculation. The interesting thing about this informat anydtdte. is that it can read any type of date whether mmddyy or ddmmyy or any other. you can use it in the following way similar to snoopy369, just change the format select(input(tab1.mndate,anydtdte.) - input(tab2.mndate,anydtdte.)) ... Hope this works. Thanks, Jagadish ... View more

Hi:   If these Tech Support notes don't help, you might consider opening a track with Tech Support. You probably will NOT need to use ODS ESCAPECHAR to make this work. However, the version of SAS that you are using might impact whether the techniques in these notes work. There were issues in earlier versions of SAS that don't exist in SAS 9.2 and later. http://support.sas.com/kb/24/459.html http://support.sas.com/kb/24/174.html http://support.sas.com/kb/37/323.html cynthia ... View more

Hi:   If you search for previous forum postings, you will see that this question has come up several times. https://communities.sas.com/message/10450#10450 https://communities.sas.com/message/56745#56745   This Tech Support note explains how to use a style template to insert a banner image into PDF output: http://support.sas.com/kb/5/285.html  (Note that they use STYLE TABLE as the recommended template approach, and NOT STYLE BODY, as you show in your attempt.)      Otherwise, this Tech Support note: http://support.sas.com/kb/36/707.html shows how to use the PREIMAGE style attribute to insert a logo into a title statement. You can use the PREIMAGE attribute either with or without the URL= attribute shown in this note.   Do note, that if you use the PREIMAGE technique, you cannot also use the ESCAPECHAR and/or functions for page numbering: http://support.sas.com/kb/34/573.html   cynthia ... View more

Thanks Cynthia for your reply. ... View more

Thanks Ballard for you reply. Your explanation is correct! But, I have used YEAR4. because I want yearly average per BAR... and for the plot I wanted all the points plotted.  But the problem is that the plot is plotting at midpoints only. Is there some trick to have plot display all the values? In short, for BAR... it should group while for PLOT it should not group. ... View more