Re: SAS/htmSQL and AppDevStudio 1.2 not running 0 115 (6/24/2003 6:15:41 AM)
Hello Pawel, Try the following: 1. {query server="yourserver:port"} {sql} select myfield, myfield as myfield_formatted_value format=myFormat. from libref.yourTable ... or 2.select myfield, put(myfield,myFormat....
hztangli (2)

Re: delete rows based on a column being like-compared to other rows 0 90 (6/23/2003 10:14:25 PM)
Richard, I just came out the following code. Under some strict assumptions, it seems to work: data foo; length like $20; input like ; cards; jabba jabba% jabba%the%hut xyz%abc xyz%abc%def 132%xyz 132%xyz%npq ...
yhuang (489)

FULLSTIMER ?? 2 94 (6/23/2003 6:53:50 PM)
SAS-L: I must not understand the FULLSTIMER option or maybe it's just Monday. When I put this statement at the top of my program: options fullstimer ; and run it in the Display Manager, the LOG file ...
steve.wall (19)

Re: FULLSTIMER ?? 0 31 (6/23/2003 9:05:10 PM)
The grand summary is shown only when SAS terminates. I think other people would like the capability to obtain a running total and snapshot differences, but that's not currently possible. -- JackHamilton@Fi...
JackHamilton (928)

Re: datepart autoformat in a macro #2 0 164 (6/23/2003 8:25:38 PM)
Well, is that a date format? Can it be done without concatenating the quotes and d?. Your question was, what dateformat would return the value in the format '22Jun2003'd ? with quotes and D, all of it? ...
prasad.s.ravi (144)

Re: datepart autoformat in a macro 1 83 (6/23/2003 7:24:27 PM)
Arto: I don't recall any dateformat which will do that for you. why not create another variable say b with just the sas date value, create a macro variable of it and compare that value in your PROC SQL where...
prasad.s.ravi (144)

Re: Proc Means and Sorting 0 106 (6/23/2003 7:17:06 PM)
I agree that any other result would be very unexpected. But I am wary of making an assumption about the behavior of SAS when there is no explicit statement backing up that assumption. You've made two assertio...
JackHamilton (928)

Re: first and last 0 97 (6/23/2003 7:01:47 PM)
Supposing that she did want the first observation for each value of COLDATE, is there a way to accomplish that using PROC SQL? -----Original Message----- From: Prasad S Ravi [mailto:prasad.s.ravi@HOUSEHOLD.COM...
Doug_Cacialli (28)

datepart autoformat in a macro 0 78 (6/23/2003 7:00:39 PM)
section of a macro executes an item that appears as a = put( intnx ( 'day', date(), -1), mmddyy6. ); this returns to a macrovariable in another section today-1, ie. 062203 question is, what dateformat would ...
arto1 (24)

Strengthen the immune system 0 98 (6/22/2003 6:07:56 PM)
PGh0bWw+DQo8aGVhZD48dGl0bGU+Y29vc2pncGFhcWlic3hhdnRrcGZpa3J4cXV2Y2tta29i eWltaGFvaHJ3am14bGs8L3RpdGxlPjwvaGVhZD4NCjxib2R5Pg0KPGZvbnQgZmFjZT1WZXJk YW5hIHNpemU9Mj4NCjxwPjxhIGhyZWY9Imh0dHA6Ly93d3cuc2FzLWwuY29tQGFs...
Kayehl (1)