Hi,    We have hundreds of Base SAS codes, which uses SAS data steps, procedures and macros. We dont have any detailed document for the existing hundreds of the SAS codes. we want to document these SAS scripts functionalities with some pictorial representation.   My question is do we have any tools to do the SAS code analysis? The tool can be within SAS or outside the SAS components. Please suggest. Thanking you.   Regards, Alexsander S  ... View more

Hi All,    We created a IMAP in version 4.31, whcih works fine. We have migrated the IMAP version 4.31 to version 4.4, After migration the IMAP is not working. If I remove the filters then i can get the expected values. It seems there is an issue with filter in version 4.4.   Could you suggest any solution for this kind off issue, please? Thank you. Regards, Alexsander ... View more

Hi All,    I need to add two URL and Flyover for same variable in the proc report.   Example: Define Contry_State / "USA" - "NewYork" across;   in the above example, i need to add one link for USA and another link for NewYork. Is it possible. If yes. Please give me the syntax.   Thanking you in advance. Regards, Alex         ... View more

Hi All,     I need help OLAP cube MDX query. I have table with columns Product_Name, Year, Quarter, Sales_Amount etc. I can display these value in my cube. I display the sales amount for particulate quarter, meaning the sales amount for quarter1 display in Q1, sales amount for quarter2 display in Q2, sales amount for quarter3 display in Q3 etc.   What I want is Q1 should show the particular quarter1 values. whereas Q2 should show the values of quarter1 +quater2 values. Q3 should show the values of quarter1 +quater2 + quater3 values. Q4 should show the values of quarter1 +quater2 + quater3+ quater4 values.   Is it possible to do it through MDX query?   Note: The time hierarchy has both Year and Quarter.   Thank you in advance. Best Rgards, Alex ... View more

Hi All,     I am not able to get hyperlink in the prompt page. Though we have prompt type called hyperlink and options to give the URL. I tried this in SAS v9.3 environment.  I am not getting any link or error message for this. My objective is to added a common hyperlink to all my 170 reports (STP). It would be really great If you could help me on this. Thank you. Regards, Alexsander S ... View more

Hi All,     I need to find the prompt type (eg:character, numeric, date, etc.) through code. I think there should be a way to find the prompt type through metadata functions. not sure how!. The reason fof this is that While passing prompt value to the browser I need to handle the prmopt values differently based on prompt type. It would be great if you help me to find the prompt type through code. Thanking you in advance. Regards, |alex| ... View more

Hi All,      I have performance issue with my report code. My code takes around 69 minutes to complete the report. One “Proc report” procedure takes 66 minutes to complete the step. The data has 104 columns and 168,745records, the physical size of my data is 450 MBs. Below is my proc report code and fulltimer options log: Code: Proc report Data=SMALL_MIS_FINAL center style(header)=[background=cx113388 color=cxffffff] style(summary)=[font_style=roman font_weight=bold] missing split= '~' spanrows; Column column1 to column_103 row_count; Define row_count / "Row Count" computed noprint; Compute row_count; obs+1; row_count=obs; If int(row_count/2)=row_count/2 Then Do; CALL DEFINE (_row_,'STYLE','STYLE=[BACKGROUNDCOLOR=CXEFEFEF]'); End; Endcomp; Run; Log: NOTE: There were 168745 observations read from the data set WORK.SMALL_MIS_FINAL. NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format. NOTE: PROCEDURE REPORT used (Total process time):       real time           1:06:14.57       user cpu time       1:06:22.96       system cpu time     7.24 seconds       memory              860845.95k       OS Memory           903724.00k       Timestamp           09/16/2014 06:10:33 PM       Page Faults                       0       Page Reclaims                     68733       Page Swaps                        0       Voluntary Context Switches        9113       Involuntary Context Switches      13645       Block Input Operations            976       Block Output Operations           1554480 Please let me know how to reduce cpu/ real time in this step. Thanking you in advance. Regards, Alex ... View more