About fredbell

fredbell · ‎01-28-2011

Hi How is it possible to collapse the table of contents? Thanks Fred

fredbell · ‎01-28-2011

Hi I am not clear on why the below code generates this message in the table of contents under the report name. I would like it to read something like Click to see results. Any suggestions? Also how do i change size of font in table of contents? ODS HTML file='HTML_FILE.html' contents='HTML_CONTENTS.html' frame='Calls Handled.html'; ODS PROCLABEL "None Bedrock All LOB Calls Handled"; axis1 value=(height=8pt angle=90); axis2 label=(angle=90 rotate=0); proc gplot data = Totals_NoneBedrock; title h=3 f=simplex "The Date is: %sysfunc(date(),worddate.)"; title2 h=4 f=simplex 'None Bedrock All Lobs Calls Handled through Time'; footnote h=3 f=simplex 'EDW vccart_sceintrvl agentcallshandled'; plot calls_handled*Date unknown*date / overlay haxis=axis1 vaxis=axis2; symbol v = triangle I = j ci=black w = 1 ; label Date = ‘Date’; run; quit; ods html close; Thanks always. Fred Message was edited by: fredbell

fredbell · ‎01-27-2011

Hello Ok I found the files you are refering to on my local drive? Thanks that give me a starting point. Reason for posting in that location was simply because it was ods, sorry if it is not the correct location, i try. Fred

fredbell · ‎01-27-2011

Hello, I have been told by including the Contents option it will create a table of contents. It does not, only the proc freq and Mean are created. Anyone know why? ODS HTML FILE=”HTML_FILE.html” CONTENTS=”HTML_CONTENTS.html” FRAME=”HTML_FRAME.html”; Proc Freq data=temp; Tables x1*x2/list; Run; Proc Means data=temp; Var x1 x2; Run; ODS HTML CLOSE; Thanks Fred

fredbell · ‎01-04-2011

Anyone know why i am getting this error, level_7_id are both of same data type? 44 PROC SQL; 45 CREATE table Calls_Handled_Temp AS 46 SELECT A.SiteID,A.Indicator_OutSource, B.ReportTime,B.Level_7_ID, B.agentcallshandled 47 FROM level7 A FULL JOIN jennifer.tbl_vccartsceintrvl B 48 ON (A.Level_7_ID = B.Level_7_ID) 49 WHERE 50 ReportTime >= &MTDfromdate and ReportTime <= &MTDTodate 51 order by ReportTime asc; ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL where clause optimization. 52 53 QUIT; Fred

fredbell · ‎12-16-2010

Yes that is what i mean, thanks. Fred

fredbell · ‎12-16-2010

Thanks but what if i also need to RANGE='a40:ax60'; How do i get Variable names and then define the range? Fred

fredbell · ‎12-16-2010

Hi How would i go about selecting row 3 as the variable names and then say row 4 to 11? PROC IMPORT DATAFILE= "c:\Assurance\Scorecard.xls" DBMS=EXCEL out = TotalSubscribers replace; SHEET="'Fobe'"; RANGE='a4:ax11'; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; Fred Message was edited by: fredbell

fredbell · ‎11-23-2010

Thanks it was the put that made it work, that is the part i was lacking. Fred

fredbell · ‎11-23-2010

Thanks for the input people, it turns out that it was because the day was a number type. I was instructed to use the put(day) to transform it back to a text, From text to sas data format then back to text, what a pain in the PUT. Thanks Fred

fredbell · ‎11-22-2010

Hello Does or should this covert the variable to Date because when i look at the properties of the dataset the type still says number not date? data Calls_Handled (keep=Date agentcallshandled level_7_id); set Calls_Handled_Temp ; Date=input(ReportTime, anydtdtm22.);*this converts it to datetime variable; where ReportTime >= &MTDfromdate and ReportTime < &MTDTodate; format Date datetime9.; run; format changes to Datetime9 Fred

fredbell · ‎11-19-2010

Hello everyone! What do i need to do to get it to return the results from B in every row not just the first for each? PROC SQL; CREATE TABLE TEST AS SELECT A.DATE,A.DAY,A.HANDLED,A.LEVEL1DESC, P.UCL,P.LCL FROM MEAN1 A FULL OUTER JOIN DAILY_MEAN P ON A.LEVEL1DESC = P.LEVEL1DESC AND A.DAY = P.DAY ORDER BY A.LEVEL1DESC, A.DATE; QUIT; fred Message was edited by: fredbell Message was edited by: fredbell

fredbell · ‎11-14-2010

I have since removed the noprint. I do have a question regarding Goption Device = gif; instead of goption reset = all device = active x; I have changed my code to Goption Device = gif; so i could drilldown but it now appears that i can't hover over bars with my mouse and see the totals for each group were this was the case with goption reset = all device = active x; Code below goptions device=gif gsfname=image gsfmode=append display; ODS LISTING CLOSE; /* Specify the path and filename of the output file. */ filename odsout '\\mtrl\Int_ss$\vali_esource_vs_destination\'; /* Open the ODS HTML output destination */ ods html file='Calls Handled.html' path=odsout style=Statistical; title 'Calls Handled '; footnote1 color=Black "(Click Blue #1 Drilldown to Technical #2 Green for Service #3 Yellow for Sales & Retention)"; footnote2 color=Red "(# 4 Calls that are not assigned to Group, no drilldown available)"; /* use the SHAPE= option to specify a cylinder */ axis1 value=(height=8pt angle=90); axis2 label=(angle=90 rotate=0); proc gchart data=neworg_callshandle_by_day; vbar3d date /discrete subgroup = color width =10 sumvar=calls_handled discrete raxis=axis1 shape=cylinder subgroup=Group maxis=axis1 raxis=axis2 autoref cref=gray clipref coutline=black legend=legend1 html_legend=htmlvar cframe=white autoref width=2; run; quit; ods html close; Any suggestions as it would be good to see that info thanks Fred

fredbell · ‎11-11-2010

Hi Cynthia Yes that is what i ended up doing, see code below. Thanks for the input. /* Technical Set the graphics environment */ /* Create Graph of Calls Handled Technical */ /* Email HTM File to Distribution List */ goptions reset=all device=activex xpixels=950; /* Specify the path and filename of the output file. */ filename odsout '\\***************************************\'; /* Open the ODS HTML output destination */ ods html file='Information.html' path=odsout style=Statistical; title 'Information'; /* use the SHAPE= option to specify a cylinder */ axis1 value=(height=8pt angle=90); axis2 label=(angle=90 rotate=0); proc gchart data=Call_Type_Tech noprint; vbar3d date /width =10 sumvar=calls_handled discrete raxis=axis1 shape=cylinder subgroup=call_type group=call_type cframe=yellow autoref width=2; run; quit; Fred

fredbell · ‎11-10-2010

Thank you Robert this will help a lot with my analysis. Fred

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Collapse table of Contents

Plot of unknown * date

Re: Table of Contents

Table of Contents

ERROR: Expression using IN has components that are of different data t...

Re: Proc Import Excel

Re: Proc Import Excel

Proc Import Excel: get column names from different range

Re: Date=input(ReportTime, anydtdtm22.);*this converts it to datetime ...

Re: FULL JOIN

Proc Import Excel: get column names from different range

Collapse table of Contents

Plot of unknown * date

Re: Table of Contents

Table of Contents

ERROR: Expression using IN has components that are of different data t...

Re: Proc Import Excel

Re: Proc Import Excel

Proc Import Excel: get column names from different range

Re: Date=input(ReportTime, anydtdtm22.);*this converts it to datetime ...

Re: FULL JOIN

Date=input(ReportTime, anydtdtm22.);*this converts it to datetime vari...

FULL JOIN

Re: add date to x axis

Re: add date to x axis

Re: add date to x axis