1. 10-14-2010
    Views:
    22,135
+ 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 1184

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: 7,058
    06-26-2015, 10:17 AM Go to last post
  1. 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: 3
    • Views: 156
    Yesterday, 12:35 AM Go to last post
  2. 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: 231
    08-26-2015, 12:45 AM Go to last post
  3. 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: 337
    08-18-2015, 09:39 AM Go to last post
  4. trouble reading in a csv

    Hi, I have a csv file I am trying to read into SAS, and the output from my proc print step shows me that the data isn't being read properly in...

    Started by ahart‎, 08-11-2015 04:39 AM
    • Replies: 14
    • Views: 656
    08-18-2015, 07:32 AM Go to last post
  5. Transpose Data

    Hi there. I am trying to transpose my data without proc transpose. I have the following data: ID Fall_Adj Fall_Raw Spring_Adj Spring_Raw 1...

    Started by ali.hash‎, 08-17-2015 12:34 AM
    transpose
    • Replies: 1
    • Views: 124
    08-17-2015, 01:41 AM Go to last post
  6. CSV file date format

    I have a csv file I am reading in SAS and I am trying to format the dates and it doesn't seem to work the csv has this date 12/04/2008 00:00:00...

    Started by ahart‎, 08-06-2015 03:21 AM
    • Replies: 4
    • Views: 218
    08-11-2015, 01:03 PM Go to last post
  7. Import/Merge weekly file to Master historic

    Hi I would like to ask some help I have 3 steps described below, in a nut shell I would like import csv file (New_Customers_weekTEST) have it...

    Started by ahart‎, 08-06-2015 06:18 AM
    2 Pages
    1 2
    • Replies: 16
    • Views: 517
    08-11-2015, 08:40 AM Go to last post
  8. CSV import tp SAS dataset doesn't show any results

    hi, I have done some work on a csv file and following this, I am looking to import it into SAS as a SAS dataset within a specified library. My...

    Started by ahart‎, 08-11-2015 03:37 AM
    • Replies: 0
    • Views: 104
    08-11-2015, 03:37 AM Go to last post
  9. ERROR: Procedure GEE not found

    Hi Professionals, I've just read this webpage about building weighted GEE models with PROC GEE. The link is:...

    Started by freezingswallow‎, 08-06-2015 03:26 PM
    proc gee, procedure not found
    • Replies: 2
    • Views: 159
    08-06-2015, 03:58 PM Go to last post
  10. 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: 1
    • Views: 165
    08-04-2015, 11:16 AM Go to last post
  11. 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: 4
    • Views: 341
    07-30-2015, 02:05 PM Go to last post
  12. 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‎, 07-29-2015 10:57 AM
    • Replies: 2
    • Views: 168
    07-29-2015, 11:06 AM Go to last post
  13. 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: 221
    07-28-2015, 06:32 PM Go to last post
  14. 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: 625
    07-24-2015, 04:14 PM Go to last post
  15. 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: 237
    07-18-2015, 06:36 PM Go to last post
  16. 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: 336
    07-13-2015, 04:09 AM Go to last post
  17. 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: 381
    07-09-2015, 06:35 PM Go to last post
  18. 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: 433
    06-26-2015, 12:38 PM Go to last post
  19. 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: 192
    06-26-2015, 09:21 AM Go to last post
  20. 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: 379
    06-26-2015, 09:03 AM Go to last post
  21. 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: 199
    06-25-2015, 04:40 PM Go to last post
  22. proc calis

    I found this from Alison to be bemusing

    Started by noetsi‎, 06-25-2015 03:25 PM
    • Replies: 0
    • Views: 144
    06-25-2015, 03:25 PM Go to last post
  23. 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: 275
    06-23-2015, 07:54 AM Go to last post
  24. 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,128
    06-22-2015, 12:29 PM Go to last post
  25. 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: 493
    06-05-2015, 08:17 AM Go to last post
  26. 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: 528
    05-27-2015, 05:37 AM Go to last post
    • Replies: 0
    • Views: 224
    05-26-2015, 03:49 AM Go to last post
  27. #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: 354
    05-21-2015, 03:14 PM Go to last post
  28. 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: 273
    05-18-2015, 08:28 AM Go to last post
  29. Using Proc Glimmix or NLMIXED

    Using proc glimmix

    Started by anne747‎, 03-12-2015 03:30 PM
    • Replies: 3
    • Views: 747
    05-11-2015, 06:56 PM Go to last post
  30. 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: 326
    05-11-2015, 11:56 AM Go to last post
  31. 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: 336
    05-06-2015, 09:56 AM Go to last post
  32. 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: 387
    05-04-2015, 09:53 AM Go to last post
  33. 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: 292
    05-01-2015, 10:52 AM Go to last post
  34. 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: 280
    04-30-2015, 12:10 PM Go to last post
  35. 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: 335
    04-30-2015, 07:44 AM Go to last post
  36. 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: 465
    04-29-2015, 07:42 AM Go to last post
  37. 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: 272
    04-27-2015, 03:38 PM Go to last post
  38. 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: 361
    04-25-2015, 06:36 AM Go to last post
  39. 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: 395
    04-21-2015, 05:45 PM Go to last post
  40. 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: 466
    04-11-2015, 10:21 PM Go to last post
  41. 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: 319
    04-11-2015, 10:16 PM Go to last post
  42. 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: 489
    04-10-2015, 12:50 AM Go to last post
  43. 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: 703
    04-08-2015, 06:02 PM Go to last post
  44. 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: 836
    04-08-2015, 05:56 PM Go to last post
  45. 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: 572
    04-08-2015, 05:35 PM Go to last post
  46. 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: 510
    03-26-2015, 07:45 AM Go to last post
  47. 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: 494
    03-25-2015, 06:13 AM Go to last post
  48. 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: 545
    03-13-2015, 10:25 AM Go to last post
  49. 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: 666
    03-09-2015, 06:58 PM Go to last post
  50. 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,234
    03-06-2015, 08:15 AM Go to last post
  51. 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,149
    03-02-2015, 05:00 PM Go to last post
  52. 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: 570
    02-25-2015, 03:25 AM Go to last post
  53. 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: 644
    02-19-2015, 07:43 AM Go to last post
  54. 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: 362
    02-17-2015, 04:51 PM Go to last post
  55. 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: 495
    02-12-2015, 01:25 PM Go to last post
  56. 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: 309
    02-10-2015, 03:47 AM Go to last post
  57. 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: 658
    02-04-2015, 09:43 PM Go to last post
  58. 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: 540
    01-30-2015, 08:33 PM Go to last post
  59. 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: 354
    01-29-2015, 10:00 AM 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