Not the most efficient, but this could work for you... basically set up two new variables and specify the format and length of them to $5 like you want. Then you're copying var1 and var2 into them. The second data step is just to get your new variables named back to your original variables so you can continue working with your data - if that matters to you that they are named the same as originally. Data combine (drop var1 var2 ) ; Set data1 data2; format var3 var4 $5.; var3=var1; var4=var2; Run; data combine; set combine (rename=(var3=var1 var4=var2); run; (I didn't test this, but I've had to do this sort of thing before because I couldn't figure out a better way to do it.) ... View more

Cynthia - thanks for the info. They did want a page break as in just where it would print on a separate piece of paper. They have 1,000 clients and need to print out (I know, I know, I'm screaming inside about that!) for each client rather than having a separate worksheet that they could just send electronically. They had everything in one file. I'll def. take a look at the info you suggest as I'm certain I'll be able to use it for other things. Thanks again. ... View more

A former coworker who is an Excel whiz sent me a link on how to do it in Excel - but I'm still wondering about how we might be able to output with SAS. And in case anyone was interested: http://www.mrexcel.com/td0032.html is where the tip is for Excel. (hope it's ok to post the link). ... View more

My boss got me this book in time for Christmas 🙂 Thanks for making it available. ... View more

Try this after you've loaded your data.: (sorry for the ALL CAPs - we just typically program in ALL CAPS). *** output frequency to a work data set by variable ***; PROC FREQ DATA=vorschlag; TABLE vorschlag1 /NOROW NOCOL NOPERCENT NOCUM OUT=vorschlag1; RUN; PROC FREQ DATA=vorschlag; TABLE vorschlag2 /NOROW NOCOL NOPERCENT NOCUM OUT=vorschlag2; RUN; PROC FREQ DATA=vorschlag; TABLE vorschlag3 /NOROW NOCOL NOPERCENT NOCUM OUT=vorschlag3; RUN; *** sort to get ready to merge ***; PROC SORT DATA=VORSCHLAG1; BY VORSCHLAG1; RUN; PROC SORT DATA=VORSCHLAG2; BY VORSCHLAG2; RUN; PROC SORT DATA=VORSCHLAG3; BY VORSCHLAG3; RUN; *** checking data ***; PROC PRINT DATA=VORSCHLAG1; RUN; PROC PRINT DATA=VORSCHLAG2; RUN; PROC PRINT DATA=VORSCHLAG3; RUN; *** merging ***; DATA VORSCHLAGALL; MERGE VORSCHLAG1 (IN=A KEEP=VORSCHLAG1 COUNT RENAME=(VORSCHLAG1=VORSCHLAG COUNT=V1COUNT)) VORSCHLAG2 (IN=B KEEP=VORSCHLAG2 COUNT RENAME=(VORSCHLAG2=VORSCHLAG COUNT=V2COUNT)) VORSCHLAG3 (IN=C KEEP=VORSCHLAG3 COUNT RENAME=(VORSCHLAG3=VORSCHLAG COUNT=V3COUNT)); BY VORSCHLAG; LABEL V1COUNT='VORSCHLAG1' V2COUNT='VORSCHLAG2' V3COUNT='VORSCHLAG3'; RUN; *** check data ***; PROC PRINT DATA=VORSCHLAGALL; RUN; *** clean up data to get rid of missing / change to zero ***; DATA VORSCHLAGALL; SET VORSCHLAGALL; IF VORSCHLAG=0 THEN DELETE; ELSE IF V1COUNT=. THEN V1COUNT=0; ELSE IF V2COUNT=. THEN V2COUNT=0; ELSE IF V3COUNT=. THEN V3COUNT=0; RUN; *** proc print to output ***; PROC PRINT DATA=VORSCHLAGALL; RUN; ... View more

So I just have to say that I had to do this again and it was great to come back here to refresh! ... View more

Every time we have gotten an I/O failure, it has been the result of network issues within our office (we run remotely from a server). When the disk is full, we get a different error. Good luck - I know it's frustrating to work with a large data set and have it near completion only to fail at the end. ... View more

I use the tagset a lot and sometimes do get a file that is way too big as an xml file, but once it "finally" opens and I "save as" excel, it shrinks it down quite a bit. I haven't figured out how to adjust the formatting (or remove the formatting) for outputting, but I made myself a macro in Excel that will remove the shading, resize fonts, etc. etc. etc. for the type of file I most often export with the tagset. ... View more

A couple of things you might consider are outputting to a data set and then you can export that data set to Excel. What you would do is this: proc freq data=lib.test ; table var1 / out=list.test1; run; Your new data set would have three variables: var1, count, and percent. This is fine for a single variable frequency. If you do a by- frequency, then you'd get a more complex data set. One thing that I've had good luck with in copy/pasting single frequency tables from the output window is using the Excel feature of Data / Text-to-Columns. It takes a little playing around with to get it to break just right, but it's pretty forgiving. Good luck. ... View more

Cynthia - Thanks so much! It worked beautifully. ... View more

Would you share your code that you use for using the labels for one-way PROC FREQs? Thanks. ... View more