sas

  1. J

    How to do a post hoc analysis on non-parametric data in SAS

    Good morning! I know there is a statistically significant difference between groups for my non-parametric data-set but I'm not sure how to find where those differences lie between groups.. I'm comparing race/ethnicity (Asian Pacific Islander, Hispanic, etc) by academic discipline (dental...
  2. K

    Non-para: "THE CONFIDENCE INTERVAL FOR MEDIAN BASED ON SIGN"

    So my professor decided to write his own textbook, and we are finding errors everywhere, and it's difficult to understand, so I've tried google-ing and everywhere I go people are using different methods than the one he wants me to use here is an expample of what I am working with: 9. A...
  3. K

    time series with bivariate data?

    I have a datetime (yearly) variable which indicates when/if a subject registered, a count of the 400,000 subjects who registered at each facility and those subjects identified as being asked a particular question upon registration, a dichotomous yes/no. The requester asked that their time to...
  4. K

    how to use characters when calling values for a variable?

    Hi, I have a database with a variable "stage" with the following values: 1, 2, 1A, 1B, 2A, 2B. I am trying to trim my data by finding all the people where the variable "stage" = 1B and delete them from the dataset. I tried using this code: data = allpeople_no1B; set...
  5. J

    PISA 2012: Calculating variance explained by ESCS

    Hi there! I was wondering if anyone could help me figure out why I am getting the wrong results! I am using the PISA dataset of 2012 to calculate the variance explained by ESCS (socio-economic status). I followed the steps in the PISA DATA ANALYSES Manuel 2nd edition for SAS: 1...
  6. S

    reshaping data

    I am trying to reshape data in SAS in a very specific way. The data looks like: ID Q1 Q2 491 0 0 491 0 1 1040 0 1 1040 1 0 1040 2 1 And, I want to transform the data to the following shape: ID Q1A Q1B Q2A Q2B 491 0 0 0 1 1040 0 1 1 0 1040 0 2 1 1 1040 1 2 0 1 So, a pair of variables...
  7. A

    SAS GLIMMIX subject specific estimates

    I am trying to analyze a dataset where each subject has 12 repeated measures (quarterly, over 3 years). I want to extract subject specific estimates of the time slope to evaluate if the subjects are changing significantly over time. The code I currently have consistently suggests that each...
  8. D

    Using MLE to find the right distribution

    Hi, I know that MLE can be used to find the best fitting parameter assuming a that the distribution is known, but is there a way (using Excel or SAS) to find what distribution best fits the data (together with the best parameter of the distribution), in other words, the distribution is not...
  9. J

    PROC Means for dummy variables in SAS

    I have created a dummy variable in SAS, that in any given year takes the value 1 if both countries are members of the EMU and 0 otherwise in that year. emu1=0; if country1 in ("AUT","BEL","FIN","FRA","DEU","IRL","ITA","NLD","PRT","ESP") and year>1998 then emu1=1; if country1 in ("GRC") and...
  10. M

    sample size calcs - why do these produce different results

    What are the interpretations for each of these? data a; input z p q e; cards; 1.96 0.95 0.05 0.05 ; data b; set a; n=(z*z*p*q)/(e*e); run; proc print; run; ****************************; proc power; onesamplefreq test=z method=normal sides =...
  11. K

    Trying to replicate SAS Proc Logistic Code in SPSS or R

    I am an inexperienced user on R and mostly use SPSS for any statistical analysis. Recently I have been working at trying to replicate work done using the SAS PROC LOGISTIC command to create a mortality indicator model. I have tried all the logistic models available in SPSS but cannot get the...
  12. S

    How to calculate Log Hazard Ratio in SAS

    proc phreg data = analysis ; class c diabetes /descending; model days*ind(0) = c diabetes id/ rl ; id= c *diabetes; hazardratio id; run; I am trying to run a simple Cox Regression in SAS. I cant seem to find a way to calculate log-hazard ratio for my variables in the model. The hazard...
  13. V

    Selecting Specific Entries

    Dear SAS Users, Hello SAS Users...I have two columns an sample of which is shown below.... ID NUMBER 35 1015 35 1015 35 1015 36 2014 36 2014 41 5689 41 5689 42 5689 56...
  14. K

    Helo me to Importing flat file

    Hi i have a flat file around 100gb. it has 200 variables like company name, address..like that. In company name i have fields like google,ibm,tcs like that. i want to import this flat file with a filter on company name i.e i want only google records to be loaded in sas dataset rather that import...
  15. K

    Modeling step by step in SAS

    Can anyone guide me in building a credit score model in SAS from beginning to end? Like how to get started with it and how to proceed?
  16. M

    Need ideas to modernize using SAS my data cleaning approach

    Hi, I have been given various large datasets that require a lot of time and effort cleaning incorrect codes (from a scanner that did not read the data correctly). I have completed the first dataset and feel that the route that I chose to get the corrections made were much too manual and there...
  17. I

    Help Regarding Splitting Observation with Long String

    Can someone please help me with this: Here is raw data ID Term 1 1. Horse Riding 2. Fishing 3.Climbing 4. Jumping 5. Hiding 2 1) Horse Riding 2) 100m Running 3) Typing 4)Bungey(200m High) 3 Horse Riding, 100m Running, Hunting, Paragliding + Parachute Desired Dataset ID Term 1...
  18. I

    SAS help regarding putting observation Together. Please help

    Here is the raw data: name var1 var2 var3 startdate enddate jack x y z 01jan2012 01jan2012 jack x y z 02jan2012 02jan2012 jack x y z 03jan2012 03jan2012 jack x y z 04jan2012 04jan2012 jack x y...
  19. sufeipopo

    How to interpret residual plot of a logistic regression?

    Hi all, I'm working on a default probability model and was modeling the default probability using logistic regression. The pearson residual and deviance residual plots are attached. Can anyone give me some idea about how to interpret these two plots? Do these plots indicate...
  20. sufeipopo

    How to interpret residual plot of a logistic regression?

    Hi all, I'm working on a default probability model and was modeling the default probability using logistic regression. The pearson residual and deviance residual plots are attached. Can anyone give me some idea about how to interpret these two plots? Do these plots indicate...