About pamplemouse22

pamplemouse22 · ‎09-25-2017

Hi ballardw, Can you please explain to me how this part of your code pulls the right data for the calculation? Thank you! where have_b.date_start le have_a.date le have_b.date_end group by have_b.date_start, have_b.date_end

pamplemouse22 · ‎09-22-2017

Thank you so much! This is exactly what I was looking for. I have a few more conditions that I didn't describe that are needed to make the merge, so I will attempt adjusting your example code, accordingly. Thanks for getting it started! I appreciate it. Might be back with additional questions.

pamplemouse22 · ‎09-22-2017

Hi Patrick, Thanks! The only way I could think of merging the data is to create a binary variable "start"-1/0 and then have a single date variable and then I can merge by date, but this would involve making my dataset larger than it is - not sure I want to do that. the proc sql option below seems like a good option ! Am going to try that. Thanks for your help.

pamplemouse22 · ‎09-22-2017

Hi all, Data management question. I am trying to create a dataset using information from two datasets (not merged) and would like some suggestions how to complete this task. I'd like to sum down a column, by group, from dataset "have_a", using a condition that uses data in dataset "have_b". Is this possible without merging the two datasets? I would like to generate dataset "want" by computing the average count from dataset "have_a" over the date range specified in dataset "have_b". The following describes what I have and want. I hope this is clear. Thank you!! data have_a; input group count date; datalines; 1 50 01JAN2005 1 51 02JAN2005 1 49 03JAN2005 1 34 04JAN2005 1 34 05JAN2005 ; run; data have_b; input group date_start date_end; datalines; 1 01JAN2005 05JAN2005 1 02JAN2005 05JAN2005 ; run; data want; input group date_start date_end mean; datalines; 1 01JAN2005 05JAN2005 43.6 1 02JAN2005 05JAN2005 42.0 ; run;

pamplemouse22 · ‎09-22-2017

oh, hah! that makes sense. thank you!

pamplemouse22 · ‎09-22-2017

This works beautifully! Thank you. I'm trying to understand how this works. What does the carrot in following line do? flag^=1

pamplemouse22 · ‎09-22-2017

Hi everyone, I am stuck on a data management task and thought someone here may be able to help me. I am working with a dataset where each individual has ~30 rows of repeated data. The variables with information that differs are dates and a variable that indicates the first for each group. I'd like to add 7 number of days to every row, by group. I have a start date for the first row for each individual and need to add 7 days to each row until the next individual is reached (e.g., row 31) where the same process is repeated. Any suggestions? Here is what I have and what i want the data to look like. Thank you!! data have; input id date first; datalines; 1 03OCT2010 1 1 . 0 1 . 0 1 . 0 2 01JAN2011 1 2 . 0 2 . 0 ; run; data want; input id date first; datalines; 1 03OCT2010 1 1 10OCT2010 0 1 17OCT2010 0 1 24OCT2010 0 2 01JAN2011 1 2 08JAN2011 0 2 15JAN2011 0 ; run;

pamplemouse22 · ‎06-09-2017

thank you! i found the original macro definition and am trying to run that first. Any tips to make the run time shorter for this macro? I don't want ot delete out any of the comments. I included this at at the top which is helping some, but it still takes about an hour to run, each time. ODS LISTING close; ODS RESULTS OFF;

pamplemouse22 · ‎06-09-2017

thank you! i found the script that defines the macro. Now that I have it, the macro definition is very long and takes me about an hour to run each time. do you have suggestions to make this process faster? It's a series of proc reg. I suppressed output to make it run faster, using the followng code. Any other tips? ODS LISTING close; ODS RESULTS OFF;

pamplemouse22 · ‎06-09-2017

thank you! i found the script to define the macro.

pamplemouse22 · ‎06-08-2017

Hello, I am having trouble using a SAS macro that was described in a paper. Can you please tell me what step I am missing? Thank you. From Valeri 2013: The macro has been developed using SAS Version 9.2. In order to implement mediation analysis via the mediation macro in SAS the investigator first opens a new SAS session and inputs the data, which has to include the outcome, treatment and mediator variables as well as the covariates to be adjusted for in the model. Macro activation requires then the investigator to save the macro script and input information in the statement: %mediation(data= ,yvar= ,avar= ,mvar= ,cvar= ,a0= ,a1= ,m= ,nc= ,yreg= ,mreg= ,interaction=) run; So, I prepped my dataset and plugged in the values needed for the macro like this (values aren't important here, i just want to know how to ues this macro. %mediation(data=test, yvar=outcome, avar=exposure, mvar=med, cvar=cov, a0=0, a1=1, m=1, nc=1, yreg=logistic, mreg= logistic, interaction=false) run; Then, I get the following error: WARNING: Apparent invocation of macro MEDIATION not resolved. ERROR 180-322: Statement is not valid or it is used out of proper order. What am I doing wrong? Do I have to define the macro elsewhere? How does SAS know what to do with this macro? Thank you!

pamplemouse22 · ‎11-21-2016

Hi PG, I found one case when this doesn't work -- when the first visit is missing, and there are values for subsequent visits. Code ends up not pulling any value for new score, when it should. Can't figure out how to change this. Would appreciate a solution for this. Thank you in advance!

pamplemouse22 · ‎11-07-2016

Oh I see. Didn't think of calling up the macro variable in the Class statement. Will try. Thanks.

pamplemouse22 · ‎11-07-2016

Oh, good idea. This works! Thank you.

pamplemouse22 · ‎11-05-2016

Hi, I have a model I would like to run with with a series of independent and dependent variables. I have written a macro to do this. Some of the independent variables are categorical, thus, I included these variables in the class statement. However, I realized that putting unused variables in class statement limits sample for each analysis because the observations used in the regression are limited to those with values for all class statement variables. How can i fix this? Also, any suggestions to make code more efficient would be helpful. My list after %mend is VERY long. Thanks. code sample: %macro model(dep, indep); proc glm data=data1 ; class var2 (ref=first) indep1 (ref=first) indep2 (ref=first)indep3 (ref=first) indep4 (ref=first) indep5 (ref=first); model &dep= &indep var2 var3 var4/solution; run; %mend; %model(dep1, indep1); %model(dep1, indep2); %model(dep1, indep3); %model(dep1, indep4); %model(dep1, indep5); %model(dep2, indep1); %model(dep2, indep2); ..... Thanks in advance!

Online Status	Offline
Date Last Visited	‎06-21-2024 11:27 PM

Re: SAS programming statement in proc phreg

Re: SAS programming statement in proc phreg

Re: SAS programming statement in proc phreg

Re: SAS programming statement in proc phreg

Re: SAS programming statement in proc phreg

SAS programming statement in proc phreg

Re: Run data step on all files in directory

Re: Run data step on all files in directory

Re: Run data step on all files in directory

Re: Run data step on all files in directory

Re: Sum down a column using information from 2 unmerged datasets

Re: Sum down a column using information from 2 unmerged datasets

Re: Sum down a column using information from 2 unmerged datasets

Sum down a column using information from 2 unmerged datasets

Re: Add X days to each subsequent each row, by group

Re: Add X days to each subsequent each row, by group

Add X days to each subsequent each row, by group

Re: Invoke SAS Macro

Re: Invoke SAS Macro

Re: Invoke SAS Macro

Invoke SAS Macro

Re: How do I select value closest to X?

Re: linear regression macro - proc glm class statement - unused variab...

Re: linear regression macro - proc glm class statement - unused variab...

linear regression macro - proc glm class statement - unused variables