1. 10-14-2010
    Views:
    27,451
+ 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 1252

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,866
    06-26-2015, 10:17 AM Go to last post
  1. help with basic graphs in SAS

    I've been searching for a few hours but still can't figure out how to create a basic bar chart in SAS. For example, my data looks has 3 columns:...

    Started by semidevil‎, 07-22-2016 12:04 PM
    • Replies: 0
    • Views: 61
    07-22-2016, 12:04 PM Go to last post
  2. how to create variables in Proc SQL

    How do you create variables in proc sql? For example, in SQL server, I can start my code with: " DECLARE @SD AS INT, @ED AS INT, @LD as int...

    Started by semidevil‎, 07-01-2016 03:22 PM
    • Replies: 1
    • Views: 458
    07-05-2016, 09:44 AM Go to last post
  3. creating social security format

    This should be simple but I have had no luck finding it. I want to convert a character field with ********* to ***-XX-***X. I know I could use...

    Started by noetsi‎, 07-01-2016 09:51 AM
    • Replies: 1
    • Views: 226
    07-01-2016, 09:58 AM Go to last post
  4. Compare curves in SAS JMP

    Hi Everyone, I am trying to compare a set of curves against a set of references. The curves are determined using fixed x-points. What would be...

    Started by La82‎, 06-28-2016 06:32 AM
    • Replies: 6
    • Views: 332
    06-29-2016, 12:34 AM Go to last post
  5. Nested design

    Hi Everyone, I am completely new to SAS jmp so bare with me :) I am trying to compare a test with three replicates to a reference with 9...

    Started by La82‎, 06-27-2016 07:26 AM
    • Replies: 0
    • Views: 158
    06-27-2016, 07:26 AM Go to last post
  6. 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: 346
    06-25-2016, 02:03 AM Go to last post
  7. 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: 224
    06-23-2016, 08:19 PM Go to last post
  8. 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: 222
    06-23-2016, 11:39 AM Go to last post
  9. 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: 328
    06-21-2016, 02:09 PM Go to last post
  10. 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: 345
    06-20-2016, 09:50 AM Go to last post
  11. 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: 617
    06-16-2016, 09:06 PM Go to last post
  12. 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: 281
    06-16-2016, 02:07 PM Go to last post
  13. 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: 447
    06-16-2016, 01:38 PM Go to last post
  14. 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: 119
    06-10-2016, 10:36 AM Go to last post
  15. "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: 338
    06-04-2016, 01:46 PM Go to last post
  16. 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: 344
    05-31-2016, 09:38 AM Go to last post
  17. 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: 241
    05-27-2016, 07:52 AM Go to last post
  18. 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: 225
    05-24-2016, 10:13 AM Go to last post
  19. [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: 180
    05-21-2016, 01:40 PM Go to last post
  20. 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: 154
    05-16-2016, 02:01 AM Go to last post
  21. 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: 177
    05-12-2016, 04:57 PM Go to last post
  22. 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: 188
    05-11-2016, 08:39 PM Go to last post
  23. 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: 243
    05-10-2016, 10:12 AM Go to last post
  24. 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: 736
    05-09-2016, 02:11 PM Go to last post
  25. [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: 167
    05-09-2016, 11:02 AM Go to last post
  26. 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
  27. 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: 221
    04-28-2016, 12:38 PM Go to last post
  28. 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: 355
    04-19-2016, 05:08 PM Go to last post
  29. 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: 247
    04-19-2016, 01:04 PM Go to last post
  30. 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: 438
    04-07-2016, 10:24 PM Go to last post
  31. 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: 712
    03-29-2016, 11:38 AM Go to last post
  32. 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: 945
    03-20-2016, 03:46 AM Go to last post
  33. 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: 779
    03-14-2016, 12:00 PM Go to last post
  34. 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: 422
    03-14-2016, 11:34 AM Go to last post
  35. 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: 561
    03-14-2016, 11:33 AM Go to last post
  36. 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: 599
    03-11-2016, 02:15 PM Go to last post
  37. 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: 267
    03-11-2016, 11:48 AM Go to last post
  38. 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: 219
    03-10-2016, 05:59 AM Go to last post
  39. 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: 281
    03-09-2016, 04:23 PM Go to last post
  40. 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: 484
    03-01-2016, 07:58 AM Go to last post
  41. 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: 812
    02-28-2016, 12:29 AM Go to last post
  42. 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: 360
    02-24-2016, 09:07 AM Go to last post
  43. 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: 931
    02-18-2016, 02:35 PM Go to last post
  44. 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: 789
    02-01-2016, 08:19 AM Go to last post
  45. 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: 590
    01-26-2016, 03:40 PM Go to last post
  46. 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,124
    01-21-2016, 12:14 PM Go to last post
  47. 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: 755
    01-14-2016, 09:56 AM Go to last post
  48. 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: 460
    01-11-2016, 07:09 PM Go to last post
  49. 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: 560
    01-08-2016, 11:31 AM Go to last post
  50. 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: 584
    01-05-2016, 08:21 AM Go to last post
  51. 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,830
    12-02-2015, 01:06 PM Go to last post
  52. 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: 831
    11-25-2015, 09:45 AM Go to last post
  53. 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: 824
    11-13-2015, 08:21 PM Go to last post
  54. 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: 980
    11-10-2015, 10:57 AM Go to last post
  55. 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: 438
    11-05-2015, 09:04 PM Go to last post
  56. 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: 404
    11-05-2015, 02:36 PM Go to last post
  57. 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: 505
    11-03-2015, 06:53 AM Go to last post
  58. 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: 494
    11-02-2015, 12:54 PM Go to last post
  59. 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,682
    10-29-2015, 04:39 PM Go to last post
  60. 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: 587
    10-15-2015, 04:29 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