Hi, I have a column in my table          Alphabetic List of Variables and Attributes  #    Variable               Type     Len    Format       Informat 1    MNDATE             Char      26      $26.           $26. Now when I try to do,        select  (tab1.mndate - tab2.mndate )  as duration   ......  ........  ...; it says , cant subtract char... What should I do to substract the dates.... ?  (  I cannot change my column type...)     Experts please help.... ... View more

Hi  Experts, Could you please tell me the proc sql query in SAS  that will output the size of a table(in MB or GB)  in SAS ? ... View more

Hi experts, I execute a data step using enterprise guide. data newtable;      set existtab;           code statement1..           code statement2... run; after this data step is it possible to set desired read /write permission for this new table.  (by using sas code only)? (Like how we change read/write permission of a file with a Unix command on unix prompt  -> chmod 666 filename; similarly can we do that using SAS code...???) ... View more

HI, in the title statement , there is an option named LINK. Is it possible to jump to any page within a pdf using this 'link'?  that is ,  can we write soemthing like   link="#refval"   ??  I tried using escape character in title statment but it doesn't support escape characters. please help on this. ... View more

Hi , To add a logo to the first pdf page , I created a style as below proc template;      define style lg;      parent=styles.printer;      style body from document /      background=_undef_      backgroundimage="logo.jpg";      end; run; But this logo gets added to every pdf page which is not the requirement.  I used ODS PDF style=none after the first page..., but still no success. Please help! ... View more

Hi, I am creating a pdf and displaying data and graph in that  and using hyperlink in footnotes, trying to visit the previous pages. when I use the goptions reset=all;  or goptions device=png;   , the escapechar in footnote doesn't work. and because of that hyperlink doesn't   ..what could be the reason. The escape charcater though works with  'ods pdf text' statements.... Below is the code... Please guide... data dat1;      input year s1 s2 s3 s4;      cards;      1960 109 90 26 46      1970 260 223 130 131      1980 710 824 522 632      1990 1676 1600 1083 1363      1995 2114 2164 1631 1865      2000 2535 2748 2012 2362      ; run; data dat2;      set dat1;      sum=s1+s2+s3+s4; run; options mlogic symbolgen mprint; /*goptions reset=all;  goptions device=png; */ %macro makebar();      options orientation=portrait;      goptions ftext='Arial' gunit=pct  htext=1 ctext=green rotate=portrait;      footnote1 j=left wrap "Link to 1st Page ->>" j=right "^S={&TOCfmth URL='#First1'} First";      footnote2 j=left wrap "Link to 2nd Page ->>" j=right "^S={&TOCfmth URL='#Second2'} Second";      footnote3 j=left wrap "Link to 3rd Page ->>" j=right "^S={&TOCfmth URL='#Third3'} Third";      proc gchart data=dat2;           vbar year/sumvar=sum width=15;      run; %mend; %macro start();      ods listing close;          ods escapechar="^";      ods pdf file="Vk1.pdf" notoc;      %let TOCfmth = %str(JUST=LEFT VJUST=MIDDLE CELLHEIGHT=14PT FONT_SIZE=10PT CELLWIDTH=145CM linecolor=white);      ods pdf startpage=yes;      ods pdf anchor = "First1";      ods pdf text = "^S={&TOCfmth}First Page";      ods pdf startPage=yes;      ods pdf anchor = "Second2";      proc print data=dat1;run;      ods pdf startPage=yes;      ods pdf anchor = "Third3";      proc print data=dat2;run;      %makebar;      ods pdf close;      ods listing; %mend; %start; ... View more

Hello Experts, Need your suggestions/help for the problem I am facing. Here is the dataset, the code and the current output: Dataset: Period Amount Change 31/03/07 100 3.5 30/06/07 110 3 30/09/07 116 10 31/12/07 125 4 31/03/08 118 3.2 30/06/08 128 3 30/09/08 135 3.5 31/12/08 140 4 31/03/09 145 2 30/06/09 153 12 30/09/09 130 1.5 31/12/09 135 1 31/03/10 120 1.5 30/06/10 140 2 30/09/10 152 1 31/12/10 164 2 31/03/11 175 1.5 30/06/11 180 15 30/09/11 188 2 31/12/11 195 1.7 CODE: /*****************************************************/ symbol1 value=dot height=0.25 interpol=join color=red; axis1 minor=none label=(angle=90 "change") ; axis3 minor=none label=("Year") ; axis2 minor=none label=(angle=270 color=red "amount") value=(color=red); proc gbarline data=GBARLIN1;       bar period / discrete type=mean  sumvar=change raxis=axis1 maxis=axis3 inside=mean width=8 space=4;       plot/sumvar=amount axis=axis2;       format period year4.;       format change 4.1;       format amount 3.;       run; quit; /*****************************************************/ Current OUTPUT: The issues are: 1) For the plot , I needed the amount to be plotted and not their SUM or MEAN...That is no statistics...How do I achieve this? 2) Can I plot all the values on the line (i.e., all the quarter values)  not just values at midpoint?  (that is the bars will be yearly mean of one of the variable(change) while plot should be representing the exact value of the other variable (amount) for all the quarters (but no mean/sum) ) Thanks! ... View more