1. 10-14-2010
+ Post New Thread
Page 1 of 21 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 ... LastLast
Threads 1 to 60 of 1239

Forum: SAS

SAS usage and programming. SAS/Base, SAS/Stat, proc sql, SAS macro...

  1. Sticky Thread Sticky: Share your SAS tips

    Since SAS isn't as reliant on UDFs as much as R is, I thought a thread on tips/useful gems hidden in SAS documentation/stuff you learned would be...

    Started by Janus‎, 11-17-2012 11:34 PM
    2 Pages
    1 2
    • Replies: 22
    • Views: 10,105
    06-26-2015, 10:17 AM Go to last post
  1. Corrected AIC in Proc Reg

    Some call this AICc. Supposedly, some say, Proc Reg will generate this statistic, but I could not find it in the documentation. It is produced in...

    Started by noetsi‎, 05-28-2016 12:33 PM
    • Replies: 2
    • Views: 67
    05-28-2016, 03:44 PM Go to last post
  2. Proc Mixed effect interpretation

    Hello, I am analyzing an experiment in which we tested the effect of different treatments on trauma. So, for example, blood pressure (and other...

    Started by awolf‎, 05-26-2016 05:51 PM
    fixed effect, interpretation, mixed, multiple comparisons, sas
    • Replies: 1
    • Views: 107
    05-27-2016, 07:52 AM Go to last post
  3. Analysis of error on SAS

    Hi, I learned statistics using SAS 10 years ago and haven't used stats since then. But I'm back. I remember that before conducting a statistical...

    Started by Toshi‎, 05-24-2016 04:19 AM
    • Replies: 1
    • Views: 133
    05-24-2016, 10:24 AM Go to last post
  4. SAS datdiff statement

    I ran this code PROC SQL; CREATE TABLE SASUSER."tab1"n AS SELECT t1.VRID, t1.CASE, t1.STATUS, ...

    Started by noetsi‎, 05-23-2016 03:16 PM
    • Replies: 2
    • Views: 136
    05-24-2016, 10:13 AM Go to last post
  5. [SOLVED] Excluding cases in one table that are in second table.

    I have two tables. One is a subset of the other (call the subset table 2 and the larger table 2 is a subset of is table 1). I want to exclude from...

    Started by noetsi‎, 05-21-2016 01:12 PM
    • Replies: 1
    • Views: 103
    05-21-2016, 01:40 PM Go to last post
  6. does proc SQL use SQL server syntax, or oracle syntax?

    does proc sql use sql server syntax or oracle syntax? Im still trying to figure out how to sql code in SAS.

    Started by semidevil‎, 05-18-2016 04:18 PM
    • Replies: 1
    • Views: 151
    05-19-2016, 01:33 PM Go to last post
  7. Insert text into all cells of first column in a sas dataset

    I've output 'Moments' from Proc Univariate to datasets. Many. Example: Moments_001.sas7bdat through to Moments_237.sas7bdat For the first...

    Started by nkormanik‎, 05-16-2016 02:01 AM
    insert text
    • Replies: 0
    • Views: 104
    05-16-2016, 02:01 AM Go to last post
  8. how to change axis scale on scatter plot (or eliminate outliers)

    I have a simple scatter plot that I want to adjust on the Y axis. My values ranges between 200 an 4000, but 99.9% of my plots are on the bottom,...

    Started by semidevil‎, 05-12-2016 04:57 PM
    • Replies: 0
    • Views: 126
    05-12-2016, 04:57 PM Go to last post
  9. copy/paste from excel into sas data step

    Hello, I am trying to copy a table in excel and paste it into SAS (rather than using a proc import step). Because the excel is not in a comma...

    Started by agp‎, 05-11-2016 10:14 AM
    • Replies: 1
    • Views: 116
    05-11-2016, 08:39 PM Go to last post
  10. Bivariate (two dependent variables) logit regression

    Can bivariate (two dependent variables) logit regression be done by using SAS? Or is it only available for bivariate probit? There's a problem...

    Started by yffd‎, 04-27-2016 10:34 AM
    • Replies: 3
    • Views: 180
    05-10-2016, 10:12 AM Go to last post
  11. SAS and time series

    If anyone knows any good material on this, I have the documentation from PROC Autoreg and the books SAS publishes on time series, I would love to...

    Started by noetsi‎, 04-30-2016 05:32 PM
    • Replies: 5
    • Views: 423
    05-09-2016, 02:11 PM Go to last post
  12. [SOLVED] How do you pull out only month and year from data

    I suspect this is a format issue although I have not found one that works. I have day month and year and I want to convert it to a date with year...

    Started by noetsi‎, 05-09-2016 10:51 AM
    • Replies: 1
    • Views: 109
    05-09-2016, 11:02 AM Go to last post
  13. Moved: XMR chart

    Does anyone know where this is done in SAS (ideally in Enterprise Guide). I thought it would be easy to find, but having looked through the quality...

    Started by noetsi‎, 05-06-2016 03:37 PM
    • Replies: -
    • Views: -
    05-06-2016, 03:41 PM Go to last post
  14. How to estimate a Gaussian mixture model with the EM algorithm in SAS?

    I am trying to fit a univariate Gaussian Mixture Model with the EM algorithm. But I only found a package in R (mclust). Does anybody know an...

    Started by Da_Stat‎, 04-28-2016 12:38 PM
    em algorithm, gaussian mixture model, sas 9.3
    • Replies: 0
    • Views: 168
    04-28-2016, 12:38 PM Go to last post
  15. Create visit values based on time

    I am trying to create a visit number based on time. The data I have currently looks like this: Date Time Cow 11/1/15 2:00 77 11/1/15 ...

    Started by randiblack‎, 04-19-2016 05:08 PM
    sequence, time, visits
    • Replies: 0
    • Views: 285
    04-19-2016, 05:08 PM Go to last post
  16. arrays

    hi everyone can you please explain what the following code does? in particular the varnum macro? context: medical coding. data...

    Started by lydiajones94‎, 04-19-2016 01:01 PM
    • Replies: 2
    • Views: 172
    04-19-2016, 01:04 PM Go to last post
  17. SAS or R package for finite mixture bivariate probit model

    Hello, all, I would like to model my data using a bivariate probit model but would like to explain unobserved heterogeneity of the coefficients in...

    Started by lucymark2013‎, 04-07-2016 10:24 PM
    • Replies: 0
    • Views: 361
    04-07-2016, 10:24 PM Go to last post
  18. What are predictor units in proc reg?

    I ran proc reg code for an interval DV. One of the predictors was cost in dollars and cents. The slope then is the change in the Y for a one unit...

    Started by noetsi‎, 03-18-2016 01:22 PM
    • Replies: 7
    • Views: 620
    03-29-2016, 11:38 AM Go to last post
  19. Estimate OR on predictor levels

    Hi. I work with a prediction model using logistic regression in the following model setup: case_control = a b1 b2 b3 c Each variable a,b*,c...

    Started by imikeclassic‎, 03-18-2016 12:37 PM
    • Replies: 2
    • Views: 648
    03-20-2016, 03:46 AM Go to last post
  20. extracting values from text

    Hi all: I'm working with a single variable that is free text. I've done a lot of processing on the data with scan and compress and I'm at the...

    Started by jamesmartinn‎, 08-04-2015 10:35 AM
    • Replies: 2
    • Views: 690
    03-14-2016, 12:00 PM Go to last post
  21. Help with SQL join

    Hello, I have some three tables laid out in the following fashion: Table 1 Obs MonthYear Y X1 1 1/2004 2 3 2 1/2004 5 9 3 2/2004 ...

    Started by agp‎, 02-25-2016 02:28 PM
    • Replies: 3
    • Views: 350
    03-14-2016, 11:34 AM Go to last post
  22. White's test for linear regression

    I think the following performs White's test for heteroskedacity and generates WHITE robust SE, but I am not sure. ODS graphics on; PROC REG...

    Started by noetsi‎, 01-25-2016 01:18 PM
    • Replies: 5
    • Views: 505
    03-11-2016, 02:15 PM Go to last post
  23. simple SAS EG question: how to update data from "work" folder

    I'm have access to SAS EG, but I still want to learn SAS coding syntax. I'm following along a SAS book using SAS EG and am having trouble to just...

    Started by semidevil‎, 03-10-2016 10:42 AM
    • Replies: 1
    • Views: 219
    03-11-2016, 11:48 AM Go to last post
  24. first. and Last. logic statement

    hi, I have two lines of data, ID Order A 17/01/2016 B 01/02/2014 Basically I want to run a logic like so; data...

    Started by ahart‎, 03-10-2016 05:59 AM
    • Replies: 0
    • Views: 166
    03-10-2016, 05:59 AM Go to last post
  25. benefit of Proc SQL vs SQL vs learning SAS syntax

    I'm just starting to learn SAS and I'm wanting to know which direction I should take in my learning. I work in a financial industry and our...

    Started by semidevil‎, 03-09-2016 01:08 PM
    • Replies: 4
    • Views: 215
    03-09-2016, 04:23 PM Go to last post
  26. regression with proc surveyreg using clustered standard errors and fixed effects

    How can I implement clustered standard errors and fixed effects for proc surveyreg? E.g., I want to have fixed effects for three variables: fe1, fe2,...

    Started by TrueTears‎, 03-01-2016 05:16 AM
    • Replies: 1
    • Views: 399
    03-01-2016, 07:58 AM Go to last post
  27. Help with datepart

    Hi, Please help me with this.. I have a column in my data TYPE: Number FORMAT: datetime20. Im using using proc sql and need to remove the...

    Started by itshere‎, 02-02-2016 01:11 PM
    • Replies: 2
    • Views: 726
    02-28-2016, 12:29 AM Go to last post
  28. How to create new column in a df based on multiple conditions?

    hi I have two columns and would like to create a third. The logic that I am trying to create is; Column A represents a unique customer record. ...

    Started by ahart‎, 02-24-2016 05:14 AM
    • Replies: 2
    • Views: 312
    02-24-2016, 09:07 AM Go to last post
  29. Issue defining ordinal variables in SAS

    Hello All, I am developing a Logistic Regression model in SAS and I have one of the independent variables as Age. I do not have exact age but I...

    Started by rags140684‎, 02-12-2016 09:59 PM
    ordinal variable, sas
    • Replies: 11
    • Views: 795
    02-18-2016, 02:35 PM Go to last post
  30. Simple effects for interaction term: Proc Reg

    By simple effects I mean analyzing the impact of a main effect at some specific level of the other variables in the model. I use it, in other...

    Started by noetsi‎, 01-28-2016 03:28 PM
    • Replies: 11
    • Views: 675
    02-01-2016, 08:19 AM Go to last post
  31. Problem with Java

    I have never experienced this problem before and I have used this system for 6 years. Anyone know how to fix this? Error: Unable to load the Java...

    Started by noetsi‎, 01-26-2016 01:15 PM
    • Replies: 9
    • Views: 488
    01-26-2016, 03:40 PM Go to last post
  32. Using %cutpoint macro in SAS

    Hello, I am trying to find out optimal cut-points for my continuous variable of smoking using an outcome based method. I came across a SAS macro...

    Started by Akhil‎, 01-19-2016 05:49 AM
    2 Pages
    1 2
    • Replies: 21
    • Views: 960
    01-21-2016, 12:14 PM Go to last post
  33. Creating Graphs from Survival Analysis Outcome

    If I run a survival analysis, how can I graph the output/outcome? I.e. if I run age group and incidence of a certain disease ('cancer'), and get a...

    Started by kgilpin‎, 01-13-2016 04:44 PM
    graphing, research, sas, survival analysis
    • Replies: 4
    • Views: 688
    01-14-2016, 09:56 AM Go to last post
  34. ANCOVA help -Parameter Estimate Zero

    Hi everyone, I just ran ANCOVA. One of my covariates in the final model gives be a parameter estimate as : Parameter Estimate Standard Error ...

    Started by sas13‎, 01-11-2016 06:43 PM
    • Replies: 2
    • Views: 378
    01-11-2016, 07:09 PM Go to last post
  35. Trend analysis with non-binary variable

    Hi, I have a data set where I have a number of organs that fall into 5 treatment groups. These treatment groups can be organized based on increasing...

    Started by zihuatanejo‎, 01-07-2016 03:54 PM
    trend analysis
    • Replies: 3
    • Views: 490
    01-08-2016, 11:31 AM Go to last post
  36. ANOVA 2-way all subgroup combinations

    Hello - I am wanting to do 2-way ANOVA tests in SAS. I am having trouble getting results against all the subgroups I want to. It is best explained...

    Started by Silvertreetops‎, 01-04-2016 03:54 AM
    anova, proc gls
    • Replies: 3
    • Views: 501
    01-05-2016, 08:21 AM Go to last post
  37. Question How to edit this forest plot code to accommodate a non-log scale?

    I want to create a version of the forest plot here: http://support.sas.com/kb/42/867.html Unfortunately, the scale isn't useful for the values I...

    Started by j4ne‎, 11-30-2015 06:13 AM
    • Replies: 3
    • Views: 1,765
    12-02-2015, 01:06 PM Go to last post
  38. Help - Logistc regression in SAS Enterprise

    Dear all, i would like to ask your help because i need to be able to reproduce in SAS enterprise the same results as these ones from the book "An...

    Started by davidmoreira‎, 11-25-2015 08:55 AM
    • Replies: 7
    • Views: 750
    11-25-2015, 09:45 AM Go to last post
  39. Help with Summary calculations

    hi, I am working from the file attached. I would like to create a summary by last_touch_channel for all customers who purchased more than once...

    Started by ahart‎, 11-24-2015 10:08 AM
    • Replies: 1
    • Views: 469
    11-24-2015, 12:17 PM Go to last post
  40. HP Linear Regression

    This is apparently different software rather than a different method. Has anyone worked with it.

    Started by noetsi‎, 11-13-2015 10:50 AM
    • Replies: 5
    • Views: 737
    11-13-2015, 08:21 PM Go to last post
  41. Proc SQL

    I can't believe this never came up before... Can you compare two variables (columns) in a Where cause? This is common in SQL, but I can't find how...

    Started by noetsi‎, 11-05-2015 02:37 PM
    • Replies: 10
    • Views: 907
    11-10-2015, 10:57 AM Go to last post
  42. changing the reference variable value in class statement

    Hi, I am trying to run an analysis with the variable "histgr" (for histology group) and the values for histgr are 1, 2, 3, 4 and 5. How can I change...

    Started by kungfupanda‎, 11-05-2015 08:31 PM
    class, reference variable, sas
    • Replies: 1
    • Views: 382
    11-05-2015, 09:04 PM Go to last post
  43. Angry How to get scientific notation display in PROC TABULATE?

    Hi! I have a dataset that includes a few p-values that are very small (eg 2.5E-17). When I build a table using PROC TABULATE the values are only...

    Started by RuthB‎, 11-05-2015 09:24 AM
    • Replies: 1
    • Views: 338
    11-05-2015, 02:36 PM Go to last post
  44. Replacing or remove data

    Hi guys, I need your help. I have a quite large database. It contains names of companies (observations) a its financial ratios. As you know, database...

    Started by russel2000‎, 11-02-2015 09:44 AM
    • Replies: 1
    • Views: 444
    11-03-2015, 06:53 AM Go to last post
  45. SAS Tips and Tricks

    I publish a free e-magazine for programming tips in SAS, R, SQL, etc. I would like to both invite everyone to take a look, as there are some good...

    Started by cjohnson‎, 11-02-2015 12:54 PM
    • Replies: 0
    • Views: 440
    11-02-2015, 12:54 PM Go to last post
  46. SAS 9.4: PROC IMPORT for .xlsx (what happened to F1, F2, F3, ...?)

    I am not liking SAS 9.4, wish I could stay with 9.2. Anyone have a workaround for these problems? Background on my .xlsx: column headings start...

    Started by Mean Joe‎, 03-16-2015 05:40 PM
    • Replies: 8
    • Views: 2,202
    10-29-2015, 04:39 PM Go to last post
  47. How to create a table of values

    hi I am looking at summarizing the attached data set (book1) in SAS from my original proc sql statement. I want to adapt this with a summary of...

    Started by ahart‎, 10-15-2015 04:29 AM
    • Replies: 0
    • Views: 523
    10-15-2015, 04:29 AM Go to last post
  48. Input NHAMCS data, 2003-2009

    Hello all, I am wondering if anyone knows how to input NHAMCS data into SAS. For a project, I am to reproduce Table 1 from the following article:...

    Started by alexhua1873‎, 10-12-2015 10:08 PM
    • Replies: 0
    • Views: 513
    10-12-2015, 10:08 PM Go to last post
  49. Merging files where errors exist in Log file

    hi, I am executing a specific set of actions as follows from the attached desktop zip files ; - read in the file Adobe may 1) I am looking...

    Started by ahart‎, 10-12-2015 09:14 AM
    • Replies: 0
    • Views: 461
    10-12-2015, 09:14 AM Go to last post
  50. Reading in a csv file into SAS

    hi guys I am trying to read in the attached csv file (in the zip folder attached) I started with data Adobe may; infile...

    Started by ahart‎, 10-12-2015 04:13 AM
    • Replies: 2
    • Views: 590
    10-12-2015, 08:58 AM Go to last post
  51. Different degree of freedom and P-value from SAS proc mixed and SPSS mixed

    Hello, I am doing a repeated measure analysis using mixed model. However, SAS (9.4) and SPSS (23.0) have some difference: 1. They have different...

    Started by fengyuwuzu‎, 10-02-2015 01:36 PM
    • Replies: 2
    • Views: 736
    10-02-2015, 05:15 PM Go to last post
  52. need code help

    background. a process is designed as below to automate the data quality checks for a certain dataset on a number of rules using SAS macros. the...

    Started by arien‎, 09-28-2015 01:04 AM
    • Replies: 0
    • Views: 682
    09-28-2015, 01:04 AM Go to last post
  53. SAS code help

    data prb; title'Prb 2'; input vartype $1-11 stat1 12-16 stat2 18-23; datalines; numeric 25.5 12.7 character 36 34.4 numeric 150 ...

    Started by isumo‎, 09-22-2015 09:29 PM
    • Replies: 1
    • Views: 799
    09-23-2015, 07:54 AM Go to last post
  54. Exclamation subsetting data with criteria involving multiple variables/combinations of variables

    Hi, I am trying to create a subset of data of “high intermediate risk” group of entries as defined by a criteria based on age and number of risk...

    Started by kungfupanda‎, 09-05-2015 03:00 PM
    dataset, subsetting, variables
    • Replies: 10
    • Views: 1,592
    09-14-2015, 12:48 AM Go to last post
  55. Unhappy Post-hoc Tukey with Mixed rANOVA in SAS

    Hi all, I am working on the analyses for my dissertation. My study uses a split-block design, and I have performed a Mixed rANOVA (one between...

    Started by konglaoshi‎, 09-08-2015 07:17 PM
    • Replies: 3
    • Views: 713
    09-10-2015, 03:37 AM Go to last post
  56. Proc MI fully conditional specification

    Hi everybody, I'm using multiple imputation with the fully conditional specification (fcs) method in SAS (proc mi, fcs statement) to replace...

    Started by PhMortier‎, 09-05-2015 10:44 AM
    fcs, mle may not exist, multiple imputation, pro mi
    • Replies: 1
    • Views: 600
    09-05-2015, 11:17 AM Go to last post
  57. Exclamation 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...

    Started by kungfupanda‎, 09-01-2015 03:25 PM
    character, delete variables, sas, variable
    • Replies: 4
    • Views: 676
    09-05-2015, 12:29 AM Go to last post
  58. Exclamation how to select for multiple codes for a given variable?

    Hi, One of my variables, "histology" has about 200 unique codes. I want to create a dataset looking at just 10 of them that are "carcinomas", but...

    Started by kungfupanda‎, 09-05-2015 12:22 AM
    indicator variable
    • Replies: 0
    • Views: 326
    09-05-2015, 12:22 AM Go to last post
  59. fractional spline regression model

    hi all i am trying to fit a fractional spline model with degree 3.5 or 2.1 in sas but i am unable to do it can anybody help me with the code? i...

    Started by saira esar‎, 08-26-2015 12:45 AM
    • Replies: 0
    • Views: 597
    08-26-2015, 12:45 AM Go to last post
  60. Plz help in understanding what below lines of code do in SAS in perl script.

    print QUERY "libname datasets '/home/viii';\n"; print QUERY "\n"; print QUERY "\%gdefault;\n"; print QUERY...

    Started by prasannaJ‎, 08-18-2015 09:39 AM
    • Replies: 0
    • Views: 636
    08-18-2015, 09:39 AM Go to last post

+ Post New Thread
Page 1 of 21 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 ... LastLast

Thread Display Options

Use this control to limit the display of threads to those newer than the specified time frame.

Allows you to choose the data by which the thread list will be sorted.

Order threads in...

Note: when sorting by date, 'descending order' will show the newest results first.

Icon Legend

Contains unread posts
Contains unread posts
Contains no unread posts
Contains no unread posts
More than 15 replies or 300 views
Hot thread with unread posts
More than 15 replies or 300 views
Hot thread with no unread posts
Closed Thread
Thread is closed
Thread Contains a Message Written By You
You have posted in this thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Advertise on Talk Stats