1. 10-14-2010
+ Post New Thread
Page 1 of 22 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 1269

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-18-2012 12:34 AM
    2 Pages
    1 2
    • Replies: 22
    • Views: 12,513
    06-26-2015, 11:17 AM Go to last post
  1. 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 02:47 PM
    • Replies: 13
    • Views: 809
    11-30-2016, 11:43 AM Go to last post
  2. Troubleshooting boxplot with continuous group variable

    I am trying to create a boxplot in SAS 9.3 with a continuous group variable, but no more than the first three groups will appear on the plot. I...

    Started by RuthB‎, 11-28-2016 04:57 PM
    • Replies: 1
    • Views: 144
    11-29-2016, 10:18 AM Go to last post
  3. Random Sampling

    I have a dataset of 1000 with the following variables: subjno, hospnm, and bthwt. I need to complete the object below. Objective: Convert the...

    Started by Gpepsicola‎, 11-23-2016 04:26 PM
    • Replies: 1
    • Views: 171
    11-23-2016, 07:43 PM Go to last post
  4. How to control variables in logistic regression.

    Hello! I have a DV with two outcomes. Several IVs (categorical and continuous). I want to predict the DV using the IVs, but I also have control...

    Started by KRS‎, 11-19-2016 08:30 PM
    control variable, logistical regression, sas
    • Replies: 3
    • Views: 220
    11-20-2016, 07:13 AM Go to last post
  5. array, do until, target variable

    Hi all: I have the following dataset: ID A B C D Total Target 1 14 . 0 0 15 0 2 10 8 6 . 25 6 ...

    Started by jamesmartinn‎, 11-16-2016 01:25 PM
    • Replies: 1
    • Views: 279
    11-16-2016, 01:46 PM Go to last post
  6. Reproducing Output from Out dataset

    Hi all: I've taken a quick look and I'm wondering if this is possible within Proc Tabulate (or any other procs for that matter): I want to run...

    Started by jamesmartinn‎, 11-07-2016 01:10 PM
    • Replies: 2
    • Views: 324
    11-16-2016, 09:26 AM Go to last post
  7. Negative binomial model's SAS syntax.

    Hi, I am trying to run the negative binomial model for the following model. ln(di) = ln(ni) + β00 + β10 yeari + ei, i = 1979, , 1996 where,...

    Started by sandyzman‎, 10-14-2016 04:31 PM
    • Replies: 0
    • Views: 636
    10-14-2016, 04:31 PM Go to last post
  8. SAS input to be used for chi squared goodness of fit

    i have a data set I need to enter into SAS so I can perform a chi squared goodness-of-fit. The categories being used are <=12.9, >12.9 and <=13.9,...

    Started by kdsan‎, 10-14-2016 10:27 AM
    • Replies: 0
    • Views: 250
    10-14-2016, 10:27 AM Go to last post
  9. Calculating trend in death-rate by using Negative binomial regression model.

    Hi All, I am very new to SAS. My question might sound silly but I m trying to put in the best possible way. I am re-creating a table (attached...

    Started by sandyzman‎, 10-10-2016 01:44 PM
    • Replies: 3
    • Views: 264
    10-12-2016, 08:56 AM Go to last post
  10. Do Loop with IF in Macro

    Hi, I've been struggling with a do loop in SAS and would be grateful for any assistance. This is the data I have: data have; input...

    Started by Mike5‎, 12-16-2014 11:49 AM
    %do, %if, loop, macro
    • Replies: 4
    • Views: 939
    10-11-2016, 04:08 PM Go to last post
  11. Visualization issues in SAS

    I'm having two specific issues with proc gchart in SAS (code and graph attached): 1) I cannot seem to fill my error bars. I know it is possible,...

    Started by jbwettergreen‎, 10-06-2016 03:01 AM
    • Replies: 3
    • Views: 290
    10-07-2016, 09:21 AM Go to last post
  12. Interpreting odds ratios in PROC LOGISTIC


    Started by noetsi‎, 10-03-2016 12:44 PM
    • Replies: 1
    • Views: 294
    10-03-2016, 03:01 PM Go to last post
  13. Which test should I use to find the rose among the thorns in SAS studio?

    I have 200 patients who have prescriptions from a pool of 20 drugs, and 100 normal control volunteers who do not take any of the drugs in the pool of...

    Started by Konradc‎, 09-16-2016 09:46 AM
    clinical trial, higher order analyses, sas studio, uneven group sizes
    • Replies: 1
    • Views: 535
    09-16-2016, 07:22 PM Go to last post
  14. Relationship between quantitative variables in PROC MIXED

    I feel like this is a problem it should not be possible to have, but I'm running analyses using MIXED where the dependent variable and some of the...

    Started by Crantsy‎, 09-01-2016 01:42 PM
    mixed model
    • Replies: 1
    • Views: 484
    09-06-2016, 11:04 AM Go to last post
  15. 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 08:26 AM
    • Replies: 2
    • Views: 431
    08-26-2016, 09:37 AM Go to last post
  16. 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 11:09 AM
    proc report
    • Replies: 1
    • Views: 247
    08-24-2016, 11:39 AM Go to last post
  17. 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 02:40 PM
    • Replies: 1
    • Views: 379
    08-15-2016, 05:13 PM Go to last post
  18. 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 05:35 PM
    • Replies: 0
    • Views: 292
    08-12-2016, 05:35 PM Go to last post
  19. 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 05:45 PM
    • Replies: 0
    • Views: 358
    08-04-2016, 05:45 PM Go to last post
  20. 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 07:32 AM
    • Replies: 7
    • Views: 668
    08-02-2016, 03:43 AM Go to last post
  21. 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 01:04 PM
    • Replies: 1
    • Views: 456
    07-25-2016, 12:59 PM Go to last post
  22. 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 04:22 PM
    • Replies: 1
    • Views: 716
    07-05-2016, 10:44 AM Go to last post
  23. 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 10:51 AM
    • Replies: 1
    • Views: 345
    07-01-2016, 10:58 AM Go to last post
  24. 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 08:26 AM
    • Replies: 0
    • Views: 284
    06-27-2016, 08:26 AM Go to last post
  25. 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 05:19 AM
    • Replies: 2
    • Views: 489
    06-25-2016, 03:03 AM Go to last post
  26. 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 12:43 PM
    • Replies: 2
    • Views: 354
    06-23-2016, 09:19 PM Go to last post
  27. 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 03:12 PM
    • Replies: 2
    • Views: 365
    06-23-2016, 12:39 PM Go to last post
  28. 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 11:48 AM
    • Replies: 3
    • Views: 488
    06-21-2016, 03:09 PM Go to last post
  29. 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 05:24 PM
    • Replies: 4
    • Views: 522
    06-20-2016, 10:50 AM Go to last post
  30. 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 05:18 PM
    • Replies: 2
    • Views: 754
    06-16-2016, 10:06 PM Go to last post
  31. 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 11:18 AM
    • Replies: 5
    • Views: 464
    06-16-2016, 03:07 PM Go to last post
  32. 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 11:36 AM
    • Replies: 0
    • Views: 221
    06-10-2016, 11:36 AM Go to last post
  33. "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 05:23 PM
    • Replies: 3
    • Views: 540
    06-04-2016, 02:46 PM Go to last post
  34. 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 01:33 PM
    • Replies: 5
    • Views: 501
    05-31-2016, 10:38 AM Go to last post
  35. 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 06:51 PM
    fixed effect, interpretation, mixed, multiple comparisons, sas
    • Replies: 1
    • Views: 379
    05-27-2016, 08:52 AM Go to last post
  36. 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 04:16 PM
    • Replies: 2
    • Views: 424
    05-24-2016, 11:13 AM Go to last post
  37. [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 02:12 PM
    • Replies: 1
    • Views: 285
    05-21-2016, 02:40 PM Go to last post
  38. 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 03:01 AM
    insert text
    • Replies: 0
    • Views: 259
    05-16-2016, 03:01 AM Go to last post
  39. 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 05:57 PM
    • Replies: 0
    • Views: 274
    05-12-2016, 05:57 PM Go to last post
  40. 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 11:14 AM
    • Replies: 1
    • Views: 315
    05-11-2016, 09:39 PM Go to last post
  41. 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 11:34 AM
    • Replies: 3
    • Views: 347
    05-10-2016, 11:12 AM Go to last post
  42. 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 06:32 PM
    • Replies: 5
    • Views: 1,482
    05-09-2016, 03:11 PM Go to last post
  43. [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 11:51 AM
    • Replies: 1
    • Views: 274
    05-09-2016, 12:02 PM Go to last post
  44. 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 04:37 PM
    • Replies: -
    • Views: -
    05-06-2016, 04:41 PM Go to last post
  45. 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 01:38 PM
    em algorithm, gaussian mixture model, sas 9.3
    • Replies: 0
    • Views: 312
    04-28-2016, 01:38 PM Go to last post
  46. 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 06:08 PM
    sequence, time, visits
    • Replies: 0
    • Views: 467
    04-19-2016, 06:08 PM Go to last post
  47. 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 02:01 PM
    • Replies: 2
    • Views: 430
    04-19-2016, 02:04 PM Go to last post
  48. 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 11:24 PM
    • Replies: 0
    • Views: 551
    04-07-2016, 11:24 PM Go to last post
  49. 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 02:22 PM
    • Replies: 7
    • Views: 932
    03-29-2016, 12:38 PM Go to last post
  50. 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 01:37 PM
    • Replies: 2
    • Views: 1,433
    03-20-2016, 04:46 AM Go to last post
  51. 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 11:35 AM
    • Replies: 2
    • Views: 928
    03-14-2016, 01:00 PM Go to last post
  52. 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 03:28 PM
    • Replies: 3
    • Views: 622
    03-14-2016, 12:34 PM Go to last post
  53. 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 11:08 AM
    • Replies: 3
    • Views: 714
    03-14-2016, 12:33 PM Go to last post
  54. 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 02:18 PM
    • Replies: 5
    • Views: 770
    03-11-2016, 03:15 PM Go to last post
  55. 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 11:42 AM
    • Replies: 1
    • Views: 380
    03-11-2016, 12:48 PM Go to last post
  56. 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 06:59 AM
    • Replies: 0
    • Views: 346
    03-10-2016, 06:59 AM Go to last post
  57. 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 02:08 PM
    • Replies: 4
    • Views: 436
    03-09-2016, 05:23 PM Go to last post
  58. 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 06:16 AM
    • Replies: 1
    • Views: 684
    03-01-2016, 08:58 AM Go to last post
  59. 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 02:11 PM
    • Replies: 2
    • Views: 976
    02-28-2016, 01:29 AM Go to last post
  60. 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 06:14 AM
    • Replies: 2
    • Views: 472
    02-24-2016, 10:07 AM Go to last post

+ Post New Thread
Page 1 of 22 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