About Reeza

Reeza · ‎01-31-2011

I don't think you need a macro for this...I think you need a data step, possibly an array (since you say 96 outputs) and control the output with output statements. Could you post what you want your original data looks like and what you'd like as a result?

Reeza · ‎01-24-2011

You wanted to store a superscript in a dataset? Or does the above answer your question.

Reeza · ‎01-21-2011

What about truncating the data to the time point of interest and comparing the differences of the curves up to that point? I think that's really what's of interest, ie is the surivival different for the first year, second year, etc... If you truncate at 12 months your estimate is the same as if you hadn't truncated but information afterwards is censoring/truncation in effect. Does that make any sense?

Reeza · ‎01-17-2011

Lookup the scan function. s_comp=scan (var, 1, "!"); r_comp=scan(var, 2, "!"); This assumes that R and S are always in the order stated. Use it once to separate the S and R components into separate strings, then in each string you can scan or using "S," or "R," as the delimiter and a loop to get the numbers.

Reeza · ‎01-17-2011

I've seen data like that before... The "kludge" has been to not import the header labels at all and then rename the variables manually once in the code. The risk in this method is if the report structure/layout changes but it has been pretty steady so no issues around that for me as yet and the database administrator knows this is what I'm doing so he adds new columns at the end. It isn't a good programming method but it works. Another option is to record a macro to do the renaming, but that is still an excel step. Ideally you'd connect to the file on the DB through SAS. If you can't connect directly to the report database though using ODBC or some other connection then I hope someone has a better solution.

Reeza · ‎01-10-2011

IF the data looks like you want it to it is. Given that you had the upcase before you probably still need it now. When comparing strings SAS is case sensitive, ie corn ne Corn so upcasing both will correct for that. ie upcase (corn)="CORN". HTH

Reeza · ‎01-10-2011

You can specify multiple conditions using "and" or the in/not in function. data want; set sashelp.class; where age ne 13 and age ne 14; run; OR data want; set sashelp.class; where age not in (13, 14); run;

Reeza · ‎01-10-2011

Why have the sum declared outside the datastep? Its easy to solve the problems you're proposing, but then you say it might be more complex so without you being clear enough it's kind of a moot point. A random guess into what you're doing looks like BY processing with RETAIN statements needed to calculate some kind of running total, but if you don't provide a more clear example of what you have and what you want its almost impossible to help you. The following may help. http://www2.sas.com/proceedings/sugi31/246-31.pdf Message was edited by: Reeza

Reeza · ‎01-06-2011

What Nick R said. Small enough difference, but this doesn't do much of a comparison, probably more pronounced in character or other types of comparison. [pre] data ifelse; do i=1 to 1000000; x=rand('normal', 0,1); if x>0 then y=1; else if x<=0 and x>-0.5 then y=0; else if x<=-0.5 then y=2; output; end; run; data if; do i=1 to 1000000; x=rand('normal', 0,1); if x>0 then y=1; if x<=0 and x>-0.5 then y=0; if x<=-0.5 then y=2; output; end; run; [/pre] Message was edited by: Reeza Message was edited by: Reeza

Reeza · ‎01-04-2011

Out of curiousity what type of process would a SQL cursor implemented in SAS be more efficient than a SAS datastep?

Reeza · ‎12-28-2010

I'm assuming simply connecting Excel to the OLAP presents a connection problem, rather than to reports built off the OLAP? What about creating pre-run reports that are updated every week/month? Why not use the SAS business intelligence tools? I'm assuming they can build reports where you can change things as you need. Unfortunately I've only worked with Cognos and Microsoft Reporting Services not SAS BI, and they both handle this easily...another option could be an open source BI tool, ie Pentaho or Microstrategy. SAS EG does have a few tools to connect to OLAP that I found quite interesting, but again, little experience with those tools. Maybe repost this question in the Business Intelligence forum? Message was edited by: Reeza

Reeza · ‎12-22-2010

have you tried the force option?

Reeza · ‎12-22-2010

Some questions I'd have... What kind of analysis are you doing? Are you pivoting/filtering? Or are you running regression analysis or other tools? What size (num of records/variables) are you talking about?

Reeza · ‎12-06-2010

If you're using Windows you might be able to filter out .sas files in the My Recent Documents Folder. The path is C:\Documents and Settings\username\Recent Get a program to read all entries in this folder and then filter for .sas is a possibility I think. Not sure if it would actually work based on the fact that its shortcuts not the actual files. Or how it gets populated, ie open file from within SAS or from contents pane, or from double click in windows. http://support.sas.com/kb/24/707.html I gave it a quick test try and the pipe part of the code didn't work for me, but I always have trouble with that kind of stuff.

Reeza · ‎12-06-2010

I'd be a bit cautious when using the recently used file list. Depending on how I open certain programs they may or may not appear on my list. But if that's fine with you than have fun with it.