A quick google search suggests JDML files are just XML files, which SAS can read.  If this is indeed the case for your files then you might find it helpful to start with http://www2.sas.com/proceedings/sugi29/119-29.pdf .  This is something I've only started to explore myself too. Otherwise, perhaps you could post a sample file and some details of the file structure?  There may be other options. ... View more

Do it all in one step, a SQL step. Not sure how big the data is, but this does the merge automatically: proc sql; create table class as select *, sum(age) as age_total from sashelp.class; quit; *ONLY TO Check age total; proc means data=sashelp.class n mean sum; var age; run; ... View more

Hi: I've never see this happen. But then I don't generally run Summary Statistics (PROC MEANS) on more than 2 or 3 variables at a time. This seems the kind of problem or issue that is best resolved by Tech Support. To contact Tech Support, go to http://support.sas.com and on the left-hand navigation pane, click on the link entitled "Submit a Problem" under the Support heading. cynthia ... View more

Doc@Duke, Thanks so much for your post. I followed all the examples shown in the posts, but for some reason your post is the one that resolved my issue. Thanks for taking time to post your responses to help out a "noob". Christine ... View more

Thanks, Cynthia!! ... View more

Hi: If you are talking about CROSSTABS, you may need to move to a different procedure, such as PROC TABULATE in order to control the column headers. See this thread for an example of a CROSSTABS using TABULATE instead of PROC FREQ. cynthia http://support.sas.com/forums/thread.jspa?threadID=1315&tstart=0 ... View more

Good description, Cynthia. In the interest of full disclosure I should make it clear that, although the crosstabs table template in 9.2 supports a lot of customizations, it will not let you rearrange the order of the row totals column or the column totals row. ... View more

That's it. Thanks for the help. You're right. I was typing fast. Thanks! ... View more

The menu for proc compare does not seem to have an insert code option where I can clear the footnote. Can that be done somewhere else? Nancy ... View more

If you supply the code, we can take a look at it and perhaps even help you. ... View more