1. Announcement:
    Want access to a chatbox?
    Dason ‎(Devorador de queso)
+ Post New Thread
Page 2 of 22 FirstFirst 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 ... LastLast
Threads 61 to 120 of 1298

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: 28,840
    06-26-2015, 10:17 AM Go to last post
  1. 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: 3,060
    06-10-2016, 10:36 AM Go to last post
  2. "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: 4,025
    06-04-2016, 01:46 PM Go to last post
  3. 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: 4,380
    05-31-2016, 09:38 AM Go to last post
  4. 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: 3,411
    05-27-2016, 07:52 AM Go to last post
  5. 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: 3,615
    05-24-2016, 10:13 AM Go to last post
  6. [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: 3,112
    05-21-2016, 01:40 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: 2,823
    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: 2,923
    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: 3,094
    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: 3,274
    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: 5,072
    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: 2,130
    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: 2,549
    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: 2,903
    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: 3,288
    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: 3,016
    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: 3,960
    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: 3,759
    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: 3,766
    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 03:28 PM
    • Replies: 3
    • Views: 3,282
    03-14-2016, 11:34 AM Go to last post
  22. 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: 3,694
    03-14-2016, 11:33 AM Go to last post
  23. 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: 4,058
    03-11-2016, 03:15 PM Go to last post
  24. 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: 3,305
    03-11-2016, 12:48 PM Go to last post
  25. 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: 2,344
    03-10-2016, 06:59 AM Go to last post
  26. 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: 2,206
    03-09-2016, 05:23 PM Go to last post
  27. 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: 2,340
    03-01-2016, 08:58 AM Go to last post
  28. 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: 1,775
    02-28-2016, 01:29 AM Go to last post
  29. 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: 1,456
    02-24-2016, 10:07 AM Go to last post
  30. 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 10:59 PM
    ordinal variable, sas
    • Replies: 11
    • Views: 3,601
    02-18-2016, 03:35 PM Go to last post
  31. 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 04:28 PM
    • Replies: 11
    • Views: 3,196
    02-01-2016, 09:19 AM Go to last post
  32. 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 02:15 PM
    • Replies: 9
    • Views: 2,450
    01-26-2016, 04:40 PM Go to last post
  33. 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 06:49 AM
    2 Pages
    1 2
    • Replies: 21
    • Views: 8,844
    01-21-2016, 01:14 PM Go to last post
  34. 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 05:44 PM
    graphing, research, sas, survival analysis
    • Replies: 4
    • Views: 2,665
    01-14-2016, 10:56 AM Go to last post
  35. 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 07:43 PM
    • Replies: 2
    • Views: 1,628
    01-11-2016, 08:09 PM Go to last post
  36. 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 04:54 PM
    trend analysis
    • Replies: 3
    • Views: 1,780
    01-08-2016, 12:31 PM Go to last post
  37. 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 04:54 AM
    anova, proc gls
    • Replies: 3
    • Views: 3,163
    01-05-2016, 09:21 AM Go to last post
  38. 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 07:13 AM
    • Replies: 3
    • Views: 3,668
    12-02-2015, 02:06 PM Go to last post
  39. 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 09:55 AM
    • Replies: 7
    • Views: 1,818
    11-25-2015, 10:45 AM 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 11:50 AM
    • Replies: 5
    • Views: 2,549
    11-13-2015, 09: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 03:37 PM
    • Replies: 10
    • Views: 2,184
    11-10-2015, 11: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 09:31 PM
    class, reference variable, sas
    • Replies: 1
    • Views: 1,659
    11-05-2015, 10: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 10:24 AM
    • Replies: 1
    • Views: 2,893
    11-05-2015, 03: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 10:44 AM
    • Replies: 1
    • Views: 2,396
    11-03-2015, 07: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 01:54 PM
    • Replies: 0
    • Views: 2,221
    11-02-2015, 01: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: 15,888
    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: 2,227
    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: 1,211
    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: 1,371
    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: 3,342
    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: 1,949
    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: 1,453
    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: 2,222
    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: 2,934
    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: 2,650
    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: 2,155
    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: 1,980
    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: 1,152
    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: 1,333
    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: 1,393
    08-18-2015, 09:39 AM Go to last post

+ Post New Thread
Page 2 of 22 FirstFirst 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 ... 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