|Date: ||Wed, 16 Jun 2010 11:10:00 -0400|
|Reply-To: ||"Remillard, Nancybelle" <nremilla@INDIANA.EDU>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Remillard, Nancybelle" <nremilla@INDIANA.EDU>|
|Subject: ||Converting SPSS ctables to SAS|
|Content-Type: ||text/plain; charset="us-ascii"|
We are converting SPSS to SAS. In SPSS when I run:
/IF SUBTYPES=['Custom Table']
/DESTINATION FORMAT=html OUTFILE='X:\ \temp_html_files\currentdata1_1.html'.
ctables / table webapp [c] by apply [c] /CATEGORIES VARIABLES=webapp apply ORDER=A KEY=VALUE EMPTY=INCLUDE TOTAL=YES POSITION=AFTER .
I get the following, which is exactly what I need. I've tried many different proc routines and haven't been able to replicate the table produced by spss.
In SAS the closest I can get is with Proc Freq - which I could live with if it weren't for the missing 'No' column. If someone could help me figure out how to force that 'No' column with a 0 count, I sure would appreciate it.
ODS HTML FILE ='x:\temp\currentdata1_1.html';
PROC FREQ DATA = &curyear ;
TABLES webapp * apply / NOPERCENT NOCOL NOROW MISSING;
FORMAT webapp webapp. apply apply.;
ODS HTML CLOSE;
The FREQ Procedure
Table of webapp by apply
Office of Enrollment Planning and Research
400 North Sunrise Drive
Weatherly Hall 308
Bloomington, IN 47405
This email message, including all attachments, is for the sole use of the intended recipients and may contain confidential and privileged information. If you are not the intended recipient, you may NOT use, disclose, copy or disseminate this information. Please contact the sender by reply email and immediately destroy all copies of the original message including all attachments. Even if you are the intended recipient of this email, the author requests that you not forward it to any other person without prior consent.