Re: Bug? or FP anomaly #20160 (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 anomaly0123 (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 another021 (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 RECORDS024 (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 #2021 (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 #2030 (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 reg025 (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 PROC020 (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 #4037 (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 #5026 (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
Can I specify order=data and order=freq in proc freq?122 (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 :-)323 (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 twist4245 (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-Windows2154 (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 TRANSPOSE3122 (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
OT: Friday Humor5105 (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?2329 (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?324 (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)