Ok, I understand your problem! Is there a lot of rows in the data? If so I would try to create filters for the different variables, that will enable selection. If not maybe opening the IMAP into a pivot would help the users? Oops, just saw that you might already do this......:-) Regards Fredrik ... View more

Exactly how do you do your "filtering"? Using a predefined filter in the IMAP? Excel, using "autofilter" ? How do you open the IMAP and into what program? I can open a IMAP in excel and do autofilter and select which items I want to use. The same when I use then filter dialog when opening the IMAP, I can chose from a list of items.... Regards Fredrik ... View more

Ok, I don't know why you want to run a stored process, if it's because you want the most recent data och the ability to subset data before you open the report. One way to at least get the latest data is to add your code before the task code. If you open properites from the SAS add-in tab in excel and chose tasks, you can add code before and after the task. I think that if you add code that creates a table which you have registred in metadata you can first update/create that table and then open it in Excel. So: 1. create table 2. Register in metadata. 3. create code that updates/recreate table 4. add code before task in Excel. 5. open table in pivot. Migtht work?! Regards Fredrik ... View more

One way could be to use a information map instead, see note: http://support.sas.com/kb/39/432.html I have succesfully tested to open a information map based on a start schema directly into excel pivot! Regards Fredrik ... View more

Try this: data test; length caseid 8 condition $20; input caseid condition; datalines; 1 headache 1 cough 1 vomiting 2 headache 2 cough 3 vomiting 4 rash 4 anaemia ; run; data test1/view=test1; set test; length flag 8; flag = 1; run; options missing = 0; proc transpose data = test1 out = test2; by caseid; id condition; var flag; run; //Fredrik ... View more

Something like this??? data one/view=one; set hello; length diff 8; diff = var1 - var2; run; proc sort data = one out = two; by id diff; run; data three; set two; by id diff; if first.id then output; run; ... View more

One advantage with proc sql is that index is kept and that you don't rewrite the table, useful when working with larga ds... ... View more

Try sql instead: proc sql; delete * from st.Def_2008 where ResultType=77 ; quit; ... View more

Are you using the correct format? This works, but may not be what you ask for.... data _null_; a = today(); put a EURDFMY7.; b = 'jun 2010'; c = input(compress(b),EURDFMY7.); put c yymmdd10.; run; ... View more

Is it not as easy as an inner join? proc sql; create table newtable as select a.*,b.StockPrice from (select * from table1) as a inner join (select * from table2) as b on a.ISIN = b.ISIN and a.Issuer = b.Issuer and a.DivDate = b.TradeDate ; quit; ... View more

A work around is to create the cuba in another schema and when its built swap schema to the new one. The old one in used in the next update... ... View more

proc sql; create view match as select a.*,b.unique_b_var as check from (select * from table1) as a left join (select * from table2) as b on a.var1 = b.var1 and a.var2 = b.var2 and a.var(n) = b.var(n) ; create new_table as select * from match where check eq . ; quit; ... View more

Hi! If intend to use picture format you do not have to multiply the value it is in the picture..... proc format; picture negpct 0 - high = '009.999%' (mult=100000) low - 0 = '009.999%' (prefix='-' mult=100000) ; run; ... View more

I was a bit too quick, the right code should be: data out; retain ID B C A SUM; set in; run; ... View more