02-03-2015 06:01 AM
i am developing one table (say x) and coming that table with production result by using proc compare, and i have to generate one more listing which contains output window results for x. so i have to compare production listing with my QC listing! my question is how i compare by manually or is it any procedure is der to compare output windows?
thanks in advance!!
02-03-2015 06:18 AM
There are several ways, but not via output window. You can route your data to datasets as Xia Keshan has stated, and this then gives you proc compare options. That in itself takes a lot of the QC out from the output file. AS for your actual output, what do you need to check exactly as styling and such like can make differences. If you just want basic content, then use a proc print to text file, then you can read that in. For more advanced options then you can go out to RTF or PDF and use that software's compare functions. You could also read the rtf back in and parse it into its composite parts, I have done this and its not particularly difficult, the main issue is parsing all the tags and such like. You could also set your output window up to display HTML and then save that to file, then create a HTML parse program to read it back in.
Me, I would say that effort vs confidence ratio would suggest that proc compare the data as a "one step away" dataset, i.e. make your data look almost identical to the output, and then having a small output routine would be most cost efficient.
So if you have a table which looks like:
Category Trt1 Trt2
ABC xx (yy%) xx (yy%)
Then make a dataset which looks like that:
CAT (Category) TRT1 (Trt1|(n=xx)) TRT2 (Trt2|(n=xx))
ABC xx (yy%) xx (yy%)
Store that, get the QC'er to do the same, and proc compare the two. Then a manual review of the output to ensure that the right dataset was used, and titles/footnote are correct.
02-03-2015 11:21 PM
thank you RW9,
But my problem is i am using proc mixed in generating table visits wise so i got around 40 pages in output window i have to compare my output window to production programer output window which is in PDF file.
Thanks in advance!
02-04-2015 04:02 AM
Well, then your stuck really. As I have stated, direct your output not to the output window - which to be fair is about as useful as a hole in a bucket. Just put an ods statement before and after your mixed and send to a pdf file. You can then use PDF compare to check the two. However you need to bear in mind that PDF compare will check everything, so if your not using the same style or layout then it will not match. Hence I recommend that you are proc comparing datasets which is the best way to get accurate comparison of the data. If you want to keep your mixed output then use ods select for the particular tables which mixed creates behind the scenes:
Each of these holds some of the statistics produced and can be kept.
02-04-2015 04:38 AM
Well, not too familiar with GLM, but here is a SAS article which shows sending output from those types of procedures to html, its pretty much the same thing for PDF:
Also note, that to find what output blocks are created in your procedure, use the ods trace on; syntax, this will display in the output window what objects are created, you can then re-run the program select those objects to send via ods to a file.