About BruceBrad

BruceBrad · ‎10-09-2014

(Almost) perfect. I had missed the Round option. But (as I've just realised after testing) not quite correct. The mult options should be 0.01 not 0.001 to get thousands when you have one decimal place. So the format should be proc format; picture thousands (ROUND) LOW-<0 = '000,000,000,009.9' (PREFIX='-' MULT=0.01) 0-HIGH = '000,000,000,009.9' (MULT=0.01); run;

BruceBrad · ‎10-09-2014

I want to print values like 1360 as 1.4 (thousand). Can this be done with formats, or do I have to calculate values? Eg the following code, gives an output of v1=1.3 v2=1.4 But I want v1 to look like v2. proc format; picture thousands low-high='000,000,000.9' (mult=.01); data test; v1 = 1360; v2 = v1/1000; format v1 thousands.; format v2 comma10.1; put v1= v2=; run;

BruceBrad · ‎10-08-2014

Is it possible to configure SAS so that the Help search only returns results for the SAS products that I have installed? It's a real pain to wade through lots of irrelevant stuff when searching for syntax help.

BruceBrad · ‎06-19-2014

Rick, I think you are wrong here. Your linked post is all about the case where the explanatory variable is continuous. Here it is discrete. In this case, I think quantile regression _is_ the same as collecting the sample quantiles. I'll try and mock up some example data soon and come back to this.

BruceBrad · ‎03-10-2014

Actually, I think Reeza's approach is the neatest way to go. Step 1. Create two records from each of your records - one for each team as Reeza suggests Step 2. Sort by date within team, and create a variable COUNT that counts the number of times the team has competed. That is, starting at 1 for the first occurence of the team etc. Step 3. Create a dataset which only has the last record for each team. Step 3. Merge this dataset with the step 2 dataset, selecting records where count is greater than the current value of count minus 16. Step 4. Summarise this merged data, counting the number of wins etc.

BruceBrad · ‎03-10-2014

The 'brute force' method would be to use the 'point' option on the set statement to loop back through the file identifying whether the team in question was in the match, recording the result, and stopping once you have reached 36 matches or the start of the file. No macros required.

BruceBrad · ‎03-10-2014

Sounds like what you want is just the number of cases with values between the first and second percentiles, the second and third percentiles and so on. By definition, this is always just 1% of the total number of (non-missing) cases in the file. It might be slightly above or below this if the data are not truly continuous or is weighted. In your decile example, the volume numbers are all around 10% of the sample size. Unless you are trying to look at the impact of ties in the data, it is not a particularly interesting statistic.

BruceBrad · ‎03-10-2014

The independent variable is a binary variable 'income' (1='poor' 0=otherwise). The dependent variable is an achievement score. I want to calculate the impact of being poor on the quantiles of achievement. Because of clumping in the achievement score, I find that the effect is quite variable. For example, the 10th and 20th percentiles of achievement of poor children are below that of the 10th and 20th percentiles for the non-poor, but the 15th percentiles are equal. I would like to smooth the results across the quantiles.

BruceBrad · ‎03-07-2014

I have a dependent achievement score variable which is continuous, but is also of uneven density, with small areas of high density followed by areas of low density. If I do a quantile regression with a single binary RHS variable, I find that there might be a significant gap (ie coefficient) at the 10th percentile (say), followed by no gap at the 15th, then a significant gap at the 20th and so on. These variations come from the uneven density. The heaping of the density is (probably) not particularly meaningful, but merely represents the limitations in the way the dependent variable is constructed. Is there a way to smooth the quantile regression results? For example, to fit a cubic function of percentile across the various quantiles?

BruceBrad · ‎03-07-2014

Proc univariate does this.

BruceBrad · ‎01-30-2014

To estimate a fixed effects model with (fixed) effects at the participant level, you will need to have more than one observation per person - which you don't seem to have. Think of it as adding in a dummy variable for each person (though the software does this for you automatically).

BruceBrad · ‎08-02-2013

Is there any documentation describing when proc SQL will multithread? If I wrote my simple example in SQL, would it process it with multiple threads?

BruceBrad · ‎08-02-2013

I gather MP Connect can be used to setup multi-thread processing. Can people point me to documentation and simple examples? An example problem. I have something like: data subset; set full (where=(var1=1)); run; We have a Win2008 server with a fast disk system and 32 cores which we use pretty much as a workstation (usually just one job running at a time). If I run this job on a large dataset, it takes about 5 minutes with one cpu core at 100% and the others unused. Is it possible to split the processing across multiple cores?

BruceBrad · ‎05-30-2013

Thanks Karl Well yes, I do know the name of the program in the editor, but I'm working with several different ones and get easily confused 🙂 Re 2), that is an interesting idea, but it is not really any better than cutting and pasting into my email program. I'll do some more exploring on 3) and maybe put up a separate thread. Cheers Bruce.

BruceBrad · ‎05-30-2013

Karl, the scenario is basically as you describe. I have the program open in the editor and am testing it on my local machine. When it is ready to go, I want to type something on the command line (or choose a menu item or button) which will then start a program which 1) finds out which sas file I currently have open 2) saves it (sounds like flsvlast is the command I need for this) 3) runs another SAS program which reads the file back in and sends it to email. So step 1 requires some 'automating'. I'm also pondering how to do step 3) because I can't use MAPI (I'm using SAS 64 and Office 32) and I don't seem to have access to a simple SMTP server - my university SMTP server requires STARTTLS.

Online Status	Offline
Date Last Visited	‎10-14-2025 05:31 PM

Re: SAS slop on the internet

SAS slop on the internet

Re: Bug in SGPLOT when using max= in yaxis statement

Re: Bug in SGPLOT when using max= in yaxis statement

Re: Bug in SGPLOT when using max= in yaxis statement

Bug in SGPLOT when using max= in yaxis statement

Re: How to directly edit files in EG

Re: How to directly edit files in EG

Re: How to directly edit files in EG

Re: How to directly edit files in EG

Re: How to directly edit files in EG

Re: SGPlot and Curvelabel positioning

Re: Trap when merging, then redefining variable

Re: Macro to strip operators from string

Re: Proc Import: Can I suppress "NOTE: VARCHAR data type is not suppor...

Re: SAS slop on the internet

Re: How to directly edit files in EG

Trap when merging, then redefining variable

Re: linear and non linear combinations of previous estimated

Proc Export: Maintain case of variable names when exporting to Stata

Re: Formating as thousands with rounding

Formating as thousands with rounding

SAS Help configuration

Re: Smoothing quantile regression results

Re: Loop through each observation and count previous occurrences of va...

Re: Loop through each observation and count previous occurrences of va...

Re: proc univariate and output , Please Help..Thank You..

Re: Smoothing quantile regression results

Smoothing quantile regression results

Re: Define quantiles using weights

Re: Fixed effects regression

Re: MP Connect introduction?

MP Connect introduction?

Re: Emailing the contents of the program editor window

Re: Emailing the contents of the program editor window