1. Announcement:
    Want access to a chatbox?
    Dason ‎(Devorador de queso)
+ 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 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,970
    06-26-2015, 10:17 AM Go to last post
  1. [SOLVED] Lag function in SAS not updating to reflect new values.

    I have some SAS code that needs to reference some values in a previous row. The lag function is typically how one deals with that. The issue is...

    Started by Dason‎, 01-05-2017 11:44 AM
    • Replies: 6
    • Views: 4,262
    11-21-2017, 07:40 AM Go to last post
  2. Multilevel analysis -SAS

    HLSMITH you might be interested in this. It is a macro designed to help test the assumptions of multilevel models. ...

    Started by noetsi‎, 05-09-2017 09:58 AM
    3 Pages
    1 2 3
    • Replies: 42
    • Views: 7,280
    09-27-2017, 11:35 AM Go to last post
  3. macro issue

    I built this macro %Macro Tanisha(fileName=, extractDate=); PROC IMPORT DATAFILE="S:\CIU\sasTestFolder\&fileName" OUT=sasuser.test1 DBMS=XLSX...

    Started by noetsi‎, 09-25-2017 11:09 AM
    • Replies: 2
    • Views: 452
    09-25-2017, 11:56 AM Go to last post
  4. Problem with left join

    When I run the following code I get a table, but one missing customers, because they are not in one of the tables. proc SQL; Create table...

    Started by noetsi‎, 09-22-2017 09:53 AM
    • Replies: 4
    • Views: 635
    09-25-2017, 11:07 AM Go to last post
  5. Convergence issue with multilevel models.

    As recommended I am running a chi square test to determine if random (and fixed) effects are statistically significant for a multilevel model (the...

    Started by noetsi‎, 09-15-2017 12:13 PM
    • Replies: 2
    • Views: 658
    09-15-2017, 08:06 PM Go to last post
  6. Creating a counter in PROC SQL

    I'm trying to create a counter column in my PROC SQL query with the following code: ROW_NUMBER OVER(PARTITION BY CKey ORDER BY Date) -1 AS...

    Started by greg6363‎, 09-08-2017 11:36 AM
    • Replies: 1
    • Views: 751
    09-08-2017, 11:53 AM Go to last post
  7. PROC SQL runs slow (or doesn't run)

    I have a very basic query PROC sql inobs =10; Select * from table I just want to get a basic result out so I can understand the table and even...

    Started by semidevil‎, 08-28-2017 07:26 PM
    • Replies: 3
    • Views: 846
    09-01-2017, 02:06 PM Go to last post
  8. Create a view in Oracle SQL from SAS

    I'm trying to create a view from SAS to SQL (i.e. I want to be able to query this view in SQL). Let's say I have a bunch of tables called TABLE1,...

    Started by Weibull‎, 08-29-2017 01:27 PM
    • Replies: 4
    • Views: 847
    08-30-2017, 10:39 AM Go to last post
  9. proc SQL

    I have two samples one includes the entire organization. Call it work.t1. The other is a subset of t1 who took the test, call it work.t2. What I want...

    Started by noetsi‎, 08-01-2017 06:11 PM
    3 Pages
    1 2 3
    • Replies: 33
    • Views: 2,483
    08-15-2017, 06:48 PM Go to last post
  10. Are there any structured online courses for SAS

    Besides the expensive official SAS training, are there free or more affordable SAS training I can do (like coursera, udemy, datacamp, etc etc)? ...

    Started by semidevil‎, 07-25-2017 12:26 PM
    • Replies: 5
    • Views: 1,008
    07-26-2017, 02:54 PM Go to last post
  11. Regression by groups

    Anyone know a quick way to do one regression for every group, so for example if you have a variable called unit and you want to run a separate...

    Started by noetsi‎, 07-24-2017 11:43 AM
    • Replies: 4
    • Views: 462
    07-24-2017, 01:41 PM Go to last post
  12. PLS regression in SAS, what does corr1 and corr2 refers to?

    Hi all, I am attempting to interpret the results from a PLS-regression done in SAS, and after the analysis SAS produces a table containing two...

    Started by Epimorpha‎, 06-19-2017 09:07 AM
    corr1, corr2, pls, regression, sas
    • Replies: 1
    • Views: 1,443
    06-26-2017, 11:05 AM Go to last post
  13. Different PROC SQL question

    Here's my code: proc sql; create table wavgpd as select DISTINCT acctnum, sum(exp) as exp, avg (pd) as PD, ((exp x pd) as WAVG_PD from...

    Started by greg6363‎, 06-12-2017 07:07 AM
    • Replies: 3
    • Views: 870
    06-12-2017, 01:29 PM Go to last post
  14. proc sql question

    This one is driving me crazy. I want to exclude those who meet two conditions. They have been in my organization six months or less and have no cost....

    Started by noetsi‎, 05-24-2017 11:35 AM
    • Replies: 3
    • Views: 1,433
    05-24-2017, 11:42 PM Go to last post
  15. Differences between two dates

    I am trying to find how many days occurred between datebegin_14 and April 30, 2017. This generates no error but also no results for the field...

    Started by noetsi‎, 05-23-2017 04:28 PM
    • Replies: 3
    • Views: 1,226
    05-24-2017, 08:55 AM Go to last post
  16. Really strange join issue.

    I did the following code. Proc SQL; Create table work.test7 as select distinct cs.cusprofile_An, t1.customerid, "VR" || substr(cats...

    Started by noetsi‎, 05-16-2017 06:15 PM
    • Replies: 0
    • Views: 1,005
    05-16-2017, 06:15 PM Go to last post
  17. problem generating age

    I have a function I have used for years successfully to calculate age. It's ((floor ((intck('month', T1.DATEOFBIRTH, ...

    Started by noetsi‎, 04-14-2017 04:50 PM
    • Replies: 5
    • Views: 2,228
    04-17-2017, 10:53 AM Go to last post
  18. To convert sas code to stata code

    Hello All, I am seeking professional help to convert SAS code to STATA code. I will compensate your time financially on a mutually agreeable...

    Started by anwar‎, 04-04-2017 12:27 AM
    sas stata
    • Replies: 0
    • Views: 1,547
    04-04-2017, 12:27 AM Go to last post
  19. Looking to identify differences in how segments answered questions

    Admittedly I'm a statistics newbie. I used embedded data to identify 6 discrete customer segments in my survey data. I'd like to see if there are...

    Started by vandalfsens‎, 03-30-2017 02:17 PM
    • Replies: 0
    • Views: 860
    03-30-2017, 02:17 PM Go to last post
  20. Cant resolve a script

    Hello, I would like to ask you for help. I am not a SAS user but now I try to solve one script from a book. Please find attached print screen. Could...

    Started by tradermartin‎, 03-12-2017 05:08 PM
    • Replies: 7
    • Views: 2,917
    03-20-2017, 02:02 PM Go to last post
  21. Help with SAS code

    Hi friends .Please help me how to code for the below scenario. We have a person with id a. He had tattoos all over his body parts with specific...

    Started by Dhana‎, 03-12-2017 07:19 AM
    • Replies: 0
    • Views: 1,406
    03-12-2017, 07:19 AM Go to last post
  22. Exact Pearson Chi-Sq w/ MC (not a question)

    This is not a question but a reply to ondansetron. ondansetron, See following (sorry for spacings in code, when I cut-n-paste in gets a...

    Started by hlsmith‎, 03-07-2017 11:14 AM
    • Replies: 2
    • Views: 2,675
    03-07-2017, 05:15 PM Go to last post
  23. Few coding questions for a beginner

    I was wondering how to select for a few given variables per say. So like average weight of blonde women compared to average weight of brunette men. I...

    Started by Vpv01‎, 02-20-2017 10:25 PM
    • Replies: 3
    • Views: 3,239
    02-27-2017, 12:12 PM Go to last post
  24. weka- cluster k means - choose the best number of clusters

    thanks for your advance for helping this. I have changed the various cluster and choose the minimum percentage of incorrectly clustered instances....

    Started by raju1‎, 02-12-2017 09:02 AM
    • Replies: 2
    • Views: 2,690
    02-12-2017, 11:56 AM Go to last post
  25. Wants to learn SAS

    I am very new to SAS. i was looking to get a clinical research position but i learnt SAS is the right programming i need to know if am to get into...

    Started by fluidt7‎, 01-26-2017 04:35 PM
    • Replies: 2
    • Views: 4,015
    01-30-2017, 07:24 PM Go to last post
  26. [SOLVED] Problem with create statement.

    SAS is connected to our primary data bases through a lib name I ran if that matters. I run the following statement. proc sql; create table...

    Started by noetsi‎, 01-13-2017 02:30 PM
    • Replies: 0
    • Views: 3,850
    01-13-2017, 02:30 PM Go to last post
  27. Setting MEMSIZE=MAX

    Hi, I am trying to set MEMSIZE=MAX but from the SAS support website I am not clear on the proper syntax for this and where it should go in my...

    Started by martink‎, 12-26-2016 12:07 AM
    • Replies: 1
    • Views: 3,503
    12-26-2016, 08:36 AM Go to last post
  28. Time Series Book

    This looks useful despite not having ARDL. Note the link does not show the whole book, just a small part of it. ...

    Started by noetsi‎, 12-12-2016 10:28 AM
    • Replies: 5
    • Views: 5,910
    12-13-2016, 10:46 AM Go to last post
  29. Help with data type error in my code (proc Sql)

    I have a simple code: %let YYMMSD = 20160101; %let YYMMED = 20160131; proc sql; select * from table pol where pol.date between &yymmsd and...

    Started by semidevil‎, 12-12-2016 01:44 PM
    • Replies: 1
    • Views: 2,944
    12-12-2016, 02:26 PM Go to last post
  30. 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: 13
    • Views: 8,567
    11-30-2016, 11:43 AM Go to last post
  31. 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: 3,284
    11-29-2016, 10:18 AM Go to last post
  32. 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: 3,256
    11-23-2016, 07:43 PM Go to last post
  33. 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: 4,567
    11-20-2016, 07:13 AM Go to last post
  34. 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: 4,237
    11-16-2016, 01:46 PM Go to last post
  35. 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: 4,138
    11-16-2016, 09:26 AM Go to last post
  36. 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 03:31 PM
    • Replies: 0
    • Views: 3,521
    10-14-2016, 03:31 PM Go to last post
  37. 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 09:27 AM
    • Replies: 0
    • Views: 3,049
    10-14-2016, 09:27 AM Go to last post
  38. 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 12:44 PM
    • Replies: 3
    • Views: 3,096
    10-12-2016, 07:56 AM Go to last post
  39. 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: 4,235
    10-11-2016, 03:08 PM Go to last post
  40. 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 02:01 AM
    • Replies: 3
    • Views: 3,814
    10-07-2016, 08:21 AM Go to last post
  41. Interpreting odds ratios in PROC LOGISTIC


    Started by noetsi‎, 10-03-2016 11:44 AM
    • Replies: 1
    • Views: 3,238
    10-03-2016, 02:01 PM Go to last post
  42. 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 08:46 AM
    clinical trial, higher order analyses, sas studio, uneven group sizes
    • Replies: 1
    • Views: 4,329
    09-16-2016, 06:22 PM Go to last post
  43. 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 12:42 PM
    mixed model
    • Replies: 1
    • Views: 3,643
    09-06-2016, 10:04 AM Go to last post
  44. 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: 4,298
    08-26-2016, 08:37 AM Go to last post
  45. 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: 3,008
    08-24-2016, 10:39 AM Go to last post
  46. 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: 3,353
    08-15-2016, 04:13 PM Go to last post
  47. 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: 2,931
    08-12-2016, 04:35 PM Go to last post
  48. 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: 3,997
    08-04-2016, 04:45 PM Go to last post
  49. 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: 8,052
    08-02-2016, 02:43 AM Go to last post
  50. 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: 3,374
    07-25-2016, 11:59 AM Go to last post
  51. 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: 4,070
    07-05-2016, 09:44 AM Go to last post
  52. 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: 2,914
    07-01-2016, 09:58 AM Go to last post
  53. 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: 3,330
    06-27-2016, 07:26 AM Go to last post
  54. 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: 3,748
    06-25-2016, 02:03 AM Go to last post
  55. 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: 3,658
    06-23-2016, 08:19 PM Go to last post
  56. 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: 4,233
    06-23-2016, 11:39 AM Go to last post
  57. 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: 4,010
    06-21-2016, 02:09 PM Go to last post
  58. 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: 5,913
    06-20-2016, 09:50 AM Go to last post
  59. 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: 6,340
    06-16-2016, 09:06 PM Go to last post
  60. 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: 7,967
    06-16-2016, 02:07 PM 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