Current student studying programming and getting very stuck on 1 part of my SAS assignment, any help would be greatly appreciated! This is my current code which includes the data: DATA college09ds;
INFILE DATALINES FIRSTOBS=2;
INPUT GenderType $ Year Total COMMA6. Retrieved $ Asofdate MMDDYY10. @@;
IF FINDW(UPCASE(GenderType), 'F') > 0 THEN
DO;
Gender='F';
Total_F=Total;
END;
ELSE
DO;
Gender='M';
Total_M=Total;
END;
IF FINDW(UPCASE(GenderType), 'IHE') > 0 THEN
Institution='IHE';
ELSE
Institution='DGI';
RETAIN Total_M Total_F;
Total_MF=Total_M + Total_F;
Grand_F + Total_F;
Grand_M + Total_M;
Grand_MF + Total_MF;
IF Gender='F';
DATALINES;
Variables: GenderType Year Total Asofdate
ihe-M 1970 5,044 Retrieved: 03/14/2012 f-IHE 1970 3,537 Retrieved: 03/14/2012
ihe-m 1980 5,874 Retrieved: 03/14/2012 f-IHE 1980 6,223 Retrieved: 03/14/2012
ihe-M 1990 6,284 Retrieved: 03/14/2012 F-IHE 1990 7,535 Retrieved: 03/14/2012
dgi-M 2000 6,722 Retrieved: 03/14/2012 f-dgi 2000 8,591 Retrieved: 03/14/2012
dgi-m 2001 6,961 Retrieved: 03/14/2012 f-dgi 2001 8,967 Retrieved: 03/14/2012
DGI-m 2002 7,202 Retrieved: 03/14/2012 f-dgi 2002 9,410 Retrieved: 03/14/2012
dgi-M 2003 7,260 Retrieved: 03/14/2012 F-DGI 2003 9,651 Retrieved: 03/14/2012
dgi-M 2004 7,387 Retrieved: 03/14/2012 F-DGI 2004 9,885 Retrieved: 03/14/2012
dgi-m 2005 7,456 Retrieved: 03/14/2012 f-DGI 2005 10,032 Retrieved: 03/14/2012
DGI-m 2006 7,575 Retrieved: 03/14/2012 f-dgi 2006 10,184 Retrieved: 03/14/2012
dgi-M 2007 7,816 Retrieved: 03/14/2012 f-dgi 2007 10,432 Retrieved: 03/14/2012
dgi-M 2008 8,189 Retrieved: 03/14/2012 F-DGI 2008 10,914 Retrieved: 03/14/2012
DGI-m 2009 8,770 Retrieved: 03/14/2012 F-dgi 2009 11,658 Retrieved: 03/14/2012
;
RUN;
PROC FORMAT;
VALUE $inst 'IHE'='Institutions of Higher Education'
'DGI'='Degree-Granting Institutions';
VALUE $sex 'M'='Male/Female' 'F'='Male/Female';
PROC PRINT DATA=college09ds;
ID Institution;
BY DESCENDING Institution;
SUM Total_MF Total_M Total_F;
OPTIONS NODATE NUMBER PAGENO=1 PAGESIZE=33 LINESIZE=256 ORIENTATION=LANDSCAPE;
FORMAT Institution $inst. Gender $sex. Asofdate DATE9. Total_MF
COMMA7. Total_M COMMA7. Total_F COMMA7. Grand_MF COMMA7. Grand_M
COMMA7. Grand_F COMMA7.;
VAR Gender Year Asofdate Total_MF Total_M Total_F Grand_MF Grand_M Grand_F;
TITLE1 'Enrollment Statistics for Years 1970 through 2009';
FOOTNOTE1 ' statistics are courtesy of National Center for Education Statistics ';
RUN; All parts are currently printing correctly except for the Grand_MF, Grand_M, and Grand_F columns, the values are very off. When I step through this as I would in another programming language I am not finding my logic error, but I know it must be there. The assignment: Include SAS statements in your program to perform the tasks listed below for each line of raw data. 1. Within the DATA step, assign the value in the Total variable to a variable named Total_F when the value in the Gender variable is F. Otherwise, assign the value in the Total variable to a variable named Total_M when the value in the Gender variable is M. 2. Within the DATA step, add the values in the Total_F variable to the values in the Total_M variable and store the result in a variable named Total_MF. 3. Within the DATA step, compute running totals for the values in the Total_F, Total_M, and Total_MF variables and store the running totals in variables named Grand_F, Grand_M, and Grand_MF, respectively. 4. Within the DATA step, only include observations in the college09ds data set when the value in the Gender variable is F. 5. Without using IF-THEN/ELSE logic in the DATA step, construct user friendly descriptions to display for the values in the Institution variable. Display Institutions of Higher Education when the value in the Institution variable is IHE. Otherwise, display Degree-Granting Institutions when the value in the Institution variable is DGI. Note: Do not overwrite the values in the Institution variable in the data set. 6. Without using IF-THEN/ELSE logic in the DATA step, construct user friendly descriptions to display for the values in the Gender variable. Display Male/Female when the value in the Gender variable is F or M. Note: Do not overwrite the values in the Gender variable in the data set. Display the contents of the SAS data set. Include the appropriate statements in your SAS program to display the contents of your data set just like the Sample Program Output Sample Program Output:
... View more