1. 10-14-2010
    Views:
    21,510
+ Post New Thread
Page 1 of 20 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 1174

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: 6,547
    06-26-2015, 10:17 AM Go to last post
  1. Categorical (>2 groups) Missingness Dataset

    Noetsi, This is for you. Many times you have coding questions, which I think come from not actively using a dataset. I created a dataset with a...

    Started by hlsmith‎, Yesterday 10:57 AM
    • Replies: 2
    • Views: 57
    Yesterday, 11:06 AM Go to last post
  2. Saturated correlates in SAS

    This is designed to add auxiliary variables to a FIML model. It is easy to do in SEM software, but I can't find it even mentioned in SAS. Without it,...

    Started by noetsi‎, 07-28-2015 03:38 PM
    • Replies: 1
    • Views: 72
    07-28-2015, 07:23 PM Go to last post
  3. Sampling question

    Hello all - quick question on sampling - say I have a population whose X average is 100, with stddev of 50. How can I sample (using proc...

    Started by agp‎, 07-28-2015 08:01 AM
    • Replies: 9
    • Views: 143
    07-28-2015, 06:32 PM Go to last post
  4. PROC MI FCS question

    When you want to run multiple imputation variables not just one how do you do it? For example proc mi nimpute=3 data=work.c62 seed=987...

    Started by noetsi‎, 07-20-2015 01:41 PM
    2 Pages
    1 2
    • Replies: 20
    • Views: 457
    07-24-2015, 04:14 PM Go to last post
  5. reshaping data

    I am trying to reshape data in SAS in a very specific way. The data looks like: ID Q1 Q2 491 0 0 491 0 1 1040 0 1 1040 1 0 1040 2 1

    Started by sandeep249‎, 07-18-2015 06:36 PM
    arrays, sas
    • Replies: 0
    • Views: 151
    07-18-2015, 06:36 PM Go to last post
  6. SAS Code for sending mail with attachment and summary on face of the mail.

    Hi i tried to write a code in which the outcome should be : 1. A mail to be sent to the mail id's mentioned with the summary on the body of the...

    Started by santhosh‎, 07-13-2015 04:09 AM
    • Replies: 0
    • Views: 216
    07-13-2015, 04:09 AM Go to last post
  7. Logistic Reg Sample Size Recommendations

    from SAS communities https://communities.sas.com/thread/80844

    Started by noetsi‎, 07-09-2015 12:26 PM
    • Replies: 3
    • Views: 282
    07-09-2015, 06:35 PM Go to last post
  8. Sumproduct with arrays - Should be easy

    Hi, I'm relatively new to SAS. I feel like this should be an easy fix but for the life of me I can't figure out what is wrong. Basically what I'm...

    Started by ZColl‎, 06-26-2015 12:34 PM
    • Replies: 1
    • Views: 398
    06-26-2015, 12:38 PM Go to last post
  9. Proc mixed - repeated

    Dear all I have the following question concerning the fitting of a model with PROC MIXED: If in PROC MIXED we use just the repeated statement,...

    Started by sternchen‎, 06-26-2015 06:11 AM
    • Replies: 1
    • Views: 128
    06-26-2015, 09:21 AM Go to last post
  10. Proc calis

    Anyone know a good source for learning to use this (I don't find SAS documentation particularly good for the first time you use a PROC). I need to...

    Started by noetsi‎, 03-23-2015 11:24 AM
    • Replies: 3
    • Views: 322
    06-26-2015, 09:03 AM Go to last post
  11. Help

    Hi Anybody can give me some help? how to code my study? Please check the attachment Fdate refer to forecast announcement date, Adate refers to...

    Started by Ianacct‎, 06-25-2015 04:08 PM
    • Replies: 1
    • Views: 164
    06-25-2015, 04:40 PM Go to last post
  12. proc calis

    I found this from Alison to be bemusing

    Started by noetsi‎, 06-25-2015 03:25 PM
    • Replies: 0
    • Views: 115
    06-25-2015, 03:25 PM Go to last post
  13. Proc logistic - penalty/shrinkage

    Hi, I need to perform a penalty/shrinkage logistic regression (penalize/shrink the size of the regression coefficients - RIDGE/LASSO regression). ...

    Started by thomas41‎, 06-23-2015 03:55 AM
    • Replies: 2
    • Views: 218
    06-23-2015, 07:54 AM Go to last post
  14. Multiple imputation; Friedman Test, Wilcoxon Test

    Hi, I would like to run the Friedman or Wilcoxon test on data I already imputed. This is how far i got: proc mi data=WORK.MASTER_TEST_SAS...

    Started by edlarge‎, 04-22-2012 11:55 AM
    • Replies: 7
    • Views: 2,048
    06-22-2015, 12:29 PM Go to last post
  15. SAS code to create game scheduler for 8 players

    I'm trying to set up a pseudo tournament competition thing. There are 8 players and at any given time 4 of the 8 players can participate. I would...

    Started by lancearmstrong1313‎, 06-05-2015 08:17 AM
    • Replies: 0
    • Views: 464
    06-05-2015, 08:17 AM Go to last post
  16. How to create value-weight returns from equal-weight returns when I have market caps?

    Hey SAS users! I'm creating a dataset where I want to calculate the value-weighted returns on 10 volatility portfolios (the portfolios are called...

    Started by SAS_robbert‎, 05-27-2015 05:37 AM
    sas 9.3, value-weighted returns
    • Replies: 0
    • Views: 470
    05-27-2015, 05:37 AM Go to last post
    • Replies: 0
    • Views: 192
    05-26-2015, 03:49 AM Go to last post
  17. #Occurences counter for each ID

    Hello i am trying to have a # of occurrences counter in a data set for each specific ID. I tried using the _N_ function, but that doesn't reset at...

    Started by cwick2521‎, 05-21-2015 12:40 PM
    • Replies: 5
    • Views: 320
    05-21-2015, 03:14 PM Go to last post
  18. SAS sources

    This looks like an amazing source for SAS material http://support.sas.com/resources/papers/proceedings10/185-2010.pdf

    Started by noetsi‎, 05-18-2015 08:28 AM
    • Replies: 0
    • Views: 236
    05-18-2015, 08:28 AM Go to last post
  19. Using Proc Glimmix or NLMIXED

    Using proc glimmix

    Started by anne747‎, 03-12-2015 03:30 PM
    • Replies: 3
    • Views: 698
    05-11-2015, 06:56 PM Go to last post
  20. Sum of multiple variables by group

    Hi so not really sure how to explain this (new to SAS forums) but I can't seem to find a way of doing this.... I have a dataset with over 900...

    Started by SDavis‎, 05-08-2015 10:02 AM
    • Replies: 2
    • Views: 291
    05-11-2015, 11:56 AM Go to last post
  21. Check if macro variable exists within another macro variable string

    Let's say I have the following code: %LET X = a b c d e; %LET Y = b; Is there an easy way to do an if/then that checks if &Y exists in...

    Started by lancearmstrong1313‎, 05-06-2015 06:36 AM
    • Replies: 4
    • Views: 310
    05-06-2015, 09:56 AM Go to last post
  22. troubleshooting: if then statement populating new variable with missing values

    Hello I'm trying to convert variable hist_type (a character variable with values like lobular, ductal, etc) to a newly named variable hist_code...

    Started by crahillytierney‎, 05-02-2015 12:49 PM
    • Replies: 2
    • Views: 361
    05-04-2015, 09:53 AM Go to last post
  23. SAS Reshape Table Wide to Long Format

    So let's say I have some data in a wide format (multiple representations of a variable across columns). data wide; input x y z1 z2 z3;...

    Started by bryangoodrich‎, 05-01-2015 10:34 AM
    • Replies: 2
    • Views: 256
    05-01-2015, 10:52 AM Go to last post
  24. Estimate mean survival time (fit weibull distribution)

    I have a dataset that has a unique ID for each person, their time until event or censoring and then a variable indicating if that person was censored...

    Started by lancearmstrong1313‎, 04-28-2015 01:26 PM
    • Replies: 2
    • Views: 254
    04-30-2015, 12:10 PM Go to last post
  25. Red face How to get daily census of patient's stay?

    I am trying to write a code for the daily midnight census for patient's stay in the hospital. The daily midnight census counts how many patients at...

    Started by Janoose‎, 04-27-2015 02:31 PM
    • Replies: 4
    • Views: 298
    04-30-2015, 07:44 AM Go to last post
  26. Question SAS code for Two way ANOVA

    Below is the dataset for three way Anova and I would like someone to help me with the sas code for this. I am not sure how to solve this two way...

    Started by Deepali‎, 04-27-2015 08:25 AM
    • Replies: 9
    • Views: 398
    04-29-2015, 07:42 AM Go to last post
  27. Bootstrapping code for linear regression

    I am brand new to doing bootstrapping as a method and in SAS so I would appreciate comments on this. I started by replicating the data base...

    Started by noetsi‎, 04-27-2015 11:00 AM
    • Replies: 8
    • Views: 233
    04-27-2015, 03:38 PM Go to last post
  28. Transforming 1 time variable into a covariate

    Hello, I am trying to perform a mixed model anova analysis on a dataset with measurements at 0-6 time points. At each time point, patients 1 - 20...

    Started by aclarke‎, 04-21-2015 08:01 PM
    • Replies: 1
    • Views: 329
    04-25-2015, 06:36 AM Go to last post
  29. White's test, white's standard error in PROC REG

    Anyone know the code for White's test of unequal error variance and how to generate White's SE in PROC REG? I actually found one source for this,...

    Started by noetsi‎, 04-21-2015 04:58 PM
    • Replies: 2
    • Views: 310
    04-21-2015, 05:45 PM Go to last post
  30. Scale= statement

    I am trying to run the Vuong macro and I have everything set up, minus a few things. For nparm1 and nparm2 I just looked at the output for number of...

    Started by wernie07‎, 04-10-2015 06:30 PM
    • Replies: 1
    • Views: 431
    04-11-2015, 10:21 PM Go to last post
  31. Question Do I need this variable in the class statement? And IRRs

    I am trying to calculate incidence rate ratios and 95% CIs for the interaction between two variables: area and time. My variables are n, area,...

    Started by wernie07‎, 04-08-2015 06:24 PM
    class, incidence rate ratio
    • Replies: 1
    • Views: 294
    04-11-2015, 10:16 PM Go to last post
  32. 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 10:49 AM
    %do, %if, loop, macro
    • Replies: 3
    • Views: 442
    04-10-2015, 12:50 AM Go to last post
  33. R and SAS book

    Anyone read this? It sounds interesting. http://sas-and-r.blogspot.com/2010/03/example-730-simulate-censored-survival.html I think this...

    Started by noetsi‎, 01-12-2015 02:48 PM
    • Replies: 4
    • Views: 654
    04-08-2015, 06:02 PM Go to last post
  34. 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: 6
    • Views: 702
    04-08-2015, 05:56 PM Go to last post
  35. SAS code for converting arcsine-transformed percent data to original unit

    I am working on the SAS code for multiple linear regression where the dependent variable is a continuos variable and is in percent. I log transformed...

    Started by sb1605‎, 04-07-2015 04:17 PM
    • Replies: 2
    • Views: 452
    04-08-2015, 05:35 PM Go to last post
  36. Help plz proc_format

    Hi everyvody, I'm working with an alphanumeric variable, I applied a frequence proc on it and I want to know how to make a format function to...

    Started by Ihssanee‎, 03-26-2015 05:37 AM
    • Replies: 1
    • Views: 481
    03-26-2015, 07:45 AM Go to last post
  37. MACRO variable inside MACRO

    I'm curious why the following code does not work: %LET mbr_list=1,2,3,4,5; %MACRO mbr_loop(mbr_values); %let...

    Started by lancearmstrong1313‎, 03-24-2015 02:33 PM
    • Replies: 3
    • Views: 453
    03-25-2015, 06:13 AM Go to last post
  38. Extracting/Selecting observations of the last 20 mins of a SAS data set

    Hey guys, I hope anyone can help me on this. I have a data set, which is continuously updated. For each observation, I have the time and date...

    Started by plnc‎, 03-10-2015 06:25 PM
    • Replies: 4
    • Views: 513
    03-13-2015, 10:25 AM Go to last post
  39. Graphics in PROC GLIMMIX

    Hello, I'm looking to add graphs in SAS using PROC GLIMMIX. I've tried the statement: ods graphics on; before my programming statement...

    Started by compassion83‎, 04-14-2014 07:35 PM
    • Replies: 2
    • Views: 634
    03-09-2015, 06:58 PM Go to last post
  40. How to read a .wpd file inot sas data set?

    Hi, I am unable to read a .wpd (WPS) file into sas data set. Suppose there is a file Employee_Details.wpd stored at location z\:... Can I...

    Started by Shashank Prasad‎, 06-17-2014 06:18 AM
    • Replies: 1
    • Views: 1,105
    03-06-2015, 08:15 AM Go to last post
  41. Poissonness plot

    This is essentially the equivalent of a QQ plot for Poisson distribution, which can not use QQ plots since the distribution is of discrete data....

    Started by noetsi‎, 01-29-2015 08:08 AM
    2 Pages
    1 2
    • Replies: 15
    • Views: 1,022
    03-02-2015, 05:00 PM Go to last post
  42. Question Quick way to sum?

    I'm having trouble figuring out how to pick out the pieces of data that I need to then sum those pieces. So I have 3 areas ('east', 'west', and...

    Started by wernie07‎, 02-18-2015 04:00 AM
    • Replies: 5
    • Views: 515
    02-25-2015, 03:25 AM Go to last post
  43. SAS University Edition won't let me upload a large file

    Hi, I am doing a project for work with de-idenitifed secondary NHANES data. I have a .dat file and the SAS code for opening and labeling it. I...

    Started by alanend‎, 02-18-2015 10:08 AM
    • Replies: 4
    • Views: 571
    02-19-2015, 07:43 AM Go to last post
  44. Cool Performing multiple t-tests on different variables between the same two groups

    Hey everyone I would like to perform multiple t test on different variables ( let's say A B C D E ) in two different groups ( 1 2 ) and test if...

    Started by morgano‎, 02-17-2015 04:51 PM
    r help, sas data manipulation, ttest
    • Replies: 0
    • Views: 322
    02-17-2015, 04:51 PM Go to last post
  45. DO LOOP Creates a new variable that is the index I am using

    Hi, Sorry if this is a basic question but I have not been able to find a solution/answer. I am using a do loop with an array to process some...

    Started by Mike5‎, 02-12-2015 11:18 AM
    • Replies: 3
    • Views: 456
    02-12-2015, 01:25 PM Go to last post
  46. 4 categorical variables and 1 continuous varible (indep) analysis

    What stat analyses would be adviceble to run if you want to anayse the effects of 4 categorical variables on 1 continuous variable (indep)? var1 =...

    Started by vestllink‎, 02-10-2015 03:47 AM
    • Replies: 0
    • Views: 288
    02-10-2015, 03:47 AM Go to last post
  47. Specifying one age group? Proc genmod

    I'm trying to run a negative binomial (or poisson if it's saturated) model and have area and period as the class variables. I want to check if my...

    Started by wernie07‎, 02-03-2015 09:00 PM
    • Replies: 6
    • Views: 597
    02-04-2015, 09:43 PM Go to last post
  48. Interpreting proc genmod output

    I have hospitalization data (nsum) over a 17 year period for 3 different study areas (variables period and area). I have the log of the population as...

    Started by wernie07‎, 01-30-2015 08:33 PM
    • Replies: 0
    • Views: 451
    01-30-2015, 08:33 PM Go to last post
  49. Create excel sheet (from SAS) with Data Validation Options

    Hopefully this makes sense: So in excel you can use the Data Validation tool to create drop down lists to essentially force a user to have to...

    Started by lancearmstrong1313‎, 01-29-2015 08:46 AM
    • Replies: 1
    • Views: 321
    01-29-2015, 10:00 AM Go to last post
  50. Repeated Measures Nested Model in PROC Mixed?

    Hello, I'm looking for help analyzing data. Here's the experimental setup: 12 experimental plots, divided into 3 blocks. Each block...

    Started by MikeS‎, 01-29-2015 08:23 AM
    nested anova, proc mixed, repeated measures
    • Replies: 0
    • Views: 302
    01-29-2015, 08:23 AM Go to last post
  51. Negative binomial model - saturated?

    I am trying to run a model for cases (n) to see if area, period, and area*period are significant predictors. I am really only interested in the...

    Started by wernie07‎, 01-07-2015 04:40 PM
    • Replies: 2
    • Views: 561
    01-22-2015, 06:30 PM Go to last post
  52. interpretation for %DFTEST results

    Hello, I need to interpret the results of this macro %DFTEST: proc print data=sashelp.air;run; %dftest(sashelp.air, air, ar=1, dif=(1),...

    Started by Lubomir‎, 01-20-2015 11:42 AM
    %dftest, dftest, dickey fuller test, non-stationarity, stationarity
    • Replies: 0
    • Views: 359
    01-20-2015, 11:42 AM Go to last post
  53. SAS proceedings

    This is a gold mine both for stats, and other areas, and coding. I have only gone to the 2010 and 2014 sites and I have five pages of links that I...

    Started by noetsi‎, 01-13-2015 12:12 PM
    • Replies: 0
    • Views: 358
    01-13-2015, 12:12 PM Go to last post
  54. Problems with matched sampling using SAS

    Hi, I tried to find matched control matches to multiple variables: 1) age +/- 10 years and 2) diabetes I used the codes as shown below...

    Started by biscodyl‎, 01-12-2015 06:08 AM
    matched controls, matched variables, matching
    • Replies: 1
    • Views: 550
    01-12-2015, 09:51 AM Go to last post
  55. Generating distributions for all variables in a data set.

    This is fairly simple, but I figured others might find this of value. https://communities.sas.com/thread/64329

    Started by noetsi‎, 01-08-2015 11:20 AM
    • Replies: 0
    • Views: 453
    01-08-2015, 11:20 AM Go to last post
  56. Question Summing observations for two different variables by two variables

    Hi, I have a data set that contains the variables: age sex n pop area period. So the initial dataset looks something like this: sex ...

    Started by wernie07‎, 01-03-2015 04:40 PM
    • Replies: 3
    • Views: 471
    01-07-2015, 05:41 PM Go to last post
  57. Case sensitivity

    I spent several hours today trying to figure out why code I was running was not working. I got no error messages, but there were no results from a...

    Started by noetsi‎, 01-05-2015 04:44 PM
    • Replies: 4
    • Views: 482
    01-06-2015, 02:22 PM Go to last post
  58. FedSQL

    I have never heard of this before, but it has some amazing functions . Apparently this just became available in Base Sas in the 9.4 release. I do not...

    Started by noetsi‎, 01-06-2015 10:17 AM
    • Replies: 0
    • Views: 411
    01-06-2015, 10:17 AM Go to last post
  59. Sgplot

    I am running PROC SGPLOT and getting the error ERROR: Procedure SQPLOT not found Which usually means you don't have that product. But the...

    Started by noetsi‎, 01-02-2015 03:50 PM
    • Replies: 3
    • Views: 556
    01-02-2015, 06:03 PM Go to last post

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