sput My SAS program produces an excel file for each of the college’s 7 academic departments. Each file contains a separate spread sheet for each academic major in that department with 95% of the requisite information. We currently manually edit in the remaining information for the college's 63 majors. The remaining information consists of three (3) values for each major (Grads, Placed, PCT_Placed) and a list of graduates with multiple degrees that is included if graduates in that major have multiple degrees. I created macros using symput (&GR &PL &PCTPL) to pass the correct placement values for use in the titles, but the macros picked up the values for the last department’s major and passed/ applied these values to all majors. The layout for the main data set (&pe..HUNTED)is: COLID, FName, LName, Home, Work_Day, Nite, Email, MD,DE, DR, NAICS, STATUS, DEPT, Major, GRADS, PLACED, PCT_PLACED. The layout for the data set multi-degree (Students who graduated from more than one program) is COLID, Maj1, Mal2, Maj3, Maj4, Maj5,Maj6, Maj7.). There is ONE observation for each student (COLID) with multiple degrees. If a student does not have multiple degrees, there is no observation. The following contains the SAS code that produces the current reports and a copy of a mock output excel spread sheet for the AA department. The pe sas excerpt produces the excel file for the AA department with the individual sheets for the two majors,AA and AS. The actual program runs this same code for each of the eight (8) departments. Apologies. but every attempt to provide the prog and results via attachment failed. %include "C:\PROG EVAL 2015\PE HEAD\SAS MACROS LIBS PE 2015.SAS"; PROC SORT DATA=&pe..HUNTED; BY DEPT MAJOR COLID; DATA AAA HS BUS ET IND IST PS NUR; SET HUNTED; CALL SYMPUT ('GR',trim(left(put (GRADS,8.)))); CALL SYMPUT ('PL', trim(left(put(PLACED,8.)))); CALL SYMPUT ('PCT',trim(left(put(PCT_PLACED,8.)))); IF DEPT='AAA' THEN OUTPUT AA;; IF DEPT='HS' THEN OUTPUT HS; IF DEPT='BUS' THEN OUTPUT BUS; IF DEPT='PS' THEN OUTPUT PS; IF DEPT='ET' THEN OUTPUT ET; IF DEPT='IND' THEN OUTPUT IND; IF DEPT='IST' THEN OUTPUT IST; IF DEPT='NUR' THEN OUTPUT NUR; RUN; /**AA Dept**/ ods tagsets.ExcelXP FILE="C:\PROGEVAL 2015\REPORTS\AAA 2013-14 Graduate Contacts testx.Xml" style=BARRETTSBLUE; ods tagsets.ExcelXP options (autofit_height= 'yes' embedded_titles='yes' embedded_footnotes='yes' TITLE_FOOTNOTE_WIDTH='10' sheet_interval='bygroup' sheet_label=' ' frozen_headers= '3' absolute_column_width= '6,6,9,14,12,12,12,16,3,6,4,4,30' row_heights='0,10,0,0,0,0,0' row_height_fudge='3' ); title; footnote; title1 font=timesRoman bold FONT='12PT' h=4 color=blue "2013-14 #BYVAL(MAJOR) Graduates Not Placed "; title2 font=timesRoman h=4 color=blue " In the Status Column, please use the following codes to indicate the Graduates status"; title3 font=timesRoman h=4 color=blue "FT=Work FT in Job Related to Degree, PT= Work PT in Job Related to Degree, S=Full-time Student Fall 2014 I= NotSeeking Work/Active Duty"; title4 font=timesRoman h=4 color=BLACK "Graduates: &GR Placed: &PL Percent Placed: &PCT"; footnote1 font=timesRoman h=3 color=blue "http://www.census.gov/eos/www/naics/"; footnote2 font=timesRoman h=3 J=L color=blue "Note: A 'Y' in the MD column indicates that the graduate has multiple degrees. If a graduate with multiple degrees is 'PLACED' for one one degree, "; footnote3 font=timesRoman h=3 J=L color=blue " s/he is considered placed for all degrees. Multiple degree graduates for this program and their other degrees are listed below:"; PROC REPORT DATA=AAA NOWD; BY major; COLUMNS MAJOR COLID FNAME LNAME Home Work_Day Nite Email MD STATUS DE DR NAICS ; DEFINE MAJOR/ORDER WIDTH=5; DEFINE COLID/ DISPLAY WIDTH=10; DEFINE FNAME/DISPLAY WIDTH=20; DEFINE LNAME/DISPLAY WIDTH=20; DEFINE Home/DISPLAY WIDTH=12; DEFINE Work_Day/DISPLAY WIDTH=12; DEFINE Nite/DISPLAY WIDTH=12; DEFINE EMAIL/DISPLAY WIDTH=45; DEFINE MD/DISPLAY WIDTH=3; DEFINE STATUS/DISPLAY WIDTH=6; DEFINE DE/DISPLAY WIDTH=7; DEFINE DR/DISPLAY WIDTH=7;; DEFINE NAICS/ DISPLAY WIDTH=55; BREAK AFTER MAJOR / PAGE; RUN; ODS tagsets.ExcelXP close; /**end**/ CALL SYMPUT ('GR', trim(left(put (GRADS,8.)))); CALL SYMPUT ('PL', trim(left(put(PLACED,8.)))); CALL SYMPUT ('PCT', trim(left(put(PCT_PLACED,8.)))); 2013-14 AA Graduates Not Placed In the Status Column, please use the following codes to indicate the Graduate's status FT= Work FT in Job Related to Degree, PT= Work PT in Job Related to Degree, S =Full-time Student Fall 2014 I= Not Seeking Work/Active Duty Graduates: 222 Placed: 178 Percent Placed: 80.0% MAJOR COLID FNAME LNAME HOME WORK_DAY NITE EMAIL MD STATUS DE DR naics AA 99999 Donald Roeser 9999 777- BOC@aol.com Y PT Y 812210 Funeral Homes 111111 Morris Day 888 Dinowlk@hotmail. 713940 /Watch_Clock mfg 2222 Jani Lane 999- cherries@yahoo.c Y 311811/bakeries 555555 Davis Byron 999 888 stealer@yahoo.co PT Y 0211 /Cattle Ranching 3333 Buffett James 999- magrita@yahoo.c 336612/Boat building http://www.census.gov/eos/www/naics/ Note: A 'Y' in the MD column indicates that the graduate has multiple degrees. If a graduate with multiple egrees is 'PLACED' for one one degree, s/he is considered placed for all degrees. Multiple degree graduates for this program and their other degrees are listed below: COLID Major Major Major 99999 AA NUR HLC6 555555 AA AS
... View more