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 1257

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: 11,356
    06-26-2015, 10:17 AM Go to last post
  1. do loop

    hi all: I want to write a small macro program that loops through sequential yearly files but I'm having an issue given the naming conventions of...

    Started by jamesmartinn‎, 08-26-2016 07:26 AM
    • Replies: 2
    • Views: 124
    08-26-2016, 08:37 AM Go to last post
  2. How to control the number of variables to display in one page using proc report

    My goal is to make a data listing which contains 10 variables. However, the space for a single page is not sufficient to display all 10 variables. I...

    Started by freezingswallow‎, 08-24-2016 10:09 AM
    proc report
    • Replies: 1
    • Views: 118
    08-24-2016, 10:39 AM Go to last post
  3. Program Header Template

    Hi all: I'm trying to create a standard program header template. I've had luck in SAS EG using a keyboard macro shortcut. When I execute my custom...

    Started by jamesmartinn‎, 08-15-2016 01:40 PM
    • Replies: 1
    • Views: 253
    08-15-2016, 04:13 PM Go to last post
  4. help with basic conversion concepts in SAS

    I have been reading around but I still do not understand on how to convert characters/numbers/dates and in their different formats. I'm confused...

    Started by semidevil‎, 08-12-2016 04:35 PM
    • Replies: 0
    • Views: 193
    08-12-2016, 04:35 PM Go to last post
  5. how to convert numeric date to day of the week.

    I'm trying to convert a 8 digit numeric value to the day of the week. I,e, convert 20160804 to 'Thursday', or 'Thu' or something similar. I still...

    Started by semidevil‎, 08-04-2016 04:45 PM
    • Replies: 0
    • Views: 238
    08-04-2016, 04:45 PM Go to last post
  6. 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: 7
    • Views: 517
    08-02-2016, 02:43 AM Go to last post
  7. 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: 1
    • Views: 344
    07-25-2016, 11:59 AM Go to last post
  8. 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: 623
    07-05-2016, 09:44 AM Go to last post
  9. 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: 263
    07-01-2016, 09:58 AM Go to last post
  10. 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: 203
    06-27-2016, 07:26 AM Go to last post
  11. 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: 398
    06-25-2016, 02:03 AM Go to last post
  12. 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: 266
    06-23-2016, 08:19 PM Go to last post
  13. 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: 266
    06-23-2016, 11:39 AM Go to last post
  14. 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: 377
    06-21-2016, 02:09 PM Go to last post
  15. 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: 400
    06-20-2016, 09:50 AM Go to last post
  16. 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: 661
    06-16-2016, 09:06 PM Go to last post
  17. 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: 334
    06-16-2016, 02:07 PM Go to last post
  18. 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: 533
    06-16-2016, 01:38 PM Go to last post
  19. 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: 152
    06-10-2016, 10:36 AM Go to last post
  20. "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: 404
    06-04-2016, 01:46 PM Go to last post
  21. 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: 392
    05-31-2016, 09:38 AM Go to last post
  22. 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: 276
    05-27-2016, 07:52 AM Go to last post
  23. 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: 296
    05-24-2016, 10:13 AM Go to last post
  24. [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: 217
    05-21-2016, 01:40 PM Go to last post
  25. 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: 186
    05-16-2016, 02:01 AM Go to last post
  26. 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: 209
    05-12-2016, 04:57 PM Go to last post
  27. 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: 227
    05-11-2016, 08:39 PM Go to last post
  28. 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: 278
    05-10-2016, 10:12 AM Go to last post
  29. 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: 966
    05-09-2016, 02:11 PM Go to last post
  30. [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: 198
    05-09-2016, 11:02 AM Go to last post
  31. 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
  32. 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: 246
    04-28-2016, 12:38 PM Go to last post
  33. 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: 391
    04-19-2016, 05:08 PM Go to last post
  34. 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: 306
    04-19-2016, 01:04 PM Go to last post
  35. 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: 470
    04-07-2016, 10:24 PM Go to last post
  36. 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: 779
    03-29-2016, 11:38 AM Go to last post
  37. 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: 1,130
    03-20-2016, 03:46 AM Go to last post
  38. 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: 835
    03-14-2016, 12:00 PM Go to last post
  39. 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: 486
    03-14-2016, 11:34 AM Go to last post
  40. 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: 614
    03-14-2016, 11:33 AM Go to last post
  41. 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: 661
    03-11-2016, 02:15 PM Go to last post
  42. 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: 302
    03-11-2016, 11:48 AM Go to last post
  43. 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: 257
    03-10-2016, 05:59 AM Go to last post
  44. 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: 324
    03-09-2016, 04:23 PM Go to last post
  45. 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: 543
    03-01-2016, 07:58 AM Go to last post
  46. 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: 874
    02-28-2016, 12:29 AM Go to last post
  47. 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: 404
    02-24-2016, 09:07 AM Go to last post
  48. 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: 1,015
    02-18-2016, 02:35 PM Go to last post
  49. 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: 868
    02-01-2016, 08:19 AM Go to last post
  50. 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: 649
    01-26-2016, 03:40 PM Go to last post
  51. 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,316
    01-21-2016, 12:14 PM Go to last post
  52. 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: 815
    01-14-2016, 09:56 AM Go to last post
  53. 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: 507
    01-11-2016, 07:09 PM Go to last post
  54. 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: 605
    01-08-2016, 11:31 AM Go to last post
  55. 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: 631
    01-05-2016, 08:21 AM Go to last post
  56. 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,906
    12-02-2015, 01:06 PM Go to last post
  57. 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: 896
    11-25-2015, 09:45 AM Go to last post
  58. 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: 914
    11-13-2015, 08:21 PM Go to last post
  59. 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: 1,035
    11-10-2015, 10:57 AM Go to last post
  60. 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: 475
    11-05-2015, 09:04 PM 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