sas

  1. E

    SAS Missing Data Imputation: Arrays + Proc STDIZE

    Hi Guys I came across this following code: data dataset(drop=i); set data; array mi{*} mi_Ag mi_Inc mi_WR; array x{*} Ag Inc WR; do i=1 to dim(mi); mi{i}=(x{i}=.); end; run; I need to understand two things: 1.) there is a column...
  2. S

    Contrasts (simple effects after interaction)

    Hi, I need a help with SAS syntax regarding contrasts. I found after I ran GLM some interaction effects, but now I need to find out which independent variable has effect on my dependent variable. My advisor told me to do contrasts, but I am unskilled with it :( Design is 2x2 (type X color)...
  3. M

    Infile for non-standard data

    I have a messy file (does not line up in columns), where some of the columns are tab delimitated and some are comma. My problem with the data set is reading the files with variable lengths 12 Stephen Cole, 33, Columbia, MO 5 Dave Anderson, 25*, Concord, OH The first...
  4. C

    Help deciding what stats to run in SAS to determine effect of Obs bias on Group Size

    Hello, I'm trying to determine if the observer group size of a study ( 1, 2, 3) and experience of the observer impacts the potential for observer bias ( Type 1 and 2 errors) when conducting auditory surveys. I'm going to analyze my data is SAS 9.3 and was hoping people would have some advice...
  5. S

    Finding Optimal Cutpoints for Continuous Covariates with Time-to-Event Outcomes

    I found this interesting article from MayoClinic, where they talked about a macro that finds a cut point for a continuous variable with a time to event outcome. Does anyone know where I can find this macro? Is there a macro repository that might have this macro? It is not available on the...
  6. A

    How to transpose Please Help.

    Hi I have just started working on SAS and I am a beginner.. Please help me how to transpose a simple data from rows to columns.. for ex: I have PID 1 2 3 4 5 6 7 8 patient a b c d e f g h room 001 002 003 004 005 006 007 008 I want to have it like PID Patient Room 1...
  7. C

    Power Analysis and Sample Size determination help!

    Hi all! I am new here so I hope my post is appropriate! I have searched the web and this forum and haven't been able to figure out how exactly I need to perform a power analysis for sample size determination (although I admit I didn't scroll through ALL of the results to my search on this...
  8. A

    How to analyze survey data with three levels of data in SAS?

    We analyze data from a European survey (34 countries ) for quality of life , the sampling procedure is described as a " multi-stage stratified and clustured sampling design " . Our outcome variable is binary. There are three levels of data to be taken into account (individuals, regions...
  9. M

    Base SAS Programing: Calculating KPIs Over Different Time Ranges

    Hi all. I am trying to calculate values for KPIs over certain time ranges – Response Rate, Conversion Rate and Yield. I need to use SAS to do this. This is the desired output I’m looking for: MTD/YTD Dates Tactic Response Rate Conversion Rate Yield Rate Last 3 Month Performance...
  10. J

    dendrogram graph - how many clusters would you pick in this with reasons why?

    Hi having a little problem with this question which i need to learn for my test coming up.. i have produced a dendrogram (on sas enterprise) which consists of 77 countrys with various information. I need to discuss the graph and explain how many clusters i would pick and why? (its more...
  11. T

    Divorcing SAS

    I'm pretty dang good in SAS, and I always have been (if I may say so myself :)). And let me say this: SAS is a great product; it's become so successful for good reason. But lately I've consciously been distancing myself from it. I've been doing things in R, mysql, and even C that I would've...
  12. P

    Repeated measures ANOVA w/ time-varying covariate that does not vary across subjects

    Hello community: I am seeking assistance with a repeated measures ANOVA. In this experiment, I examined the return rate of bees to colonies (= dependent variable). These colonies were subjected to one of four food treatments (= categorical predictor variable). The return rate of bees was...
  13. T

    Need advice writing SAS programs to read datas

    4. The following table lists 3 personnel records of a company. Staff ID Birthday Monthly Salary A123 4 March 1989 8,600 A037 23 June 1957 21,450 M015 19 September 1976 17,500 Staff id number has the format...
  14. S

    Help***SAS - Fill missing value with the last non missing value variable

    Hi, I wanted to fill missing value with the last non missing value variable. +----------+--------+-------+ | Variable | Level | Value | +----------+--------+-------+ | | men | 10 | |sexe | female | 20 | | | 0-20 | 5 | |...
  15. B

    STATA to SAS: survey logistic regression

    I am getting very different coefficients and p-values with STATA and SAS. It would be great to figure out which program is set up wrong. My sampling weights variable is samp_wt. My cluster variable is sta3n. My binary response is Screened. STATA: svyset sta3n [pweight=samp_wt] svy: logit...
  16. R

    SAS Logistic Regression - High Wald Chi square for a binary variable

    I am working on an analytical task where I need to identify why a particular binary independent variable is having high Wald chi-square (approx. 10k) when compared to the other variables (approx in 100's) in the logistic regression model. Can I simply conclude by saying that the response...
  17. P

    normal distribution for number of members by age

    Hello , I am trying to find out the normal distribution of number of members against each age-group. I have use the sas code but I am not sure if its the correct one . data totalmembers; input year age$ members; datalines; 1997 16-21 20.70 1997 22-29 46.70 1997 30-39 60.80 1997...
  18. E

    Logistic Regression -some expert advice !

    Hi guys I've recently worked on a project involving Logistic Regression. Although I've managed to 'complete' the project, I'm unsure whether what I have done so far is correct and/or sufficient. It is a case of regular binary logistic regression. One dichotomous response variable and several...
  19. T

    Can I assume these are independent?

    Hello! Trying to resolve in my mind a small dilemma. I'm assessing the risk factors for blood loss in surgery. The data come from an observational study. I ran bivariate analyses on each of the risk factors and the outcome variable. Next, using proc genmod, built a model based on AIC to...
  20. E

    Logistic regression with predictor variables with both categorical & actual values

    I've got a data set with 40 variables with 30 variables each having certain observations that are coded (i.e. have values) from 1-6 describing certain situations and some values that provide real values for what each of those variables represent as well. i.e. the variables are partially...