Dear experts,   I have some graphs created by gchart , gplot procedure . I want to have border around graph . I thought goptions border will de the work but I guess I miss something as it does not work for PDF destination . I see border in SAS report tab in SAS EG but when I open pdf file . it does not have graph.   Any idea how to get borders ?    I use SAS 9.2 + linux OS . see example code    ********************************************************; ods pdf file= "/tmp/test.pdf"; goptions reset=all border ; title "US Electric Power - Revenue and Generation Sources"; proc gchart data=sashelp.electric (where=(year >= 2000)) ; vbar year / discrete sumvar=Revenue subgroup=Customer; run; quit; ods pdf close; ******************************************************; ... View more

Dear SAS experts,   I am creating PDF report where I need to make four graphs and two summary reports on single page . I used  http://support.sas.com/kb/41/461.html   as reference to keep graphs on same page and that works .   Problem : I am not able to put graphs ( gplot and gchart) and summary( proc report) together on same page . Summary should be  placed in bottom of the pdf report.   My summary report contains just one column and one row . so if you want a sample , you can use sashelp.class with just mean(age).   What I tried : tried to create a summary report as graph , so that I could use that in image in proc greplay to place it along with four graphs , but I could not succeed in creating png file from summary report.         ... View more

Dear experts,   I am using SAS 9.4 + SAS management consol 9.4 I have below specific questions.   1. How to create metadata libraries in batch mode . For example If my end user needs a library then I have to create that in SAS management consol manually , I want to do that by using some code where I just pass required details and its done , instead of point and click in management consol. 2. how to apply an ACT on other ACTs using batch mode ? I know of a batch tool "sas-set-metadata-access" but I am unable to use it to apply an ACT on another ACT. ( i used it to apply ACTs on metadata folders) .   ... View more

Dear SAS Experts, Can you explain me or give pointers for below questions ? I am using sas 9.4 on linux machine 1. how sas knows which config files to use for execution of a sas code ? if I execute below code from command line then I see sas is using combination of 3 config files . which place in the system we instruct sas to use these combination?   proc options option=config; run; log file  ------------------------------ CONFIG=( /sas/software/SASInstallFolder/SASFoundation/9.4/sasv9.cfg /sas/software/SASInstallFolder/SASFoundation/9.4/nls/en/sasv9.cfg /sas/software/SASInstallFolder/SASFoundation/9.4/sasv9_local.cfg ) Specifies the configuration file that is used when initializing or overriding the values of SAS system options. NOTE: PROCEDURE OPTIONS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds -------------------------------------   2. I have to override certain options ( say memsize) by using extra config file ( say extra.cfg) . how to instruct sas to use extra config by keeping all other options same . how to form command which uses four or more config file? something like this   /sas/software/SASHome/SASFoundation/9.4/sas -sysin test.sas -log test.log -config <using combination of four config file> ... View more

Dear Admins,   1. I am migrating 9.2 security to 9.4 . Is there any way to know which folders or places an ACT is applied? I see many custom ACTs in my environment and want to check if they are used at all or not? basically I want to get rid of them if they are not used anywhere. 2. Also is there any way to export security of version 9.2 to 9.4 ? I do not see export package option in9.2 but the same is available from 9.3 onwards. 3. Is there way to create report on existing ACTs with their Authorisation and permission pattern?   TIA   ... View more

For example take sashelp.cars dataset. I want to print image of each model in my final output along with other columns like horsepower etc . I have .jpg images saved externally with model name and want to print right image in front of right model . This means that for each row I might have different image .   i would like output in Excel if not possible then PDF.   Can anyone help me how to do this in SAS9.2 ? Below is sample code but I do ot know how to add a column with image as content of it.   ods pdf file="&output_location./report.html"; proc report data=sashelp.cars(keep=model type horsepower origin); where origin='Europe' and type='Sedan'; column model horsepower; run; ods pdf close; ... View more