SAS usage and programming. SAS/Base, SAS/Stat, proc sql, SAS macro...
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...
I am analysing multiple variables var1 - var10 which have labels. They are named as such so that running a do loop is easy in a Macro. When running...
I hate to do this, but I just can't figure this out. I'm trying to merge two sets of data, one of them is a year by year panel of corporate info and...
I want to simulate a data set for a dependent variable that takes on two levels (0 and 1). I want one of the IV to be linearly related to the DV and...
data; input ENGINE $ SHAFTS RPM CPRATIO INLET-TEMP EXH-TEMP AIRFLOW POWER HEATRATE; if ENGINE='Traditional' then dummy=1; if ENGINE= ‘Advanced’...
Hi, I have been using a macro to run logistic regressions for several independent variables using proc logistic. I would like to know if it is...
Data ConcreteAggregatePaving; set dtdb2cms.T_MSIDR; where SIDR_MTRL_CODE eq (001230117,001240117,001030016,...
Hi Everyone, I have data from an experiment with a RCBD. The main independent variable of interest is crop variety (var). In 2011, we conducted...
hey guys... I decided to take "SAS Enterprise Guide 1: Querying and Reporting" course. I do not have programming background but after reading the...
This is part a coding issue and part a question on regression, but I put it here. Logistic regression in SAS does listwise deletion so that if you...
Hello all: I'm not quite sure of the best way to accomplish what I'm trying to do. Currently, I have a dataset that looks like: data test;...
Hi Everyone, I am trying to create an if then statement that states if my variable (WWT) is between this range then it equals a set value. This...
I have a second-by-second data. I want to choose an observation every 5 minutes. If the data stops at 16:42:02 which is less than 17:30:00, I want to...
Study the notes “Simulations in SAS” and answer the questions that follow. Questions 1. Draw 10000 values randomly from a standard normal...
message erased.
Hello all, I need some help with a macro. My goal is to take a dataset of multiple variables and find how many times unique combinations of pairs...
Is it possible to SAS to process each row individually? So for example, I have a data set: Name Age a 1 b 2 I would like to loop through each...
I am new with sas and I'm doing logistic regression with several predictive variables. I am using the following code; proc surveyselect ...
I have a model where I really want to run 41 dummy predictor variables (because each one is important to assess and using factor analysis to reduce...
Hi all, I need help in solving this question for my research work. My data looks like this We finger printed plant samples with different molecular...
Apparently Factor Analysis in SAS does list wise deletion. If any individual is missing on any variable they are deleted for all variables (even if...
I have 3 groups for a study (A, B, C) made up of subjects with 3 different motivation levels (motive1, motive2, motive3). The subjects in Group A...
I've been playing around with mixed model code over the last few days, and it seems that no matter what I do, some of my lsmeans (for 2 different...
I have imported an Excel spreadsheet into SAS as WORK.X1. I am trying these lines: proc freq data = x1 ; data x2 ; PhysicalAggression =...
I'm working with a mixed model to determine differences in liking for a food over a 16 week period based on covariates labeled group, diff3, and...
Hello all: I'm know the standard, default page size is 8.5 x 11. However, is there a way to tell SAS that you want to create a PDF using 11 x 17...
Hi, I have an alpha-numeric variable which is a code representing which program a payment was issued from. For example A1 would be from "Loans"...
I have an Excel table. In SAS 9.2, I can use File > Import Data to bring that table into the SAS Explorer pane: contents of Work now includes that...
What are the differences between... Am I correct?
Hi Folks, I'm trying to fit a time series curve which I need to apply for different data. I used Proc Forecast to get the estimates. I need to...
I have a data set of the following loss figures Acct Loss A 250,000 B 325,000 C 450,000 D 125,000 E 680,000 F ...
Hello all, hopefully someone can help understand why something is not working. To summarize some background, I used macros and do-loops to...
Hey guys, this is my first post, so thanks in advance for reading. I am using SAS, and comparing the effects of a drug on a biological measure,...
Hello: I need some help figuring out how to add a superscript to a specific cell in a PROC REPORT table. It has nothing to do with whether or not...
Hello all: I'm using ODS TAGSETS.EXCELXP to send some PROC REPORT tables into excel. However, I have noticed that some text in the columns gets...
Hi to everyone, we did genetic purity test with SNP (44) markers for 200 lines with 8 plants in each line (Total 1600 data points) to know how pure...
Hi there, I keep getting non-estimatable statement when I run LSMeans with PROC MIXED. Any feedback on why this is happening? Thanks!
I know that (in theory) you can use a correlation matrix rather than the raw data to do EFA. Does anyone know how to do this in SAS?
when i use ods to output LSmeans statement ' COV , Obs _NAME_ drug LSMEAN STDERR NUMBER COV1 COV2 ...
Is there any simple code to divide a PDF page into 4 equal sized quadrants (essentially 2 columns and 2 rows where each of the 4 cells is equal...
Hello all, I have a question about how best to accomplish something via a do loop (or perhaps there is a better way?). Hopefully I can explain my...
Does anyone know if you can use polychoric correlations in SAS for factor analysis?
Hello all: I'm curious if anyone know how to insert a small text box containing descriptive statistics information (mean, n, std. dev....) within...
hello all, I've had issues with PROC SGPLOT before (for instance needing to use UNICODE instead of super to add a superscript to text in the...
Hi All, I am trying to see the effect of trt on calorie intake. I have 2 trts -1 trt and 1 control Communities -a and b Timepoints -1, 2, 3 My...
Hi All, I am analyzing the socioeconomic and demographic status part of my data. I have many indicators. I want to do descriptive and bivariate...
Dear Friends, thanks in advance for your support and help. I have a big excel file which needs to be exported into sas. I need to reorganize the data...
I used to know this, but.... I am beginning a major new project using bivariate logistic regression. I know the assumptions for OLS (and how you...
Hi All, I just ran the PROC MIXED for outputting the residual error in SAS I am wondering if I need to look at Shapiro-Wilk or Kolmogorov-Smirnov...
Hi all, This is probably a no-brainer for some of you, but I haven't been able to properly understand the syntax for the CONTRAST statement in PROC...
I have a series of SQL queries in my SAS code that I use to connect to an Oracle database. I use the prompt manager to enter my passwords in the...
I need to create a macro variable "cutoff" which would be a specified date in the mm/dd/yy format using the macro function in SAS (e.g. %let ...). I...
Hello, I am relatively new here and trying to work on some homework. I've been doing rather well in my SAS class, however I just do not seem to...
Dear all:When I read an excel file with formated datetime with proc import process, I can only get the date part, the tim parts were lost. How to...
Hello, I am studying the determinants of the adoption of a technology by firms. I first used a Cox model through the PHREG procedure. The thing...
Hello everyone, I have another interpretation question regarding PROC Glimmix, this is quite complicated, I am quite lost. I have managed to fit the...
Hi all: When I use the following proc : proc append base=onemin base=closest;run; The log displays the warning: ...
Hello, I'm just getting started with sas and wondering if someone can give me some tips. I have the 3 data lines below. I'd like to programmatically...
Hello I ran PROC Glimmix to fit a generalized mixed model for an ordinal response with 6 categories. I have one fixed effect T (treatment) with 3...
I have the following program in SAS: Is there a way to create an output where I can see the variable names displayed for gender? I'd like to see...
Hi, How can I move a SAS dataset (all numeric variables) with formats (manually defined for 470 variables and saved within a SAS library file) to...
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.
Forum Rules
Advertise on Talk Stats
