cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Amanda_Lemon
‎07-05-2024
  • 91 Posts
  • 11 Likes Given
  • 0 Solutions
  • 8 Likes Received

Re: Merging data sets

by Quartz | Level 8 in SAS Programming
‎09-12-2019 01:31 AM
‎09-12-2019 01:31 AM
I see! Thank you very much!! ... View more

Re: Merging data sets

by Quartz | Level 8 in SAS Programming
‎09-12-2019 01:22 AM
‎09-12-2019 01:22 AM
Yes! It works! Thank you!!! Just one question to make sure I understand the code -- what do these mean? n. r. order by 4, 1, 2, 3 ... View more

Re: Merging data sets

by Quartz | Level 8 in SAS Programming
‎09-12-2019 12:41 AM
‎09-12-2019 12:41 AM
Your code doesn't produce what I need... The output in the starting post is exactly want I need, yes.     Your code produced this output:    Obs ClassID TeacherID Replicate Stu_ID 1 1 1 1 1 2 1 1 2 1 3 2 1 3 1 4 3 2 1 1 5 4 2 2 1 6 4 2 3 1 7 1 1 1 2 8 1 1 2 2 9 2 1 3 2 10 3 2 1 2 11 4 2 2 2 12 4 2 3 2 13 1 1 1 3 14 1 1 2 3 15 2 1 3 3 16 3 2 1 3 17 4 2 2 3 18 4 2 3 3 19 1 1 1 4 20 1 1 2 4 21 2 1 3 4 22 3 2 1 4 23 4 2 2 4 24 4 2 3 4 25 1 1 1 5 26 1 1 2 5 27 2 1 3 5 28 3 2 1 5 29 4 2 2 5 30 4 2 3 5 31 1 1 1 6 32 1 1 2 6 33 2 1 3 6 34 3 2 1 6 35 4 2 2 6 36 4 2 3 6 37 1 1 1 7 38 1 1 2 7 39 2 1 3 7 40 3 2 1 7 41 4 2 2 7 42 4 2 3 7 43 1 1 1 8 44 1 1 2 8 45 2 1 3 8 46 3 2 1 8 47 4 2 2 8 48 4 2 3 8   But what I need is to add StudentID to each case (line) in Data set #2. So, if, say, a class had 3 students, then instead of one line from Data set #2 there will be three, and they will differ only in StudentID.    Thank you so much for helping! ... View more

Re: Merging data sets

by Quartz | Level 8 in SAS Programming
‎09-12-2019 12:10 AM
‎09-12-2019 12:10 AM
Nope...   Here is what I tried:    data new; input Stu_ID ClassID TeacherID; datalines; 1 1 1 2 1 1 3 2 1 4 2 1 5 3 2 6 4 2 7 4 2 8 4 2 ; data resampled; input ClassID TeacherID Replicate; datalines; 1 1 1 1 1 2 2 1 3 3 2 1 4 2 2 4 2 3 ; proc sort data = new; by ClassID TeacherID; run; proc sort data = resampled; by ClassID TeacherID; run; data merged; merge new resampled; by ClassID TeacherID; run; proc print data = merged; run; Here is what I got:    Obs Stu_ID ClassID TeacherID Replicate 1 1 1 1 1 2 2 1 1 2 3 3 2 1 3 4 4 2 1 3 5 5 3 2 1 6 6 4 2 2 7 7 4 2 3 8 8 4 2 3 ... View more

Merging data sets

by Quartz | Level 8 in SAS Programming
‎09-11-2019 11:57 PM
‎09-11-2019 11:57 PM
Hello,    I am trying to merge two data sets and so far unsuccessfully... I would appreciate any help!   Have: Data set #1 (students are nested within classes, which are in turn nested within teachers)   StudentID ClassID TeacherID  1 1 1 2 1 1 3 2 1 4 2 1 5 3 2 6 4 2 7 4 2 8 4 2   Data set #2: For this data set, 1 class per teacher was randomly selected from Data set #1, and the procedure was repeated 3 times.    ClassID TeacherID Replicate 1 1 1 1 1 2 2 1 3 3 2 1 4 2 2 4 2 3   Want: To add student data to Data set #2. So I need to repeat each row as many times as there are students in class, and add students' IDs.   StudentID ClassID TeacherID Replicate 1 1 1 1 2 1 1 1 1 1 1 2 2 1 1 2 3 2 1 3 4 2 1 3 5 3 2 1 6 4 2 2 7 4 2 2 8 4 2 2 6 4 2 3 7 4 2 3 8 4 2 3 ... View more

Multiple comparisons in repeated measures

by Quartz | Level 8 in Statistical Procedures
‎08-16-2019 05:11 AM
‎08-16-2019 05:11 AM
Hello -   I have a question about multiple comparisons in repeated measures. Specifically, I wanted to ask if in the example from the SAS documentation (see below) p-values are already adjusted for multiple comparisons, or if I need to apply adjustments myself (e.g., Bonferroni)?   proc mixed data=formixed; class Person Gender age; model y = Gender Age Gender*Age; repeated Age / type=un subject=Person; lsmeans Gender / pdiff; slice Gender*Age / sliceby=Age; slice Gender*Age / sliceby=Gender diff; run; http://support.sas.com/kb/22/905.html ... View more

Re: PROC SYSLIN and Hausman Test

by Quartz | Level 8 in SAS Programming
‎07-17-2019 03:51 AM
‎07-17-2019 03:51 AM
Hi Steve,    I am a little confused about one thing in your example (and in the example in the SAS documentation) -- why there are y1 and y2, and why do they switch places in the two equations?    As the topic starter, I am also trying to run the Hausman Test, and I am not sure how to write the syntax... I thought that with y, endogenous x, and say two instruments (z1 and z2), I should write the first stage first and then the second stage... Is it not right? Where do y1 and y2 come from?    proc model data = data; endo x; instruments z1 z2; y = b0 + b1*x; x = b00 + b2*z1 + b3*z2; fit y / ols 2sls hausman; run; ... View more

Error running CFA with cross-loadings

by Quartz | Level 8 in Statistical Procedures
‎07-14-2019 08:52 PM
‎07-14-2019 08:52 PM
Hi all,    I am trying to run a two-factor CFA model where all items cross-load.    proc calis data = data modification; lineqs V1 = L11 F1 + L12 F2 + eV1, V2 = L21 F1 + L22 F2 + eV2, V3 = L31 F1 + L32 F2 + eV3, V4 = L41 F1 + L42 F2 + eV4, V5 = L51 F1 + L52 F2 + eV5, V6 = L61 F1 + L62 F2 + eV6, V7 = L71 F1 + L72 F2 + eV7, V8 = L81 F1 + L82 F2 + eV8, V9 = L91 F1 + L92 F2 + eV9, V10 = L101 + L102 F2 + eV10; variance F1 = 1, F2 = 1, eV1 - eV10 = vareV1 - vareV10; var V1 - V10; run;   However, I get the following error message:  "NOTE: The Moore-Penrose inverse is used in computing the covariance matrix for parameter estimates. WARNING: Standard errors and t values might not be accurate with the use of the Moore-Penrose inverse. WARNING: Lagrange multiplier statistics and Wald statistics might not be accurate with the use of the Moore-Penrose inverse in computing the covariance matrix for parameter estimates."   Why does it happen?  ... View more

Re: Simulating nested data

by Quartz | Level 8 in New SAS User
‎03-17-2019 07:34 PM
‎03-17-2019 07:34 PM
Got it! Thank you. The problem is solved -- I just needed to move the SET statement inside the first loop.  ... View more

Re: Simulating nested data

by Quartz | Level 8 in New SAS User
‎03-17-2019 06:41 PM
‎03-17-2019 06:41 PM
Thank you! So, as far as I understood, examples in this section use parameters obtained from the analysis of real data. But I have actual data that I want to use in the simulation rather than parameters. So, in other words, I want to import Level-2 variable values and simulate Level-1 variable values. You mentioned that the problem might be in the SET statement -- is there another way to import values (especially if there are many observations, like 2000)?  ... View more

Re: Simulating nested data

by Quartz | Level 8 in New SAS User
‎03-17-2019 05:59 PM
‎03-17-2019 05:59 PM
Well, that's the thing -- there is no error, there is quite literally nothing... Seems that it's just running without any result. So I need to force SAS to close and then open it again.    The online version of the book, provided by my university's library, doesn't have page numbers... Do you mind noting the section/subsection number that you were referring to?    Thank you again for your help.  ... View more

Re: Simulating nested data

by Quartz | Level 8 in New SAS User
‎03-16-2019 10:40 PM
‎03-16-2019 10:40 PM
@Rick_SAS, thank you so much! Understood. Yes, W should be a fixed effect.    I ran into a different problem now... Instead of simulating the level-2 variable W, I wanted to import values of this variable from an existing data set. But the program won't run... Why is that? I also tried to put W values into an array first but that didn't work either...   %let mu = 0; /* intercept, or overall mean */ %let tau = 15; /* variance of random intercept */ %let sigma = 45; /* error variance */ %let N1 = 300; /* number of level 1 units per level 2 unit */ %let b = 0.3; /* effect of W */ %let nsamples = 2; /* number of simulated samples */ data power; call streaminit(123456); set my_set; /* this set has W (200 values) */ do j = 1 to 200; rand_int = rand('Normal', 0, sqrt(&tau)); do sampleID = 1 to &nsamples; do i = 1 to &N1; rand_e = rand('Normal', 0, sqrt(&sigma)); Y = &mu + &b * W + rand_int + rand_e; output; end; end; end; run;   ... View more

Re: Simulating nested data

by Quartz | Level 8 in New SAS User
‎03-08-2019 05:35 PM
‎03-08-2019 05:35 PM
@Rick_SAS, thank you! I tried to adapt the code from your book. Did I do it right? Does this code simulate the model I described in the first post? U think it does but just want to double check... The end goal is to run a power analysis. Thanks again!   %let mu = 0; /* intercept, or overall mean */ %let tau = 15; /* random intercept variance */ %let sigma = 45; /* error variance */ %let N2 = 200; /* number of level 2 units */ %let N1 = 30; /* number of level 1 units per level 2 unit */ %let b = 0.2; /* effect of W */ %let nsamples = 1000; /* number of simulated samples */ data power; call streaminit(123456); do sampleID = 1 to &nsamples; do j = 1 to &N2; rand_int = rand('Normal', 0, sqrt(&tau)); W = rand('Normal', 0, 1); do i = 1 to &N1; rand_e = rand('Normal', 0, sqrt(&sigma)); Y = &mu + &b * W + rand_int + rand_e; output; end; end; end; run; ... View more

Re: Simulating nested data

by Quartz | Level 8 in New SAS User
‎03-06-2019 06:45 PM
‎03-06-2019 06:45 PM
@Rick_SAS, maybe you have some hints for me about how to simulate this model? Thank you in advance! ... View more

Re: Simulating nested data

by Quartz | Level 8 in New SAS User
‎03-06-2019 12:44 AM
‎03-06-2019 12:44 AM
I found a code in the "SAS for mixed models" book by Littell, 2006 (Section 12.5) -- is it allowed to copy-paste code from a book? Anyway, it has more variance parameters than I need and does not have numbers of units. So I wasn't sure how to modify that code for my purpose.    W would be just a normally distributed variable (so, a normal distribution of j cases). ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-05-2024 03:42 PM
Quick links