Hello SAS Experts, I am running a simple update query as shown below after removing all the indexes from the table. There is no where clause required as all values under this column need update. proc sql; update tablename set columnname='xxxxxxxxxxxxxxxxxxx'; quit; For a table with 45 million records and 153 columns, the CPU time taken by query is 1 hour 51 minutes.(real time ranges from 7 to 10 hours). Will below Data step be a better choice than above query in reducing the CPU time? Data libnam.table1;      set libnam.table1;   columnname='xxxxxxxxxxxxxxxxxxx';        run; If not , are there any techniques to reduce the CPU time for the above kind of update? Thanks... ... View more

Hello , could anybody please tell what is the purpose of Foundation repository in di studio? thanks ... View more

Hi SAS Experts, I have a data step: data x_final(sortedby=c1 c2 c3 c4 index=(d1 c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17));      set x_updated;      by c1 c2 c3 c4; run; This data step takes around 3 hrs if x_updated has around 20 million records. If x_updated has around 0.25 million records, then data step takes only 5 minutes to complete. My question to experts is that -> Is there any way by which I can reduce execution hours even when source dataset has greater than or equal to 20 million records?  Thanks ... View more

Hi Experts, Below query takes a huge time to execute.. select * from work.table1 as t1 where not exists      ( select * from lib1.table2 as t2 where t2.column1=t1.column1 and t2.column2=t1.column2 and t2.column3=t1.column3 and ..... ..... ..... t2.column14=t1.column14 and t2.column15=t1.column15     ); If table1 has around 15000 rows and table2 around 20000000, then it takes around 15 hours for the above query to execute. What could be the cause for query taking so long? Is there any way I can rewrite the above query to reduce execution time..? ... View more

Hi Experts, Outside Mainframe , following sas libname statement format is used to acecss some table say TAB1. libname mdat sasspds schema="schemaname" user="userxx" password="XXXXXXXXX" serv="4160" host="spdserv" ip=yes; But how the above statement would be written in JCL? or should the above libname statement written inside the SAS program that is in Mainframe? Please help! ... View more

Hi Experts, In DI Studio job, When I delete a stage in the process flow, then the mappings defined in the previous stages are broken. Example  ::             Source(s)  -> Stage B -> Stage C -> Stage D -> Stage E -> Target table            If I delete/drop stage E and replace it with some other stage, then the mappings of C,D get broken..... Is there any way/logic/trick  by which I can drop a stage in the process flow and have the mappings intact in the other stages... Thanks for any help! ... View more

Hi , In the below graph which is drawn using gbarline, is it possible to add a text on the graph region shown by arrow. I am able to draw a reference line using ref option. But not able to add a text above it. I created below annotate dataset and used it against PLOT statement(of gbarline ) but it says Annotate not supported by PLOT... Then I used it against BAR statement but it doesn't work. data an1;       length function color text $ 30 style $ 20;       hsys='3'; when='a';       function = 'move'; xsys='1'; x=0; ysys='2'; y=3000000; output;       function = 'draw'; xsys='1'; x=100; ysys='2';  y=3000000; line=33; size=2;color="gray"; output;       function = 'label'; xsys='1'; x=75; ysys='2';  y=3000000; style="Arial"; size=2; text='Limit'; position="2"; output; run; proc gbarline data=sashelp.electric;    bar year / discrete sumvar=Revenue subgroup=Customer               html=revtip name="US_Electric_Power"               des="Chart of US Electricity Generation Sources and Consumers";    plot / sumvar=AllPower   html=alltip  ref=3000000; run; Could someone help me please.!!.(here the reference line and hence the text depend only on the plot response axis and not the bar response axis. so dont want to interchange..) ... View more

hi, need some help with SGPLOT.!! I need to highlight an area of a graph with some light color/slant or cross lines.  For example, in below case /graph , is it possible to highlight the area starting from 01Aug00 till the end of the X-axis( with some shade/color/slanting lines/cross lines ) Annotate doesn't work with 9.2 sgplot..so I am unable to use annotate with sgplot. Does SGPLOT has any feature by which this can be achiveved. I searched some of the SGPLOT documentations but unable to find a single feature which can achieve this. Experts!! Please help me! :smileyplain: proc sgplot data=sashelp.stocks (where=(date >= "01jan2000"d                                  and date <= "01jan2001"d                                  and stock = "IBM"));    title "Stock Volume vs. Close";    vbar date / response=volume;    vline date / response=close y2axis; run; ... View more