Hi guys! Do you have any idea what is the max users accessing a wrs report? I believe that when using WRS it takes up memory, is it possible to derive the number of users by memory? e.g. for 8 gig of ram 6 users can access the report simultaneously? Would really appreciate you response. Regards sasdemo123 ... View more

Hi, This is really driving me mad. I have large SAS data set which I need to write to excel, unfortunately, I can't work out (or my version of SAS doesn't have the ability) to write to a single .xlsx file. So, I would like to split the dataset up into roughly x4 smaller tables. The variables look like: DATE stock1000 stock10010 stock10015 ... etc where everything after DATE is always indexed logically as stockX but not necessarily in numerical order. Simply, how can I check the width of the table and select the first, say, 200 variables, then move on to the next 2000 variables etc until the end. I'm sure this should be easy but I really cannot work it out. Many thanks. ... View more

Ok, I've been on holiday for the past week and seem to have lost all SAS ability. All I'm looking to do is convert a $5 formatted variable to a ddmmyy. date. For example, I want the value 'JAN11' to be converted to '01JAN11'. Can anyone help? Many thanks ... View more

I'm using DDE to export data to a spreadsheet. Everything is working fine but I need to bold certain entries on the fly. Is there a way to use Escapechar? Something else? Jeff ... View more

Hi all, Firstly, I'm slightly new to SAS. I would like to compute correlation coefficients on a large data set X with a single common variable Y. The data set X is now sorted such that daily observations run down the table, stock names run across the top, with returns in the table. i.e., stock_a stock_b stock_c day 1 . . . day 2 . . . day 3 . . . The difficulty I'm having is that I would like to compute the correlation between the X's and the Y on a monthly basis (where I have daily data). In Matlab for instance I would do this by looping over the rows then the columns and filling up containers then computing the correlations for each individual month. Does SAS have an easy way to do this given my X is large (60 million observations) and contains missing data. Thank a bundle. I'm learning fast and I'm liking SAS so far. Message was edited by: thepowertoknow? Message was edited by: thepowertoknow? ... View more

Hi Everyone, Is there a way to select on sorted data by type using a specific distribution? this my sound confusing b/c i dont know the exact terminology but here is my problem below: I have 10k records and I need to select the top 1k records (based on balance). However, each record also has a Type, and to be fair i want to select the same percentage of records from each type. For example, in my data 50% of the records are Type A, 30% are type B, and 20% are type C. So I need to select the top 500 records of type A, top 300 records of type B and top 200 records of type C. All together this equals 1000. In reality my dataset has 6 types, my total dataset is 16M records and i have to select approx. 4.2M from this list. i know i can calculate these percentages by hand, then write custom select statements in SAS, but I was thinking that this is a common enough problem that there must be a more automated way of doing this. Does anyone have any suggestions? Dataset: Id Type Bal 1 A 1000 2 C 90 3 A 1 4 B 203 5 B 980 6 A 89 ... ... ... Thanks in Advance! ... View more

Hi, I've created an RTF file in UNIX environment. If I open the RTF file with .doc, some of the numbers are split into other rows: example, 35.4 (2.356 ) Its fine when I open with RTF. I'd be grateful if anyone has a solution. Thank you ... View more