Hi, I tried to create a stored process on the same code you have provided and i ran that in WRS...but  i am not getting any timed out or missing images(So its not a limitation).May be some problem with your environment . Thanks, Shiva ... View more

Hi, You can pass this way..try this... First stored process creating links and passing parameters: proc report data=want nowd ; column  age    ; define age/left; compute age; length nexturl $500; nexturl = "&_URL?_program=/Users/sasdemo/My+Folder/KPPOC/agefiltercode" ||          '&age=' || urlencode(trim(left(age))) ; call define(_col_,"URL",nexturl); endcomp; run; write you filtering code in second SP:(stored process name : agefiltercode) Thanks, Shiva ... View more

Hi, Check this links ...Hope it helps.. http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a002171886.htm http://support.sas.com/documentation/cdl/en/armref/61526/HTML/default/viewer.htm#a003282868.htm Thanks, Shiva ... View more

Hi Mike, I Guess you cannot get created date information using base SAS for odbc library,but you can get this information for sas datasets. If you want to know create date information you can login to sqlserver and properties you will get that. Hope this helps... Thanks, Shiva ... View more

Hi, Is Proc Sort is taking lot of time ...you can avoid that by creating index on OCTROI variable and you avoid sort steps completely. Thanks, Shiva ... View more

Hi Mike, Check this link for creating SP using EG. https://communities.sas.com/message/127137#127137 From Base SAS if you want to create then you need to use *ProcessBody; %stpbegin; %stpend; Thanks, Shiva ... View more

Hi Suresh, Check this for creating stored process in EG www2.sas.com/proceedings/sugi30/135-30.pdf www2.sas.com/proceedings/sugi31/257-31.pdf For details, see the SAS Intelligence Platform: Application Server Administration Guide. SAS Workspace Servers fulfill client requests for SAS sessions. When these servers are configured as standard workspace servers (without workspace pooling), each client establishes a connection to a single-user server process, uses the server, and then disconnects. SAS Pooled Workspace Servers are workspace servers that use server-side pooling, which is new with SAS 9.2. The SAS object spawner maintains a pool of reusable workspace server processes called a pool, thus avoiding the overhead that is associated with creating a new process for each connection. Workspace server load balancing is built in to server-side pooling. Pooled workspace servers are intended for use by query and reporting tools such as SAS Web Report Studio and SAS Information Delivery Portal when accessing relational information maps. SAS Stored Process Servers fulfill client requests to execute SAS stored processes. A stored process is a SAS program that is stored on a server and can be executed as required by requesting applications. Stored process servers are configured to be load balanced. By default, the object spawner balances workloads across three stored process server processes. SAS/CONNECT servers enable clients to execute code on a remote host, or to move data between client and server machines. SAS OLAP Servers provide access to multidimensional data. Thanks, Shiva ... View more

Hi, If I guess correctly,you are getting the all three titles in all the reports which you want to restrict.Try this.. title 'test1'; proc print data=sashelp.class;run; title ''; title 'test2'; proc print data=sashelp.class;run; title ''; title 'test3'; proc print data=sashelp.class;run; title ''; Thanks, Shiva ... View more

Hi, You can try searching in google by data warehousing by ralph kimball. And please spell that correctly. Thanks, Shiva ... View more

Hi, Try this.. data ss; input name $ 1-2 age$ 3-4 no $ 5-6 id $ 7-9; cards; q      q 1 1 1        e        e 3 3 3         r        r 7 7 7         w       w 6 6 6 run; proc sql; select distinct name into :name1-:name4 from ss where name ne ''; quit; %put &name1; data &name1 &name2 &name3 &name4; set ss; if name="&name1" then output &name1; if name="&name2" then output &name2; if name="&name3" then output &name3; if name="&name4" then output &name4; run; or you can loop it with macro. Thanks, Shiva ... View more

Hi Aswini, If you are using SAS EGRC system or oprisk monitor then you need to write a stored process.I have written for one(division) I hope you can write for the remaining. First SP: LIBNAME D_DashB BASE "F:\DATA_Dashboards\DATA"; ods html body=_webout; proc report data=D_DashB.have nowd ; column Strolno stname  class  math science English history geography division ;    define strolno/'strolno' display; define stname/'stname' display; define class/'class' display; define math/'math' display; define science/'science' display; define English/'English' display; define history/'history' display; define geography/'geography' display; define division/'division' display; compute division; length nexturl $500;   nexturl = "&_URL?_program=/Users/sasdemo/My Folder/division"    || '&division='|| urlencode(trim(left(division))) ;   call define(_col_,"URL",nexturl);    endcomp; run; ods html close; Second SP(Division); LIBNAME D_DashB BASE "F:\DATA_Dashboards\DATA"; proc print data=D_DashB.have(where=(division="&division")); run; Thanks, Shiva ... View more

Hi. Try this... first code: and save it. %macro test; %let USER_UMACRO_PATH =F:\Community_SAS; %put &USER_UMACRO_PATH; options sasautos=("&USER_UMACRO_PATH" %sysfunc(getoption(SASAUTOS))); %mend test; Second go to sasv9.cfg file and add you autocall library path(see the last line i have modified): -SET SASAUTOS  (                 "!sasext0\core\sasmacro"                 "!sasext0\assist\sasmacro"                 "!sasext0\eis\sasmacro"                 "!sasext0\ets\sasmacro"                 "!sasext0\graph\sasmacro"                 "!sasext0\iml\sasmacro"                 "!sasext0\or\sasmacro"                 "!sasext0\qc\sasmacro"                 "!sasext0\share\sasmacro"                 "!sasext0\stat\sasmacro"   "F:\Community_SAS"                ) Now close sas editor and reopen the new one and check by invoking the macro... %test; Hope it helps.. Thanks, Shiva ... View more

Hi, I have used same code given by Cynthia and it works fine in sas 9.2 and office 2010. Just expand the column A it is coming  fine. ... View more

Hi, Using Linlin data...Try this.... data employee_addresses; input id name $; cards; 1 Alisa 2 Linlin 3 FE 4 PG 5 Mike 6 Haikuo 7 Ksharp 8 Tom 9 Art ; data fmt11 (keep=FMTNAME START END LABEL TYPE); length FMTNAME $30. START END $256.; set WORK.employee_addresses;       FMTNAME = 'test' ;       START   =  id;       END     = START;       LABEL   = name;       TYPE    = 'N' ; run; proc format cntlin=fmt11 lib=work; run; data Organization_Dim; input id  level1-level6 ; cards; 1 3 4 6 7 8 9 2 3 4 6 7 8 9 3 4 5 6 8 9 . 4 5 6 8 9 . . 5 6 7 8 9 . . 6 8 9 . . . . 7 8 9 . . . . 8 9 . . . . . 9 . . . . . . ; run; data want; set Organization_Dim; array xx(7) id level1-level6; array yy(7) $ newid newlevel1-newlevel6; do i =1 to dim(xx); yy(i)=put(xx(i),test.); end; drop i; run; Thanks, Shiva ... View more