fatemeh Tracker
https://communities.sas.com/kntur85557/tracker
fatemeh TrackerMon, 12 Aug 2024 19:17:15 GMT2024-08-12T19:17:15ZHow sas can read sas dataset that is saved as data.sas in sas studio
https://communities.sas.com/t5/SAS-Studio/How-sas-can-read-sas-dataset-that-is-saved-as-data-sas-in-sas/m-p/833706#M10525
<P>Hello all,</P><P>Any help is appreciated to find the answer to my question:</P><P>How sas can read sas dataset that is saved in a folder in sas studio, for example mydata.sas. I uploaded a sas dataset that was saved on my desktop as sas dataset with the name mydata , then when i upload that in to sas studio, it was saved as mydata.sas , so how to read it and work on it?</P>Thu, 15 Sep 2022 18:40:06 GMThttps://communities.sas.com/t5/SAS-Studio/How-sas-can-read-sas-dataset-that-is-saved-as-data-sas-in-sas/m-p/833706#M10525fatemeh2022-09-15T18:40:06Zsas base
https://communities.sas.com/t5/SAS-Programming/sas-base/m-p/809199#M319081
<P>Hello. I appreciate you help me find answer for the bellow question:</P><P> </P><P>What statement removes the library reference from excel workbook?</P>Fri, 22 Apr 2022 05:16:38 GMThttps://communities.sas.com/t5/SAS-Programming/sas-base/m-p/809199#M319081fatemeh2022-04-22T05:16:38ZRe: ods rtf
https://communities.sas.com/t5/Statistical-Procedures/ods-rtf/m-p/761542#M37164
<P>Thank you so much for your valuable reply</P>Sat, 14 Aug 2021 05:21:17 GMThttps://communities.sas.com/t5/Statistical-Procedures/ods-rtf/m-p/761542#M37164fatemeh2021-08-14T05:21:17Zods rtf
https://communities.sas.com/t5/Statistical-Procedures/ods-rtf/m-p/761536#M37162
<P>Hello, I am using sas 9.4 and I appreciate you all to help me solve these issues:</P><P>1) The rtf file is not opening in word file by default. I want the rtf file opens in word file by default.</P><P>2) only first title is printed in rtf file, the second title is not printed</P><P> </P><PRE><CODE class=" language-sas">ods rtf on ;
ods html close;
ods graphics on;
ods rtf file="myfilelocation\filename.rtf "style=sasweb startpage=no bodytitle;
title1'title1 ';
proc print data=data1;run;
title2'title2';
proc print data=data2;run;
title'';
ods startpage=yes;
ods rtf close;
ods html ;
</CODE></PRE><P> </P>Sat, 14 Aug 2021 03:18:59 GMThttps://communities.sas.com/t5/Statistical-Procedures/ods-rtf/m-p/761536#M37162fatemeh2021-08-14T03:18:59ZRe: proc mixed assumption
https://communities.sas.com/t5/Statistical-Procedures/proc-mixed-assumption/m-p/757593#M36868
<P>Thanks a lot for your valuable responses,</P><P>My data is multilevel longitudinal repeated measures over time which is not growth data (is not longitudinal growth data) as i understood response variable does not need to be normally distributed, so if i apply glimmix and my response does not look normal how can i find what distribution should i select in dist section of model statement in proc glimmix?</P>Wed, 28 Jul 2021 06:14:12 GMThttps://communities.sas.com/t5/Statistical-Procedures/proc-mixed-assumption/m-p/757593#M36868fatemeh2021-07-28T06:14:12ZRe: generalized linear mixed model 'proc glimmix'
https://communities.sas.com/t5/Statistical-Procedures/generalized-linear-mixed-model-proc-glimmix/m-p/757592#M36867
<P>Thank you all for your brilliant thoughts and responses,<BR />according to this article " <A href="https://blogs.sas.com/content/iml/2018/08/27/on-the-assumptions-and-misconceptions-of-linear-regression.html" target="_blank">https://blogs.sas.com/content/iml/2018/08/27/on-the-assumptions-and-misconceptions-of-linear-regression.html</A> " ,<STRONG>The variables in a least squares regression model do not have to be normally distributed</STRONG>. Do the variables here mean independent variables and dependent variable ( response )? Dose this rule apply to mixed model( proc mixed and proc glimmix ) also, since mixed model is multilevel regression lines but estimation method can be maximum likelihood or (restricted) maximum likelihood?</P><P> </P>Wed, 28 Jul 2021 06:08:21 GMThttps://communities.sas.com/t5/Statistical-Procedures/generalized-linear-mixed-model-proc-glimmix/m-p/757592#M36867fatemeh2021-07-28T06:08:21Zgeneralized linear mixed model 'proc glimmix'
https://communities.sas.com/t5/Statistical-Procedures/generalized-linear-mixed-model-proc-glimmix/m-p/756776#M36850
<P>Hello,</P><P>I appreciate for any guidance that help me understand how to check the unconditional (marginal) distribution which is assumed to be known for maximum likelihood estimation in generalized linear mixed model (proc glimmix) for multilevel repeated measures data with random effect. If I'm right one assumption for proc glimmix is that the random effect variables should follow normal distribution, so does the variable that has random effect play the <SPAN style="font-family: inherit;">role of </SPAN><SPAN style="font-family: inherit;">(marginal) distribution ? Is there any article or any source that explains how to check the </SPAN>normality of marginal distribution and <SPAN style="font-family: inherit;">assumptions in proc glimmix and what is the concept of marginal distribution in generalized linear mixed model ?</SPAN></P>Tue, 27 Jul 2021 05:11:51 GMThttps://communities.sas.com/t5/Statistical-Procedures/generalized-linear-mixed-model-proc-glimmix/m-p/756776#M36850fatemeh2021-07-27T05:11:51ZRe: proc mixed assumption
https://communities.sas.com/t5/Statistical-Procedures/proc-mixed-assumption/m-p/755686#M36800
Thanks for your reply. But because the observations are repeated measures so they are correlated, should the errors be dependent?Wed, 21 Jul 2021 16:14:21 GMThttps://communities.sas.com/t5/Statistical-Procedures/proc-mixed-assumption/m-p/755686#M36800fatemeh2021-07-21T16:14:21Zproc mixed assumption
https://communities.sas.com/t5/Statistical-Procedures/proc-mixed-assumption/m-p/755666#M36798
<P>Hello all,</P><P>Any help will be appreciated to help me find a solution for my problem.</P><P>My question is that if we apply proc mixed to find model for multilevel repeated measures while the response variable does not have normal distribution, will the estimates be biased? if yes how can i solve the issue? How can i find out what distribution my response has other than histogram? If my response has exponential or other distribution, how can i find the right distribution?</P>Wed, 21 Jul 2021 15:36:40 GMThttps://communities.sas.com/t5/Statistical-Procedures/proc-mixed-assumption/m-p/755666#M36798fatemeh2021-07-21T15:36:40Zintercept in random statement in proc mixed
https://communities.sas.com/t5/Statistical-Procedures/intercept-in-random-statement-in-proc-mixed/m-p/732364#M35544
<P>Hello all,</P><P>I appreciate for any guide that helps me understand the concept of intercept in random statement in proc mixed?</P>Fri, 09 Apr 2021 02:42:57 GMThttps://communities.sas.com/t5/Statistical-Procedures/intercept-in-random-statement-in-proc-mixed/m-p/732364#M35544fatemeh2021-04-09T02:42:57ZRe: R block diagonal matrix
https://communities.sas.com/t5/Statistical-Procedures/R-block-diagonal-matrix/m-p/732356#M35542
<P>Thanks for your reply, you pointed at the levels of variables in class statement and it helped me to find out the answer.</P>Thu, 08 Apr 2021 21:38:32 GMThttps://communities.sas.com/t5/Statistical-Procedures/R-block-diagonal-matrix/m-p/732356#M35542fatemeh2021-04-08T21:38:32ZR block diagonal matrix
https://communities.sas.com/t5/Statistical-Procedures/R-block-diagonal-matrix/m-p/732236#M35539
<P>hello all,</P><P>I want to get R block matrix for some specific subjects by specifying in the R section in repeated statement in proc mixed, all the matrixes are the same unstructured matrix, but the explanation on top of them are for another subjects which are for subjects19, 20, 21, 22, 23 and 24,while R matrix should be given for subjects 13, 14, 15, 16, 17 and 18, i do not know the reason? Any help will be appreciated to understand the reason.</P><PRE><CODE class=" language-sas">repeated day / subject=subjects*week*trt type=UN r=13,14,15,16,17,18;
run;</CODE></PRE><P> </P>Thu, 08 Apr 2021 18:07:56 GMThttps://communities.sas.com/t5/Statistical-Procedures/R-block-diagonal-matrix/m-p/732236#M35539fatemeh2021-04-08T18:07:56ZV matrix and Z matrix in mixed model
https://communities.sas.com/t5/Statistical-Procedures/V-matrix-and-Z-matrix-in-mixed-model/m-p/731173#M35456
<P>Hello all,</P><P>I am looking for a source, an article or a book with examples that give me interpretation of <STRONG>V</STRONG> matrix and <STRONG>Z</STRONG> matrix in <STRONG>V=ZGZ'+R </STRONG>in mixed model with repeated measure, fixed and random effects. Any help will be appreciated. </P>Sat, 03 Apr 2021 21:08:15 GMThttps://communities.sas.com/t5/Statistical-Procedures/V-matrix-and-Z-matrix-in-mixed-model/m-p/731173#M35456fatemeh2021-04-03T21:08:15Zdetect outliers using macro function
https://communities.sas.com/t5/Statistical-Procedures/detect-outliers-using-macro-function/m-p/724302#M35110
<P>Hello all,</P><P>Any help will be appreciated, below is the macro function sas code to <SPAN style="font-family: inherit;">detect outliers :</SPAN><CODE class=" language-sas"> </CODE></P><OL><LI> I do not understand these sections: "<CODE class=" language-sas"> Q1 = &Q1 &val._P25;","<CODE class=" language-sas"> varL = &varL &val.L;</CODE>", </CODE><SPAN style="font-family: inherit;">what sections in sas documentation explain theses parts</SPAN><CODE class=" language-sas"> ?</CODE></LI><LI> How can i detect outliers using this macro function?</LI><LI>How can i change the lower and upper limit to 10percentile and 90percentile?</LI><LI>How can i get only outliers that are larger than 90percentile?</LI></OL><PRE><CODE class=" language-sas">%macro outliers(input=, var=, output= );
%let Q1=;
%let Q3=;
%let varL=;
%let varH=;
%let n=%sysfunc(countw(&var));
%do i= 1 %to &n;
%let val = %scan(&var,&i);
%let <FONT color="#000000">Q1 = &Q1 &val._P25</FONT>;
%let Q3 = &Q3 &val._P75;
%let varL = &varL &val.L;
%let varH = &varH &val.H;
%end;
/* Calculate the quartiles and inter-quartile range using proc univariate */
proc means data=&input nway noprint;
var &var;
output out=temp P25= P75= / autoname;
run;
/* Extract the upper and lower limits into macro variables */
data temp;
set temp;
ID = 1;
array varb(&n) &Q1;
array varc(&n) &Q3;
array lower(&n) &varL;
array upper(&n) &varH;
do i = 1 to dim(varb);
lower(i) = varb(i) - 3 * (varc(i) - varb(i));
upper(i) = varc(i) + 3 * (varc(i) - varb(i));
end;
drop i _type_ _freq_;
run;
data temp1;
set &input;
ID = 1;
run;
data &output;
merge temp1 temp;
by ID;
array var(&n) &var;
array lower(&n) &varL;
array upper(&n) &varH;
do i = 1 to dim(var);
if not missing(var(i)) then do;
if var(i) >= lower(i) and var(i) <= upper(i);
end;
end;
drop &Q1 &Q3 &varL &varH ID i;
run;
%mend;</CODE></PRE><P> </P>Sun, 07 Mar 2021 20:23:18 GMThttps://communities.sas.com/t5/Statistical-Procedures/detect-outliers-using-macro-function/m-p/724302#M35110fatemeh2021-03-07T20:23:18Zfrequency table when you have many variables
https://communities.sas.com/t5/Statistical-Procedures/frequency-table-when-you-have-many-variables/m-p/723339#M35064
<P>Hello all,</P><P>Appreciate you helping me find a way to get two by two frequency table apply proc freq. I have many categorical variables, it is time consuming to enter all variables two by two.</P><P> </P>Thu, 04 Mar 2021 01:32:16 GMThttps://communities.sas.com/t5/Statistical-Procedures/frequency-table-when-you-have-many-variables/m-p/723339#M35064fatemeh2021-03-04T01:32:16ZRandom statement in mixed model for repeated measures
https://communities.sas.com/t5/Statistical-Procedures/Random-statement-in-mixed-model-for-repeated-measures/m-p/723091#M35054
<P>Hello all,</P><P>I appreciate you to help me understand what is the difference between these two models. In the first model, in random statement trt1 and trt2 are entered, while in the second model it is empty. (these codes and data are from sas tutorial video)<CODE class=" language-sas"> </CODE></P><P><CODE class=" language-sas"></CODE><CODE class=" language-sas"><BR /><BR /></CODE></P><PRE><CODE class=" language-sas">proc mixed data=test;
class patient trt1 trt2 time;
model resp=trt1 trt2 trt1*trt2 time;
random int trt1 trt2 / subject=patient;
repeated time/ subject=patient*trt1*trt2 type=ar(1);
run;</CODE></PRE><PRE><CODE class=" language-sas">proc mixed data=test;
class patient trt1 trt2 time;
model resp=trt1 trt2 trt1*trt2 time;
random int / subject=patient;
repeated time/ subject=patient*trt1*trt2 type=ar(1);
run;</CODE></PRE><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>patient</TD><TD>trt1</TD><TD>trt2</TD><TD>time</TD><TD>resp</TD></TR><TR><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>4.3</TD></TR><TR><TD>1</TD><TD>1</TD><TD>1</TD><TD>2</TD><TD>3.8</TD></TR><TR><TD>1</TD><TD>1</TD><TD>1</TD><TD>3</TD><TD>3.1</TD></TR><TR><TD>1</TD><TD>1</TD><TD>1</TD><TD>4</TD><TD>2.7</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD>1</TD><TD>4.3</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>3.4</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD>3</TD><TD>3.2</TD></TR><TR><TD>1</TD><TD>1</TD><TD>2</TD><TD>4</TD><TD>3.5</TD></TR><TR><TD>1</TD><TD>2</TD><TD>1</TD><TD>1</TD><TD>3</TD></TR><TR><TD>1</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>3.3</TD></TR><TR><TD>1</TD><TD>2</TD><TD>1</TD><TD>3</TD><TD>2.5</TD></TR><TR><TD>1</TD><TD>2</TD><TD>1</TD><TD>4</TD><TD>3.4</TD></TR><TR><TD>1</TD><TD>2</TD><TD>2</TD><TD>1</TD><TD>3.3</TD></TR><TR><TD>1</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>3.2</TD></TR><TR><TD>1</TD><TD>2</TD><TD>2</TD><TD>3</TD><TD>3</TD></TR><TR><TD>1</TD><TD>2</TD><TD>2</TD><TD>4</TD><TD>3.2</TD></TR></TBODY></TABLE><P> </P>Wed, 03 Mar 2021 08:28:22 GMThttps://communities.sas.com/t5/Statistical-Procedures/Random-statement-in-mixed-model-for-repeated-measures/m-p/723091#M35054fatemeh2021-03-03T08:28:22ZRe: covariates selection and multicollinearity in repeated measures applying proc mixed
https://communities.sas.com/t5/Statistical-Procedures/covariates-selection-and-multicollinearity-in-repeated-measures/m-p/722728#M35026
<P>Thank you for your reply. I found this article related to this topic, "User-friendly SASĀ® Macro Application for performing all possible mixed model selection - An update", but i can not download the ALLMIXED2 .SAS macro-call file from the authors website at "<A href="http://www.ag.unr.edu/gf" target="_blank">http://www.ag.unr.edu/gf</A>". Any help will be appreciated to help me find access to ALLMIXED2 in sas 9.4.</P><P> </P>Mon, 01 Mar 2021 22:33:22 GMThttps://communities.sas.com/t5/Statistical-Procedures/covariates-selection-and-multicollinearity-in-repeated-measures/m-p/722728#M35026fatemeh2021-03-01T22:33:22Zcovariates selection and multicollinearity in repeated measures applying proc mixed
https://communities.sas.com/t5/Statistical-Procedures/covariates-selection-and-multicollinearity-in-repeated-measures/m-p/722690#M35021
<P>Hello all,</P><P>I really appreciate you to help me find a way to check for covariates selection and multicollinearity like VIF or any other way in repeated measures applying proc mixed with fixed effects and two repeated effects in sas9.4.</P>Mon, 01 Mar 2021 21:57:04 GMThttps://communities.sas.com/t5/Statistical-Procedures/covariates-selection-and-multicollinearity-in-repeated-measures/m-p/722690#M35021fatemeh2021-03-01T21:57:04ZRe: Detect extreme values through leverage and outlier via robust regression
https://communities.sas.com/t5/Statistical-Procedures/Detect-extreme-values-through-leverage-and-outlier-changing/m-p/720655#M34892
<P>Hello,</P><P>I really appreciate you to help me find answer to my questions. Another question i have is that, how to find only high extreme leverages or only low extreme leverages when we apply robust regression and MCD algorithm? Because leverage data contain extreme low and extreme high data points, is it correct way to find those leverages that have at least one value larger than for example 85 percentile (or what percentile is appropriate?), that way we can get leverages that are extreme high data points ? or is there another standard way to find that?</P>Sat, 20 Feb 2021 18:09:49 GMThttps://communities.sas.com/t5/Statistical-Procedures/Detect-extreme-values-through-leverage-and-outlier-changing/m-p/720655#M34892fatemeh2021-02-20T18:09:49Zvalues less than 60 percentile
https://communities.sas.com/t5/Statistical-Procedures/values-less-than-60-percentile/m-p/718088#M34716
<P>Hello all,</P><P>I am applying proc univariate to find 60th percentile for each variable, i want to find those observations that have at least 3 values less than 60th percentile, how can i modify the dataset sub? appreciate for any help. </P><PRE><CODE class=" language-sas">proc univariate data=mydata ;
VAR v1 v2 v3 v4 ;
output out=output1 pctlpts = 60
pctlpre = v1 v2 v3 v4
pctlname = _60 ;
run;
data sub;
if _n_ eq 1 then set output1;
set mydata;
if
v1=<v1_60 or v2=<v2_60 or v3=<v3_60 or v4=<v4_60 ;
run;</CODE></PRE>Wed, 10 Feb 2021 01:31:46 GMThttps://communities.sas.com/t5/Statistical-Procedures/values-less-than-60-percentile/m-p/718088#M34716fatemeh2021-02-10T01:31:46Z