mterjeson's articles:

Items(1388) /139 Next >> Last >|

Re: Bug? or FP anomaly #2 0 160 (3/3/2010 11:14:16 PM) comp.soft-sys.sas Hi Stefano, This does not keep you from using the ROUND() function or something to chop off the really small stuff and get what you want. e.g. data a; a=1.11; b=a-1; if round(b,0.0001) = r... Mterjeson

Re: Bug? or FP anomaly 0 123 (3/3/2010 7:53:40 PM) comp.soft-sys.sas Hi Stefano, There are some rare cases where certain mantissa values can't quite be handled as expected due to floating point number and floating point precision issues. There was a couple of good posts... Mterjeson

Re: Picking a value from one variable based on values in another 0 21 (2/26/2010 7:46:34 PM) comp.soft-sys.sas Hi Angel, Here is one approach using SQL. Each LEFT JOIN are the separate aggregations. data sample; input Student time var; cards; 1 1 M 1 2 0 1 3 0 1 4 1 1 5 1 2 1 0 2 2 0 2 3 0 3 2 M 3 3 1 4 2 0 4 4 1... Mterjeson

Re: DELETE THE RECORDS 0 24 (2/17/2010 6:09:16 PM) comp.soft-sys.sas Hi Kasa, As long as your rules include the subjid and date and time already in sort order, and that there are always records prior to the first non-missing qty, then here is one approach which makes use of adj... Mterjeson

Re: how to append all sas dataset #2 0 21 (2/11/2010 9:16:30 PM) comp.soft-sys.sas Hi Jess, Of course you can cascade two at a time via SQL (outer union corr) as well as PROC APPEND, but the SET statement might be the least coding. e.g. data result; set month1 month2 mo... Mterjeson

Re: Join data horizontally #2 0 30 (2/11/2010 4:53:34 PM) comp.soft-sys.sas Hi Suren, Well, as we know, most languages do not allow more than one variable with the same variable name. However, for dataset one and two, you could distinguish them by renaming them to A1 and A2 and B1 and... Mterjeson

Re: Little problems with macros, notes, errors and reg 0 25 (2/8/2010 4:43:51 PM) comp.soft-sys.sas Hi Daniel. Here is feedback on 5 out the 6 questions: 1) option source2; 2) If you turn on option mprint; it will still report the line number as the start of the macro, BUT you will also no... Mterjeson

Re: How to force the execution order of COMPUTE blocks in PROC 0 20 (2/2/2010 5:18:11 PM) comp.soft-sys.sas Hi Jim, You have LINE output for compute block A so I presume you want a line output for each of the A groups (i.e. 5,10,14). So if you also want the lines 6 and 11, just change IF (A_done_no_B) THEN Line_... Mterjeson

Re: Problem running bat file #4 0 37 (2/1/2010 4:48:53 PM) comp.soft-sys.sas Hi Sunny, In addition to Ya's observation to tell the .bat file to treat the lines as continuation lines so that it looks like one command line to the operating system, bear in mind that on Windows, if you wer... Mterjeson

Re: puzzling SAS I/O question #5 0 26 (1/29/2010 10:26:37 PM) comp.soft-sys.sas Hi, To second Art's motion, when dealing with large files, i/o (across the wire) between boxes is typically the slowest link in the chain. --as the old saying goes. Mark -----Original Message----- From: SAS... Mterjeson

mterjeson's replies:

Items(482) /49 Next >> Last >|

A Confusion about how to filling out empty cells with duplicates. 4 21 (10/16/2009 3:53:01 PM) comp.soft-sys.sas I have three variable as below (Subject,number1,number2): Subject number1 number2 ------- ------- ------- 10001 212 10001 10 10002 555 10002 10002 10002 ... need_sas_help (102)

Can I specify order=data and order=freq in proc freq? 1 22 (10/28/2009 6:03:39 PM) comp.soft-sys.sas In proc freq, can I specify order=data and order=freq in proc freq? I want the data order as the input data set, because the data are: Q1R1C1 Q1R1C2 Q2PR2C8 Q2TR1C1 Q2TR1C2 Q2TR10C1 Q2TR10C2 Q12TP1C1 Q12TP1C2 Q... qdmiris (38)

Cumulative subtract - easy for you, surely :-) 3 23 (11/3/2009 3:16:42 PM) comp.soft-sys.sas Hello, I've been trying to subtract pols_cancelling from the total (87249) and then from previous row so I have a "descending" cumulative column but I can't get it to subtract from the previous row, only from ... vanessa.monro (2)

Selecting the top 3 records with a twist 4 245 (11/18/2009 9:06:57 PM) comp.soft-sys.sas Hi Everyone, I have a dataset that looks like this. data have; input id rank; datalines; 1 1 1 2 1 2 1 2 1 5 1 6 2 1 2 1 2 1 2 1 2 5 3 1 3 2 3 3 3 3 4 1 4 2 4 3 5 1 5 2 6 1 6 1 6 ... foa2

SCL Editor in X-Windows 2 154 (11/19/2009 9:03:49 PM) comp.soft-sys.sas In the SCL Editor in X-Windows (under HP-UX) how can I select text and then color it using command "COLOR MTEXT ORANGE" or some other color? It appears that after a text is selected, it only remains selecte... walker.627 (147)

Strange PROC TRANSPOSE 3 122 (11/19/2009 11:02:53 PM) comp.soft-sys.sas Hello: I have data like this that I need to do a strange transpose X Y Z 1 A 1A 2 B 2B 3 C 3C 4 A 4A 5 B 5B 6 C 6C where Y is jus... stats112

Macro question: How to created macro variables from a macro 2 137 (11/20/2009 3:49:11 PM) comp.soft-sys.sas The macro below works when I don't use the CI variable and instead hard code the size of the confidence interval. When I add the CI= option in the macro it doesn't work, I'm guessing for a number of reas... Kevin.F.Spratt (64)

OT: Friday Humor 5 105 (11/20/2009 4:02:11 PM) comp.soft-sys.sas heard in the hall: 'We need to be proreactive.' see also: http://www.despair.com Ron Fehd the *-mania maven CDC Atlanta GA USA RJF2 at cdc dot gov ... rjf2 (3354)

PROC REPORT pagination order? 2 329 (12/9/2009 9:09:56 PM) comp.soft-sys.sas Hi All, On a v8.2 platform I have tried the following syntaxes in PROC REPORT: define my_date /group order=3Ddata descending 'MyDate'; or define my_date /group order=3Dinternal ... mterjeson (1932)

Change default in Viewtable? 3 24 (1/19/2010 6:36:59 PM) comp.soft-sys.sas Hi...is it possible to change the default Viewtable display of the column/variable LABELS to the column/variable NAMES? I think there was a post on this last year sometime but I can't recall the details. Than... sfbay0001 (430)