That is very strange. I have all the data, there a just some missing but not one in each row. Just a very few are missing...   Thank you again. I hope I will somehow finger it out. ... View more

One more question:   I just run your code again and there are no errors anymore (I assume I didn't run it correct before).   There is some data missing, but not the one I use for my mixed model. Could this be the problem? What percentage of data per variable do you need that it runs correctly? ... View more

Okay.   Thank you a lot for your help! ... View more

There are no Errors until I typed in the code to set up the mixed model I send you previously. As soon as I run it, I get the following LOG:   ERROR: No valid observations are present. WARNING: Output 'SolutionF' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. ... View more

----> My code was:   /* Library setup */ libname CC '/folders/myfolders'; options fmtsearch=(CC.formats); OPTIONS nofmterr; /* ---------------------------------------- */ /* ------- LOAD DATA FILES INTO SAS ------- */ /* ---------------------------------------- */ /* Build data tables*/ PROC IMPORT OUT= CC.CC_EigenvalueMeasures DATAFILE= "/folders/myfolders/CC_EigenvalueMeasures.csv" DBMS=csv REPLACE; GETNAMES=YES; GUESSINGROWS=MAX; DATAROW=2; RUN; /* ---------------------------------------- */ /* ----------- DATA DICTIONARIES ---------- */ /* ---------------------------------------- */ /* Data Dictionaries */ ods rtf file='/folders/myfolders/CC/Dictionary1.doc'; proc contents data=CC.CC_EigenvalueMeasures varnum; run; ods rtf close; /* Create work files */ data CC_EigenvalueMeasures_Work; set CC.CC_EigenvalueMeasures; run; /* ---------------------------------------------- */ /* ------------- ANALYSIS ----------------------- */ /* ---------------------------------------------- */ /* ---- Analysis for all Subjects ----*/ data WorkingData_CC_all; set CC_EigenvalueMeasures_Work; run; /* ---- Analysis for men only ----*/ data WorkingData_CC_men; set CC_EigenvalueMeasures_Work; if StartAge=. then delete; run; /* --------------------------------------------------------------------------- */ /* --------- START PROC MIXED ANALYSES FOR CC ---------------- */ /* --------------------------------------------------------------------------- */ /* Set up long format for CC ?? */ data CC_long; length Measure $26; set CC_EigenvalueMeasures_Work; outcome=CCI_MidEV;measure='CCI_MidEV';output; outcome=CCI_MaxEV;measure='CCI_MaxEV';output; outcome=CCII_MidEV;measure='CCII_MidEV';output; outcome=CCII_MaxEV;measure='CCII_MaxEV';output; drop CCI_MidEV CCI_MaxEV CCII_MidEV CCII_MaxEV; run;   ----> Following the Code you gave me:   %let tableName = CC_long; *create format for missing; proc format ; value $ missfmt ' '="Missing" other="Not Missing"; value nmissfmt .="Missing" other="Not Missing"; run; *Proc freq to count missing/non missing; ods table onewayfreqs=temp; proc freq data=&tableName.; table _all_ / missing; format _numeric_ nmissfmt. _character_ $missfmt.; run; *Format output; data long; length variable $32. variable_value $50.; set temp; Variable=scan(table, 2); Variable_Value=strip(trim(vvaluex(variable))); presentation=catt(frequency, " (", trim(put(percent/100, percent7.1)), ")"); keep variable variable_value frequency percent cum: presentation; label variable='Variable' variable_value='Variable Value'; run; proc sort data=long; by variable; run; proc transpose data=long out=want; by variable; id variable_value; var presentation; run;   Yes, I had checked the data. All is there.  ... View more

Thank you, now the code works.   When I run in I get 3 new errors:   ERROR: File WORK.CC_LONG.DATA doesn't exist. ERROR: No data set open to look up variables. ERROR: File WORK.TEMP.DATA doesn't exist.   This is how I created the long file:   data CC_long; length Measure $26; set CC_EigenvalueMeasures_Work; outcome=CCI_MidEV;measure='CCI_tens1_MidEV';output; outcome=CCI_MaxEV;measure='CCI_tens1_MaxEV';output; outcome=CCII_MidEV;measure='CCII_tens1_MidEV';output; outcome=CCII_MaxEV;measure='CCII_tens1_MaxEV';output; drop CCI_MidEV CCI_MaxEV CCII_MidEV CCII_MaxEV; run; ... View more

My code was:   ods output SolutionF=deftotal; proc mixed data=CC_long convf=0.001 ; class Measure SubjectID; model outcome=deftotal*Measure Age*Measure MaskVol*Measure /solution; run;   Could you explain me with what file I should replace tableName?  ... View more

Thank you for your answer! Very appreciate that!   I just saw that there appear 100 rows, but I only filled 86 rows with data. That might be the problem! How can I cancel line 87 - 100? ... View more