Hey Scott... you were right. it was due to the memname. thanks heaps and millions! cheers, yennie ... View more

Hi Cynthia... I am putting this html page live in my company website...and running the whole piece of code now. However, I am not sure what went wrong if its my ods or the nobs has not bee selected correctly..... This is the note I had on my SAS log.... (hoping you can help me out with this one, thank you so much) NOTE: The data set WORK.OUTPUTTABLE has 34 observations and 4 variables. NOTE: PROCEDURE SUMMARY used (Total process time): real time 0.00 seconds cpu time 0.15 seconds NOTE: No rows were selected. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds %Macro sales_graphs (FromTable=); Proc Summary Data = &FromTable Nway Missing; Class month; Var sales; Output out = OutputTable (Drop = _Type_ _Freq_ ) Sum=; Run; proc sql noprint; select nobs into :nobs from dictionary.tables where libname = 'RWORK' and memname = 'OUTPUTTABLE'; quit; %let nobs=&nobs; %put number of obs in rwork.outputtable is:&nobs; %if &nobs eq 0 %then %do; Title "Error Message"; data _null_; length Message $75; file print ods; Message = "This selection does not contain any results."; put _ods_; Message = "Please correct input and try again!"; put _ods_; run; %end; %else %if &nobs gt 0 %then %do; GOPTIONS DEVICE=gif xpixels=0 ypixels=0; SYMBOL1 INTERPOL=SPLINES HEIGHT=10pt VALUE=NONE CV=&color1 LINE=1 WIDTH=3; Axis1 STYLE=1 WIDTH=1 MINOR=NONE LABEL=( FONT='Arial /b' HEIGHT=12pt ANGLE=90 "Sales"); Axis2 STYLE=1 WIDTH=1 MINOR=NONE LABEL=( FONT='Arial /b' HEIGHT=12pt "Month"); TITLE " SUN Portfolio "; PROC GPLOT DATA = OutputTable; PLOT Sales * month / GRID VAXIS=AXIS1 HAXIS=AXIS2 FRAME LEGEND=LEGEND1; RUN; GOPTIONS RESET=ALL; %End; %Mend sales_graphs; filename odsout '//data/webserver/yennie'; GOPTIONS DEVICE=gif; ODS LISTING CLOSE; ods html path=odsout body='new.html' style=festival; %sales_graphs (Fromtable=SunData); ODS HTML Close;ODS LISTING; Yennie ... View more

Hi Robert, Thank you for your reply. This is a quick example of my code which I was using initially... The above suggestion is great however i think it only allow me to output the gif. I can't see html pages .... =/ ODS HTML File = "/data/webserver/yennie"; Proc Summary Data = ABC Nway Missing; Class month; Var transif ; Output out = ABC_smry (Drop = _Type_ _Freq_ ) Sum=; Run; %LET _EGCHARTWIDTH=0; %LET _EGCHARTHEIGHT=0; GOPTIONS xpixels=&_EGCHARTWIDTH ypixels=&_EGCHARTHEIGHT; GOPTIONS COLORS = (CX0F3E93); SYMBOL1 INTERPOL=SPLINES HEIGHT=10pt VALUE=NONE CV=RED LINE=1 WIDTH=3; Axis1 STYLE=1 WIDTH=1 MINOR=NONE LABEL=( FONT='Arial /b' HEIGHT=13pt ANGLE=90 "Inforce Risks"); Axis3 STYLE=1 WIDTH=1 MINOR=NONE LABEL=( FONT='Arial /b' HEIGHT=13pt ANGLE=90 "Month"); TITLE; TITLE1 " Portfolio "; FOOTNOTE; PROC GPLOT DATA = ABC_smry NOCACHE ; PLOT transif * month / GRID VAXIS=AXIS1 HAXIS=AXIS1 FRAME; RUN;QUIT; TITLE; FOOTNOTE; GOPTIONS RESET=ALL; ODS HTML Close; ... View more

Hi Chris, thanks heaps on this one! Do you know what happen if it's just for average price $. whereby say the claims cost per policy is = total amount of money inccured to date/ number of days acrrued ... not in percentage though.. it's dollar6.2. cheers. ... View more

Hi Cynthia, Thank you so so much on this one. I must say it's been really awesome for me because I actually used what you suggested to fix my code the last two days. And one more day this tool will be uploaded to my company intranet accessed by all the business managers. 🙂 Thanks both to you and scott for the awesome help. Really really appreciate it! ~ Long bumpy journey that makes a better future ~ Cheers Yennie ... View more

OMG scott... save my life!! quick quick question ... probably the last question for this part.. Data _null_; file 'K:\yennie.html' print; %if &totobs = 0 %then %do; put 'no obs!'; %end; %else %do; put 'many obs!!!'; %end; ----> for this part.... do you know if it's possible to input graphs and charts? (gplots and gchart) run; thanks heaps!! Message was edited by: Yennie ... View more

Hi Scott, Thanks so much for your help. I really do appreciate your explanation. I read through the papers and did Nobs= as suggested by the papers this time round. Something below... DATA Output; SET Fruits nobs = totobs ; RUN ; Data _Null_; call symput ('totobs', totobs); set Output; Run; This bit is all great and good. your help is greatly appreciated! Now.. however... Oh or maybe this next question should not be asked here... Because my main purpose of finding out if a dataset is 0 is because so that I can print a line on the html page. If there are obs then it will output two graphs. the bit about ODS ODS HTML Body = "yennie.html"; Data _Null_; If totobs = 0 Then Do; PUT 'No Obs!'; END; Else Do; /**** since there are obs in this dataset, I would like to now print two graphs with respect to the variables that I have in "newdata.dataset" ***/ set Output; Run; ODS HTML Close; however, my html page is blank.. ? could it because my ods script been written wrong? hoping you can help. So sorry for all the trouble! 😞 cheers, yennie I guess at this stage it's really the error I have on my ODs script. ... View more

Hi Scott... this is something simple that I came up with using proc contents and symput. ( i know probably drifting too far away:( ) yen1.data has no obs so i created a macrovariable nobs within that set. however, are you able to tell me why is it that the text are not printed out in my html page? proc contents data = gwp out = yen1 ( keep = nobs); run; data _Null_; set yen1; call symput ('nobs', nobs); run; %put &nobs; ODS HTML Body = "testing.html"; data yenyen; set yen1; if &nobs = 0 THEN DO; PUT 'GIO Random Portfolio'; END; ELSE If &nobs ne 1 Then DO; PUT 'yucky'; END; run; ODS HTML Close; ... View more

Hi Scott, Thanks heaps on replying. I realyl appreciate it! I think I do kind of understand how to apply the NOBS= part but not sure if I have applied my html redirection correctly? Data ABC; Set DEF NOBS= nobs; Where Fruits = 'Orange' If nobs = 0 then put ' This is an Error Page </BODY> ; Run; This is really what I can think of at this stage however, I am stuck at the PUT statement bit (not sure how to redirect it to Error.HTML) Hoping you can help me out on this one! Cheers. ... View more

Hi Scott, Thank you so much for the reply. I have tried to read up on F1 help on NOBS= , however I may have gotten it wrong on how to use it. Just wondering if there's any papers that touch based on NOBS? Hoping you can help! Cheers. Yennie ... View more

Hi Scott, The ODS and "Next" are within my macro script so it really didn't matter whether if it's a "Next" link or a "Back" link. A simplified code as below. (Real simple I know) Hope it didn't look silly to you! Thank you guys so much for your awesome help! 🙂 ************************************************************* %Macro html_page ( output_html=, name_html= ) ODS HTML Body = &output_html; TITLE; FOOTNOTE Color=Black Justify=right link="&name_html." "[View Cancellation Results]"; PROC PRINT DATA=Fruit NOOBS LABEL; VAR sales earnings days; BY Month RUN;QUIT; Title; FOOTNOTE; GOPTIONS RESET=ALL; ODS HTML Close; %Mend html_page ; %html_page (output_html=renewalA.html , name_html=cancellationA.html) %html_page (output_html=renewalB.html , name_html=cancellationB.html) %html_page (output_html=renewalC.html , name_html=cancellationC.html) ************************************************************* ... View more

Hey Robert, I didn't even think of that in the beginnning. works really well for me. thank you so much for that! Really appreciate this, Yennie ... View more