Ron Cody shows this bit of code on his blog and Tom has a similar example in another reply. data New; set Original; array Nums[*] _numeric_; array Chars[*] _character_; do i = 1 to dim(Nums); if Nums[i] = 999 then Nums[i] = .; end; do i = 1 to dim(Chars); Chars[i] = upcase(Chars[i]); end; drop i; run; My specifics are a little simpler. * recode '.', '.p', '.s' to -99 for all variables; data par_teen1; set par_teen; array md{*} _numeric_; do i=1 to dim{md}; if (md{i} eq .p) then md{i}=-99; end; run; This is the result. 417 * recode '.', '.p', '.s' to -99 for all variables; 418 data par_teen1; set par_teen; 419 array md{*} _numeric_; 420 do i=1 to dim{md}; ERROR: Undeclared array referenced: dim. ERROR: Illegal reference to the array md. ERROR: Variable dim has not been declared as an array. 421 if (md{i} eq .p) then md{i}=-99; 422 end; 423 run; I've verified by inspection that the type of all vars (~170) are Num. I'm doing something wrong; tell me what it is. Thank you. ... View more

Exactly what the subject line says. Given, for example, a correlation matrix of y1-y6 in text format, read it into sas and use that matrix as input to proc corr to compute the reliability of the scale defined by y1-y6. ... View more

This may not the right forum. Anyway, i running some very simple proc mixed (multilevel) models and specifying influence statistics. for example: ods graphics on; title 'var on age rise*age No outliers'; proc mixed data=no_outs; model var_rise=rise_rev agecenX rise_rev*agecenX/ solution influence residual outp=var_ageint_no; random Intercept/type=vc subject=evq_id; run; ods graphics off; Runs fine, no errors. Now the problem. I've learned that i can save the output (results) and show it to others later; it's just html; opens in any browser. So i do the same thing here and  look at the saved output. I'm stunned: all the plots are GONE and replaced by little colored squares in the upper left. I want to show that output and it's going to be looked at on a computer that does not have sas installed. AND even if sas were on that computer and i open an output file through sas those plots are still gone! Let's say i don't know enough to know what to do. What do i do? Thanks. ... View more

I am doing multilevel analyses using beta regression because my dependent variable is a proportion. The range of proportion values includes 0 and 1; however, prior to analysis 0 was recoded to 0.005 and 1 was recoded to 0.995. Most of the analyses executed without error but four did not. The attached file shows the syntax for each analysis and the noted error (the same for three of the four analyses). As this my first experience with beta regression, please pitch your reply to the level of somebody with no experience with beta regression and an incomplete understanding of all glimmix options and keywords and their possible interactions. A low level slow walk would be appreciated. Thanks Gene Maguin ... View more

Q1: I have a dataset that has become disordered in the sense that items from a given measure/scale have become scattered across the dataset. I want to re-order the dataset so that common items are grouped together and within the group are ordered sequentially. I had asked about this previously and after some discussion among persons replying the recommendation was to use a retain statement.(Why re-order? Because i need to something with all variables associated with a scale or group of scales and i can define an array referencing all variables in the dataset and for a given scale(s) operate on those items by using element range in the Do statement.) So (from the log):   17 * reorganize the dataset to bring all items in a measure together; 18 * group measures together into an AOD group, dsa1 group, and an all group; 19 data work5; 20 retain Year--Ddr2 Dalc5a--Dalc5f Dyaq1-Dyaq9 Ddmq1-Ddmq12 ERROR: Variable Year cannot be found on the list of previously defined variables. ERROR: Variable Dalc5a cannot be found on the list of previously defined variables. 21 Dsa1-Dsa13 Drr1-Drr31 Dcs1-Dcs15 Dcs16 Dsbi1-Dsbi47 22 Doa1-Doa40 Dnsa1--Dnsa15 Dncs1-Dncs16 Dnsb1-Dnsb47 ERROR: Variable Dnsa1 cannot be found on the list of previously defined variables. 23 Dmood--Dmis4 Dass1--Dass16 Dass17 Dpb1-Dpb19 DCovid1-DCovid6 DCovid7 ERROR: Variable Dmood cannot be found on the list of previously defined variables. ERROR: Variable Dass1 cannot be found on the list of previously defined variables. 24 Dscsev Dscs1-Dscs6 DcovSt1-DcovSt4; 25 drop i dot YB miss1-miss10 j; 26 set PNA.CleanFile; 27 run;   Each of the variables identified as "cannot be found" are very definitely in the set dataset PNA.CleanFile. What am i doing wrong and how do i correct it?   Q2: How do i find questions i have previously submitted (and replies to those questions)?         ... View more