Hi,   Typically, drastic changes like these would pin down to infrastructure changes outside the control of the software! It's either a Network Bandwidth changes, or Disk I/O threshold changes or Worse Case Scenario - BOTH!!   If your Oracle Database didn't have version changes nor patches applied, that means there were no software changes on the Oracle Part. IF your SAS programs and scripts didn't have any modifications applied to them, that means there were no software changes on the SAS part.   That leaves you with your Storage & Network Admins to talk to and find out if there has been any recent changes .   Hope this helps, Ahmed ... View more

Hi, You probably would have an easier way to chart it, if you data set was structured like this Measure Value Site_Initiated 39 Site_Approved1 6 Date_Supplied4 7 site_contracted 34   Hope this helps, Ahmed ... View more

Hi,   I know this is marked as solved, but here is an alternative solution, if you are looking for a particular pattern data want(keep=id report_date); set have; pos = prxmatch('/\d{8}\|\|\|/',report); if (pos) then report_date = substr(report,pos,8); run; Ahmed ... View more

Hi,   I would suggest this approach /* Create a Format mapping Week Number to a Variable Name */ proc format ; value wkVarName 1-5='P1_5' 6-10='P6_10' 11-15='P11_15' 16-20='P16_20' 21-25='P21_25' 26-30='P26_30' 31-35='P31_35' 36-40='P36_40' 41-45='P41_45' 46-50='P46_50' 51-52='P51_52'; run; /* Usage Example */ data have; length prov P1_5 P6_10 P16_20 P21_25 P26_30 P31_35 P36_40 P41_45 P46_50 P51_52 8; stop; run; data want; set have(keep=prov %sysfunc(putn(%sysfunc(week("&sysdate"d)),wkVarName.)) ); /* Dynamically derive the variable name based on the current week number */ run; Hope this helps, Ahmed ... View more

Hi, From reading your entire thread, it sounds like you have a Database Table with a column/variable of a CLOB data type containing the String you are trying to manipulate and cleans.   These two papers may give you some tips with how to handle such data. - View Microsoft Word RTF Objects Embedded In Oracle - Using SAS® to Report Data in XML Format   Hope this helps, Ahmed ... View more

@sandi98   Proc summary would you give you the stats as additional columns proc summary data=sashelp.class nway; class sex; var age height weight; output out=durchschnitt1(drop=_:) min=age_min height_min weight_min max=age_max height_max weight_max mean=age_avg height_avg weight_avg; run; Hope this helps, Ahmed ... View more

Hi Cruise,   What were you expecting the category value for row 11 & 13 in your output (Want) data set? From looking at the input rows and your conditions (ever=1) 5 0 0 0 0 0 0 0 0 0 0 0 0 0 6 1 2004    --> [Row 12] BF Ever (No), [Row 11] BF 12M+ (No) 6 1 0 0 0 0 0 0 0 0 0 0 0 0 6 1 2004    --> [Row 14] BF Ever (No), [Row 13] BF 1Mo (No)   Ahmed ... View more

Hi Cruise,   Based on your sample data, here is what I was to come up with,  data want (Keep=id year category values); SET work.have(rename=(measurment_years=year)); length category $13; if min(of bf1--bf12)=1 and max(of bf1--bf12)=1 then category='BF 12M+ (Yes)'; else do; if min(of bf1--bf12)=0 and max(of bf1--bf12)=0 then category='BF 12M+ (No)'; else do; if min(of bf1--bf6)=1 and max(of bf1--bf6)=1 then category='BF 6M+ (Yes)'; else do; if min(of bf1--bf6)=0 and max(of bf1--bf6)=0 then category='BF 6M+ (No)'; else do; if min(of bf1--bf3)=1 and max(of bf1--bf3)=1 then category='BF 3M+ (Yes)'; else do; if min(of bf1--bf3)=0 and max(of bf1--bf3)=0 then category='BF 3M+ (No)'; else if (bf1=1) then category='BF 4WK+ (Yes)'; else category='BF 4WK+ (No)'; end; /* End of 3M+ check */ end; end; /* End of 6M+ check */ end; end; /* End of 12M+ check */ output; if (ever=1) then category='BF Ever (Yes)'; else category='BF Ever (No)'; output; run; As you can see, I used the evaluation logic suggested by @RW9, and I assumed your categories are mutually exclusive.   Note: I just added an excel version of your data image as an attachment.   Thanks, Ahmed ... View more

@Cruise, To provide you with way to re-produce my sample data Structure, please answer these two questions: Q1: What does your 5 Million records data set look like, in terms of structure? Q2: What does your categories, such as "BF 12M+ (Yes)" mean? Are these calculation with 1==Yes, 0==No? while 12M+ means 12 months or More? Are your bf1 -- bf12 represent months? Thanks, Ahmed ... View more

Hi, As @Reeza had mentioned, your data should be converted to have three columns (year, Category, value) and 48 rows (2003 - 2013 by 2 yrs increments)   This how I generated my Sample data to "reproduce" your chart data want(KEEP=year cat val); length year 4 cat $12 val 4; array bfs {8} $12 bf1 - bf8 ('BF Ever (Yes)' 'BF Ever (No)' 'BF 4WK+ (Yes)' 'BF 4WK+ (No)' 'BF 3M+ (Yes)' 'BF 3M+ (No)' 'BF 12M+ (Yes)' 'BF 12M+ (No)'); do year=2003 to 2013 by 2; do i=1 to dim(bfs); cat = bfs[i]; val = rand('uniform') * 10; /* Used Random numbers */ output; end; end; run; For Custom line styling and coloring, you could use SAS/GRAPH SYMBOL, LEGEND, and AXIS statements prior to Proc Gplot, or use other SAS charting procedures.   Note: I used the Line Plot Wizard in SAS Enterprise Guide, to generate my chart.   Hope this helps. Ahmed ... View more

Hi Juan,   Check this community entry https://communities.sas.com/t5/SAS-Enterprise-Guide/Re-How-to-schedule-SAS-EG-Project/td-p/204954, it may answer your question.   Most likely for situation like your, you'll have to use a Scheduling Tool that, which could a simple scripting language, to a sophisticated Scheduling Tool with GUI and dependency and errors handling, ....etc.   Thanks, Ahmed  ... View more