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 1247

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,521
    06-26-2015, 10:17 AM Go to last post
  1. 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: 2
    • Views: 232
    Today, 02:03 AM Go to last post
  2. How to convert scientific number to its original form (In Proc SQL)

    I have a column in my table called policykey, where data is supposed to be something along the lines of 20000000000000012. Unfortunately, the...

    Started by semidevil‎, 06-23-2016 11:43 AM
    • Replies: 2
    • Views: 135
    06-23-2016, 08:19 PM Go to last post
  3. Pseudo-IV GLS for time series

    Some call this two stage Aitkin. Its recommended to run dynamic regression when you have serial correlation and a lagged Y as a predictor. I have not...

    Started by noetsi‎, 06-21-2016 02:12 PM
    • Replies: 2
    • Views: 155
    06-23-2016, 11:39 AM Go to last post
  4. Supressing tables

    When running the following code I generate a huge number of tables I do not want. All I want is the graphs and regression output. NOPRINT suppresses...

    Started by noetsi‎, 06-10-2016 10:48 AM
    • Replies: 3
    • Views: 262
    06-21-2016, 02:09 PM Go to last post
  5. Is retrieving data using datastep really slow?

    I'm trying to get use to coding in SAS and it's syntax, because If I want to do more statistical analysis and data basic manipulation, I can do it...

    Started by semidevil‎, 06-17-2016 04:24 PM
    • Replies: 4
    • Views: 282
    06-20-2016, 09:50 AM 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: 2
    • Views: 581
    06-16-2016, 09:06 PM Go to last post
  7. Regression diagmostics: PROC REG versus PROC GLM

    PROC GLM has many advantages over proc reg such as a case statement. But SAS has chosen not to include many of the diagnostics in proc glm that are...

    Started by noetsi‎, 06-09-2016 10:18 AM
    • Replies: 5
    • Views: 237
    06-16-2016, 02:07 PM Go to last post
  8. Out of sample validation

    When you hold out a portion of the data to test your regression model. I have data I can hold out. But I am not sure practically how you would test...

    Started by noetsi‎, 06-11-2016 01:47 PM
    • Replies: 12
    • Views: 376
    06-16-2016, 01:38 PM Go to last post
  9. Polychoric/tetronic correlations

    If you wanted these you used to have to run a painful macro. Now they apparently are part of the regular sas. ...

    Started by noetsi‎, 06-10-2016 10:36 AM
    • Replies: 0
    • Views: 92
    06-10-2016, 10:36 AM Go to last post
  10. "Proce ARIMA not found"

    I did a simple: PROC ARIMA DATA=WORK.TMP4TempTableNewTimeID ; IDENTIFY VAR=sales NLAG=12 ; run; but I got the error 'PROC ARIMA...

    Started by semidevil‎, 06-03-2016 04:23 PM
    • Replies: 3
    • Views: 286
    06-04-2016, 01:46 PM Go to last post
  11. 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: 5
    • Views: 314
    05-31-2016, 09:38 AM Go to last post
  12. 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: 200
    05-27-2016, 07:52 AM Go to last post
  13. 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: 192
    05-24-2016, 10:13 AM Go to last post
  14. [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: 155
    05-21-2016, 01:40 PM Go to last post
  15. 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: 137
    05-16-2016, 02:01 AM Go to last post
  16. 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: 157
    05-12-2016, 04:57 PM Go to last post
  17. 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: 162
    05-11-2016, 08:39 PM Go to last post
  18. 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: 219
    05-10-2016, 10:12 AM Go to last post
  19. 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: 576
    05-09-2016, 02:11 PM Go to last post
  20. [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: 148
    05-09-2016, 11:02 AM Go to last post
  21. 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
  22. 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: 199
    04-28-2016, 12:38 PM Go to last post
  23. 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: 329
    04-19-2016, 05:08 PM Go to last post
  24. 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: 210
    04-19-2016, 01:04 PM Go to last post
  25. 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: 406
    04-07-2016, 10:24 PM Go to last post
  26. 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: 662
    03-29-2016, 11:38 AM Go to last post
  27. 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: 781
    03-20-2016, 03:46 AM Go to last post
  28. 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: 729
    03-14-2016, 12:00 PM Go to last post
  29. 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: 390
    03-14-2016, 11:34 AM Go to last post
  30. 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: 3
    • Views: 510
    03-14-2016, 11:33 AM Go to last post
  31. 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: 554
    03-11-2016, 02:15 PM Go to last post
  32. 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: 240
    03-11-2016, 11:48 AM Go to last post
  33. 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: 200
    03-10-2016, 05:59 AM Go to last post
  34. 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: 251
    03-09-2016, 04:23 PM Go to last post
  35. 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: 445
    03-01-2016, 07:58 AM Go to last post
  36. 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: 769
    02-28-2016, 12:29 AM Go to last post
  37. 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: 335
    02-24-2016, 09:07 AM Go to last post
  38. 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: 872
    02-18-2016, 02:35 PM Go to last post
  39. 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: 733
    02-01-2016, 08:19 AM Go to last post
  40. 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: 542
    01-26-2016, 03:40 PM Go to last post
  41. 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: 1,034
    01-21-2016, 12:14 PM Go to last post
  42. 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: 724
    01-14-2016, 09:56 AM Go to last post
  43. 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: 422
    01-11-2016, 07:09 PM Go to last post
  44. 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: 524
    01-08-2016, 11:31 AM Go to last post
  45. 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: 541
    01-05-2016, 08:21 AM Go to last post
  46. 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,789
    12-02-2015, 01:06 PM Go to last post
  47. 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: 793
    11-25-2015, 09:45 AM Go to last post
  48. 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: 783
    11-13-2015, 08:21 PM Go to last post
  49. 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: 944
    11-10-2015, 10:57 AM Go to last post
  50. 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: 413
    11-05-2015, 09:04 PM Go to last post
  51. 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: 372
    11-05-2015, 02:36 PM Go to last post
  52. 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: 476
    11-03-2015, 06:53 AM Go to last post
  53. 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: 464
    11-02-2015, 12:54 PM Go to last post
  54. 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,400
    10-29-2015, 04:39 PM Go to last post
  55. 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: 555
    10-15-2015, 04:29 AM Go to last post
  56. 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: 544
    10-12-2015, 10:08 PM Go to last post
  57. 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: 486
    10-12-2015, 09:14 AM Go to last post
  58. 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: 652
    10-12-2015, 08:58 AM Go to last post
  59. 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: 767
    10-02-2015, 05:15 PM Go to last post
  60. 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: 718
    09-28-2015, 01:04 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