Hi, I don't have SAS Data Management Studio but in from your code I have one idea what could be the problem: your update is making select from table b for every row in table a which means 6,5 million times a select from (74000 rows inner join with 6,5 million rows) with a answer of 1 action status. this can't be fast! However you could make a filter to limit the rows in a big table like this update master a set a.action_status=(select b.action_status from trans b where a.cust_id=b.cus_id) where a.cust_id IN (select DISTINCT cust_id from trans) or you rewrite it to be a data step: data master; set master trans; BY cust_id; run; However, the second option had a need that data are sorted by cust_id. If you build an index by cust_id this could help also. Just few thoughts ... View more

Hi, I hope that I understand the problem correctly but you have a Report where user can use filter and you would like to send the values to other Report so it opens with same filter values. is that so? in this case you have to link the reports to each other. This link should give you the idea: http://support.sas.com/kb/41/526.html If you don't have the possibility then you need the rights - SAS Web Report role "Advanced Report Creation: Create Report Links" should do the trick. You can't make the link between the tabs in one report, though. What you have to do is to create new report with prompts for Date_From and Date_to and then link it to the first report. In this case new report will be opened in right date range and the user have a possibility to return to first report. It is not always what is needed but it works quite good. I'm using it in some reports. Users like it also. Hope it helps. Cheers, Remo ... View more

You have to create a link between prompt in report 2 and filter value in report 1. It will always prompt values if you open report 2 directly but works if you click from one report to other. This link should help you to understand how it works. http://support.sas.com/kb/41/526.html If you don't have the possibility to create a link between two reports then you need additional rights. You have to be a member of a Web Report Studio role that has the "Advanced Report Creation: Create Report Links" capability. It takes maybe few times to try out but it is quite easy to understand process. Hope it works for you also... ... View more

Hi, thank you very much. This seems to do exactly what I need. I will try it in my code and hope that it works out fine. it's very interesting approach. And thanks for pointing out the mistake in style statement. I have learned that some smaller mistakes are automatically corrected in SAS but it takes time and you never know what is the outcome. I can't answer the question about HTML statement because I don't know. Maybe it's necessary to Design the whole page where Tables are just a part of it. ... View more

Hi, I have created a example stored process to show what I mean. It's in most cases easier to read the code that to explain... It's a simple stored process that will deliver 3 Tables. I will run this code in SAS Portal and get the result that bothers me so much. It is very similar to the original code, I left out css part as I'm not a web-designer and can't read this file. My SAS is working on Unix and I can't save ODS Output. We use Internet Explorer. The situation I have created here is a page with 3 Tables and all of them use Proc Report and I have tried to define the witdh of Week column so that all three tables would have the same order which is easier to follow. Now, the table 3 has more columns than other two and for some reason the cellwitdh is not working anymore. I don't mind if it goes outside of screen but I would like to keep the [cellwitdh = 100]. The full code to create the result is attached. maybe an example of PROC REPORT that I use: ods htmlbody = _webout; rs=none style=moderntable; options noquotelenmax; PROC REPORT data = Data1 nowd NOCENTER SPANROWS      STYLE(HEADER) = [font_weight=bold]      STYLE(REPORT) = [cellspacing=1 cellpadding=0]; COLUMN Name week, profit; define Name / ' ' GROUP ORDER=DATA; define week / across order=DATA center 'Week' style={font_weight=bold just=c}; define profit / SUM ' ' center style=[CELLWIDTH=100]; run; ods html close; I have very limited access to the server and for me it doesn't look like technical problem. It seems to be some logic that SAS uses and I would like to understand what exactly is going on. Remo ... View more

Hi Cynthia, I'm sorry it was unclear the first time but I was kind of confused and didn't see that I haven't given the most important information in my description. It is a page in SAS Portal, created with stored process. It is created directly using data _null_; file _webout and put '<html> ' logic. Table itself is created wirh proc report statement. The problem I have is that having more than one table on the page I would like to see them lined up, so that all columns are at the position. Cellwidth statement should make all the columns width the same size. I uploaded a picture how I would like to see it (it is header only but gives a good idea what I mean) Now I have changed the number of columns to be shown and the result looks different. The Weeks 10-13 (first 4 columns) are with different size. The code has not changed. This is just an example where the beginning is changing. If I show two tables together then I can't say which column will have different width and on the screen it looks like a mess. I would like to define a width and then keep it no matter how big is the number inside. I hope this time I could explain the problem better. Thanks for information. ... View more