I don't know that this is right location for my problem. Perhaps the list admins can move to a better list. I'm a sas user and my computer was upgraded to win 10, software reinstalled, etc, etc. Now, however when i start sas i get this message NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session. I used to have a (very short) list of recently used files. Not now, they're gone when i  restart sas. I pretty sure this is not something i can fix, even if i knew how. So who controls this user profile? Who do you think i should talk to in the heirarchy to get one back: Local IT, who did the sas install? University (central) IT? Thanks, Gene Maguin         ... View more

this is a stored-up list. 1) Somewhere, i've seen that it is possible get rid of that centered output and have left justified output in the results viewer window. What was showed was the specific command that went in the syntax file. Stumbling around, i found a directory or file called options. I'm looking for a permanent fix. Do modify the options file? What option name and how done? 2) Today, i wanted to write out a text data file. In spss i'd say write outfile='path string' var list (optional Fortran-type format specification). Nice and simple and highly controllable. I see in Cody's book how to export an excel file. Mplus, the receiving program, takes only text files. In SAS, how would i write out a text data file and, if desired, control variable formats and new lines. For example: recid y1-y50 (f4.0,2x,25f3.0/6x,25f3.0). 3) I want to export a set of frequency tables to a dataset. Based on Cody's book I used this 52 ods output bprawfreqs=OneWayFreq; 53 proc freq data=pbitems; tables dpb4-dpb16; run; WARNING: Output 'bprawfreqs' 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. So. i believe the object name is correct because i did and ODS Trace command. I assume that the file (bprawfreqs is just a sas data set and it's location is controlled by the active lib statement (Correct or not?) I read the documentation for proc freq and see that there is an "out' subcommand for a table statement. However, as i understand the documentation what is written out to the named dataset is only the last named frequency/crosstab table in the table subcommand. That's useless and it's hard to believe that is true. 4) I want  to come back to the output export problem. Recently i was running GEE models Working through the iterations of IV variable combinations, i had a list of 26 or 27 and I had to run each combination with two different DVs. The PIs requested that i summarize the results and what they wanted to see the coefficients and their significance values. (I want to say something to head off Proc Report: The coefficients and their significance are looked at and discussed, decisions are made, and the syntax and mht files could be deleted because they served their function).  In spss i could say OMS "analysis type" select if table="coefficients" ahead of the first GEE model and OMS End after the last one. In Cody i read that i can specify ods select >object< (persist); and that will do what i want. True? That does it for now. Thanks.                 ... View more

Yeah, i bet you hear this a lot from spss users also using sas. I'm going to assume that when i say spss variable labels and value labels commands you know what i mean in terms of their functions. After looking at Ron Cody's book, I thought the sas label function and the proc format would give me what i want but they are useless. You run variables singly and/or in combination through proc freq and then put the mht file up for viewing by people who are just one step (the PIs), let alone two or three steps (pre and post docs and project staff) removed from the analyst and the output is not understandable without each person having a data dictionary in front of them. I'm sure you've heard this many times before but is there a solution? Thanks, Gene Maguin   ... View more

I'm running a gee model and getting a NPD Hessian problem. These two models run ok. I have 174 clusters and 1766 records. * model A3; proc gee data=couse.co_usevars; class studyid; model couse1=dsa3A1_234 / dist=binary ; repeated subject=studyid / modelse corr=exch; run; * model B1; proc gee data=couse.co_usevars; class studyid; model couse1=dothruse0_12 dothruse1_2 / dist=binary; repeated subject=studyid / modelse corr=exch; run; This one does not. * model B2; proc gee data=couse.co_usevars; class studyid; model couse1=dothruse0_12 dothruse1_2 dsa3A1_234/ dist=binary; repeated subject=studyid / modelse corr=exch; run; As you see, i specified an exchangeable corr structure. If I change to either an independent or unstructured structure, the model estimates. The fit (QIC) is better (smaller) with corr=ind than with corr=un, which seems understandable--kind of. However, on one of the prior models that ran using corr=exch the corr estimate was .26, which suggests to me that corr=ind is not a reasonable assumption.   I know that an NPD problem means that the determinant of the second derivative matrix is not greater than zero. What i don't know is if there is any way locate the problem. Can anyone provide and information and/or guidance? I understand this isn't a sas problem; it's a data+model problem so there may be nothing that can be done. However, you all have more experience than i do; so it's worth asking.   Thanks, Gene Maguin   ... View more

We are running sas/stat version 13.1 and need to do a GEE analysis. From the documentation i see that gee was added as an experimental procedure in 13.2 and as a 'regular' procedure in 14.1. I understand that upgrading is the real solution but this is a university-system wide contract installation so probably not an option. Somebody here suggested looking around for a legacy macro. If there is such a thing, how would i go about finding it? Thanks, Gene Maguin ... View more

Part 1. Suppose a nominal variable with three categories (A,B,C). Proc Logistic, as does GLMMIX and others procs, solve that. However, the PI insists that in CATMOD an analysis can be constructed to compare A vs (B+C) and B vs C in a single proc statement. However, he doesn't recall how. Is this possible? Please, details. Part 2. The covariate list will include continuous variables that, as I read the documentation, catmod doesn't work well with. Can the analysis be done in logistic or glmmix? Details please.  Part 3. The dataset is multilevel, occasions within persons, so if the analysis can done in sas, can random effects be included? Again, details please.   Thank you, Gene Maguin ... View more

In spss i can do this print / id x1 to x5 y3 to y8 (a4,5f6.2,/,4x,5f6.3). which gives 1234 23.22 34.66 18.56 99.01 24.33       3.44 87.33  8.22  4.55  6.22 this would go to the output window but i could also send it to a file, both would be utf-8 text, not html. the write command can do the same but only to a file as utf-8 text. In proc print i say proc print data=xx; var id x1-x5 y3-y8; but what i get is one row per record. Is it possible, somehow, in sas to print/write under format control? In particular, how would i take defined sets of variables per data file record and print/write one set per line in the output? I understand that if the dataset were restructured so that each case occupied two records, proc print would do it. I'm not very interested figuring out how to restructure a dataset in sas. I've looked at the proc print documentation and while it can do a lot; i didn't see anything like format control. Thanks, Gene Maguin ... View more

Long time spss user. I want to see what the sas equivalent is for this.   do if (x eq 1 and y eq 3). compute a=2. compute b=3. compute c=7. else if (x eq 2 and y eq 4). compute a=1. compute b=0. compute c=4. else. compute a=4. compute b=5. compute c=9. end if.   or do if have to do this three times, subbing in b and c for a? if (x eq 1 and y eq 3) then compute a=2; else if (x eq 2 and y eq 4) then compute a=1; else then compute a=4;  /* this line may not be correct */;   Thanks, Gene Maguin         ... View more