About bncoxuk

bncoxuk · ‎11-21-2011

Sorry to bother. I used the PROC UNIVARIATE to get the percentiles. The code is: PROC UNIVARIATE DATA=work.data01 NOPRINT; VAR diff; OUTPUT OUT=work.pctile01 PCTLPRE=P_ PCTLPTS=1 to 100 BY 1; RUN; Note that: the prefix is given as P_. This made all the percentiles as: P_1, P_2, ... P_10, P_11... P100. Is there any way that I can make the percentile lables as P_001, P002, P003, ... This made it easier in my case for further data processing.

bncoxuk · ‎11-21-2011

Thanks, Tom. I just got it right. Basially, the values in the key variable are: pctile1, pctile2, ... pctile10, pctile11, So the values are not sorted, thought it looks like they are Sorry and thanks!

bncoxuk · ‎11-21-2011

Sorry the datasets are different. So it is definitely a merge. The datasets have one same variable.

bncoxuk · ‎11-21-2011

I have many files in the work library with the names as data01, data02, data03, ... data50. All these dataset have the same contents, with one variable as the key. My question is how can I merge all these files easily? I tried to do it using : as below, but failed. data work.data; merge data: ; run; Many thanks.

bncoxuk · ‎11-18-2011

I have a dataset with some unknow number of numeric variables (>10) and character variables (>20). The question is how to convert all the numeric values into character values, and then contatenate these values into a single string. Thanks very much.

bncoxuk · ‎11-17-2011

Thanks, Ksharp. COOK distance helped the model.

bncoxuk · ‎11-16-2011

This is a very tricky but interesting problem. I hope some statistical expert can really help. Below is the description of the data and analysis. 1) Data 1 million cases, 40 categorical variables with levels ranging from 2 to 50. The dependent variable is continuous which is pretty normally distributed. 2) Analysis: linear regression with effect coding for all categtorical variables. Step 1): The intercept (i.e., overall mean) was estimated to be 570, with all the final significant variables in the model. Step 2): remove 1307 exceptional cases (with leverage>2p/n and standardized residuals > 2), the intercept became 270. For this analysis, the intercept changed so much from 570 to 270, with the fact that only 1307 cases deleted (compared to the sheer large sample size of 1 million). Because the intercept standards for the overall mean, this caused potential problem for the interpretation of the model: how can the overall mean change so significantly with only 1307 cases deleted? I don't know how the intercept (overall mean) is estimated in general linear model. Any reference book? Please help. Thanks.

bncoxuk · ‎11-16-2011

Thanks for your suggestion, art297. The variables are not 100% perfectly correlated. Just a level of them. So I cannot remove variables. I found a way to deal with that: 1) recode the levels of variables into 0, -1, 1 (effect coding); 2) Only keep one of the correlated levels in the final model.

bncoxuk · ‎11-15-2011

I have a tricky question regarding a dataset. The dataset has 4 categorical variables with various categories. The trick thing is that they have one identical level (ie. 100% percectly correlated for this level). This caused a problem for running a linear model. SAS said the matrix is singular and the estimate is not unique. Is there any good idea to deal with this level? Thanks in advance.

bncoxuk · ‎11-08-2011

Initially, I used the EXPORT FILE under the FILE drop down menu.

bncoxuk · ‎11-08-2011

ODS LISTING CLOSE; ODS tagsets.ExcelXP FILE="params.xml" PATH="Y:\" STYLE=Statistical; PROC PRINT DATA=work.params02; VAR level / STYLE={tagattr='format:text'}; VAR estimate stderr tvalue probt variable; RUN; ODS tagsets.ExcelXP CLOSE; ODS LISTING;

bncoxuk · ‎11-08-2011

A bit paiful, indeed. Just wondering is there any simple way to do that? Simply just keep the format as original.

bncoxuk · ‎11-08-2011

Hello, I have a SAS dataset with a variable called region. The values are character type, as '01', '02', '03', ... '10', '11', '12'. When I export the SAS dataset to Excel, the values in Excel changed to 1, 2, 3, ... 10, 11, 12. That is, the first digit 0 is missing. My question is how to keep the values as in the original format '01', '02'...... When output to Excel? Thanks.

bncoxuk · ‎11-07-2011

Hello I have a numeric variable x with values ranging from 1, 2 to 25. If I simply use: y = PUT(x, 2.) then there will be one blank space for those x with one single digit, because the PUT function makes the length of 2 for all y. My question is: how can I make this conversion without adding any blanks to y?

bncoxuk · ‎10-18-2011

I found a solution: just use PROC LOGISTIC, which can estimate type3 for sex and married when inter is specified (rather than sex*married).

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: How to concatenate character values across variables

How to concatenate character values across variables

How to concatenate character values across variables

How to create a report by combining results from simple PROC SUMMARY

LIKE '%' does not work

What is the functionality of || here

What is the functionality of || here

What is the functionality of || here

Re: How to get the percentage for each unique combinations of variable...

How to get the percentage for each unique combinations of variables

How to set all missing values to zero for all variables?

Label for the percentile points in PROC UNIVARIATE

How to merge files with similar names in the same library

How to merge files with similar names in the same library

How to merge files with similar names in the same library

How to convert all numeric variables into characters and concatenate t...

Overall mean of general linear model

Overall mean of general linear model

Categorical variables have an identical level

Categorical variables have an identical level

Output data to Excel

Output data to Excel

Output data to Excel

Output data to Excel

How to convert numeric values to characters without adding blanks

Interaction effect in PROC GENMOD