About PGStats

PGStats · ‎02-29-2012

Not sure I understand your question. Is there a fixed relationship between NoReadm and YesReadm? PG

PGStats · ‎02-29-2012

Thank you Fried for a nice puzzle! For large n values, I can only think of approximate solutions, such as (20/9)**(n-1) or perhaps, (10/4)**FLOOR((n-1)/2) * (10/5)**CEIL((n-1)/2) No, come to think of it, the following value should be closer: (2**7*3**2)**((n-1)/9) = 2.188575**(n-1) I'm curious to know how far those approximations are to the exact walk counts. PG Message enhanced by: PG

PGStats · ‎02-28-2012

You are right Patrick. Then Halaku is stuck with using a pass-through query :smileycry: ! PG

PGStats · ‎02-28-2012

The result of intnx which in this case will be a datetime constant would be passed to Oracle. That is just a guess, of course. One must try it. PG

PGStats · ‎02-28-2012

The SQL syntax to use when replacing missing values with something else is the COALESCE function: select coalesce(dischdt2 - admitdt1, 0) as time1, coalesce(dischdt4 - admitdt3, 0) as time2, ... also, since most DBMS have functions equivalent to coalesce, SAS can translate when accessing remote data. PG

PGStats · ‎02-28-2012

Good point Patrick. This might work instead, if SAS SQL can optimize out the constant before sending it to Oracle: where datestamp >= intnx("MINUTE", DATETIME(), -30, "SAME") - PG

PGStats · ‎02-28-2012

Too late to retract this question… The answer was that Eq. 1 and Eq. 2 were in error. They should have read (Eq. 1) : P(x=m) = PDF(“NEGB”, m, 1/(1+ α2µ), 1/α2), and (Eq. 2) : P(x=m) = PDF(“NEGB”, m, 1/(1+ α1), µ/α1). The values of _Alpha produced by PROC COUNTREG in negative binomial regressions effectively correspond to the factor in the mean to variance relationships. - PG

PGStats · ‎02-28-2012

I am not familiar with Oracle, bu I assume that the proper translation is done with timestamps when imported to SAS. Good luck. - PG

PGStats · ‎02-28-2012

If TIMESTAMP is a SAS datetime value then the condition intck("MINUTE", TIMESTAMP, DATETIME(), "CONTINUOUS") <= 30 will get the timestamps from the last half hour. PG

PGStats · ‎02-28-2012

I just changed my proposal. Sorry about the other version. OBS= only works for input datasets, it doesn't work with output datasets. -PG

PGStats · ‎02-28-2012

PROC SURVEYSELECT will do a good job, but will not return the observations in random order. As Art pointed out, you will need extra work to shuffle the selected observations. For simple random sampling, you can get the same result with the following procedure. Assuming your observations are in dataset have, the following will select exactly 50 observations without replacement, ordered randomly in dataset want : /* Writes a warning about terminating early */ proc sql outobs=50; create table want as select *, rand("UNIFORM") as _randomNumber from have order by calculated _randomNumber; proc print; run;

PGStats · ‎02-28-2012

And just for the sake of ecumenism :smileygrin: : data have; input ID $ x; datalines; a 1 a 1 a 0 a 1 a 1 b 0 b 1 b 1 b 0 b 0 ; data have1; set have; obsNo = _n_; run; proc sql; create table want as select A.ID, A.x, sum(B.x) as y from have1 as A, have1 as B where A.id=B.id and A.obsNo<=B.obsNo group by A.id, A.obsNo, A.x order by A.id, A.obsNo; drop table have1; proc print data=want; run;

PGStats · ‎02-27-2012

Seasonality is mostly tested for time series data. You should read about SAS-ETS - Overview of the Time Series Forecasting System http://support.sas.com/documentation/cdl/en/etsug/63348/HTML/default/viewer.htm#tfintro_toc.htm also look at proc SPECTRA for an alternate way of detecting seasonality. SAS-ETS is a separate product from SAS-STAT. PG

PGStats · ‎02-27-2012

data have; input ID $ x; datalines; a 1 a 1 a 0 a 1 a 1 b 0 b 1 b 1 b 0 b 0 ; data have1; set have; obsNo = _n_; run; proc sort data=have1; by id descending obsNo; run; data want; set have1; by id; if first.id then y=0; y+x; run; proc sort data=want out=want(drop=obsNo); by id obsNo; run; proc print; run; That does it. - PG

PGStats · ‎02-27-2012

There is this wicked :smileycool: technique learned from Tom recently: data have; input ID Year Value1 Value2 Value3; datalines; 1 1999 . 270 . 1 1999 . . 350 1 1999 . . . 1 2000 20 . . 1 2000 . 300 . 1 2000 . . 320 1 2001 . 122 . 1 2001 . . . 1 2001 . . 500 ; data want; update have(obs=0) have; by id year; run; proc print; run; Works just fine. - PG

Online Status	Offline
Date Last Visited	‎06-09-2024 06:52 PM

Re: Randomly select 3 rows with condition

Re: Randomly select 3 rows with condition

Re: Requête inner join conditional

Re: How to change order of variables in the graph produced by lines in...

Re: Duplicate value within ID

Re: Notation scientifique dans une variable de type alfanumerique $cha...

Re: Make new variables using if statements in proc sql

Re: How to use GROUP BY to concatenate strings in SAS proc SQL?

Re: Need to remove the exponential from the number

Re: how can get help about "proc split" online ?

Re: Heteroskedasticity

Re: Create a table with increasing integers from 1 to N in SQL

Re: Create a table with increasing integers from 1 to N in SQL

Re: Randomly select 3 rows with condition

Re: How do i parse specific number combinations from a field in a tabl...

Re: changing units in a regression

Re: proc sql for repeat calulations using a multilevel dataset

Re: How do I set up PROC GLIMMIX for simple biology problem?

Re: Add semi-annual variable to existing table

Re: Proc Transpose help - "Name of Former Variable" column not recogni...

Geometric mean for zero values

Convert LAT-LONG to UTM, and back

Finding all single linked chains: the allChains macro

How to find all connected components in a graph

Finding a complete sub matrix (aka finding maximal bicliques)

0 obs with chi square

Re: Knights of the Dialing Pad (Math Puzzle)

Re: How to extract data for last 1/2 hour?

Re: How to extract data for last 1/2 hour?

missing values with .

Re: How to extract data for last 1/2 hour?

Re: Parameter _Alpha in COUNTREG with DIST=NEGBIN(P=1)

How to extract data for last 1/2 hour?

How to extract data for last one hour?

Re: random observations

Re: random observations

particular cumulative sum

test for seasonality

particular cumulative sum

Re: How can I combine multiple rows to a single row?