34 libname f "H:\CA\CA19\Documents Used for Report"; NOTE: Libref F was successfully assigned as follows: Engine: V9 Physical Name: H:\CA\CA19\Documents Used for Report 35 *'S:\2017-2018 Sch Asmt\Assessments\CA17\Final Reports\Documents Used to Created Final Reports'; 35 ! *--location where 36 we want SAS to store SAS datafile; 37 libname C "H:\Temporary SAS Output"; NOTE: Libref C was successfully assigned as follows: Engine: V9 Physical Name: H:\Temporary SAS Output 38 39 *'S:\'; 40 *---Change Year; 41 %let yr=2019; 42 *--Change School Year; 43 %let schyr=1920; 44 *--Change location of raw data file ; 45 %let folder= H:\CA\CA19\Documents Used for Report\; 46 *S:\2017-2018 Sch Asmt\ Assessments\CA17\Final Reports\Documents Used to Created Final Reports\; 47 *--Change File; 48 %let rawdatafile=CCAll_08212020.xlsx; *--cleaned tab used in xls; 49 50 51 *Raw SAS datafile; 52 proc contents data=f.ccall&schyr; NOTE: Writing HTML Body file: sashtml.htm 53 title "Contents CCAll&schyr"; 54 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 1.34 seconds cpu time 0.29 seconds 55 56 *--rename and create variables; 57 data c.careformat&schyr(drop=/* mz_physzip mz_mailzip*/ mz_cocode mz_facilitycode); /*drop variable with missing zero*/; 58 length cocode $2 facilitycode $9;/* mailzip $5 physzip $5*/ 59 set f.CCALL&schyr(rename= 60 ( /*mailzip=mz_mailzip physzip=mz_physzip*/ 61 cocode=mz_cocode facilitycode=mz_facilitycode 62 /*SCHCODE=facilitycode*/ 63 All_required=allreq 64 XXX=PBE 65 YYY=cond 66 ZZZ=total 67 _Exemption=PME 68 _Exemption=TME 69 =IEPService 70 78 79 )); 80 81 *--apply z. format to numeric value to make it character and restore missing leading zeroes; 82 cocode = put (mz_cocode, z2.); 83 facilitycode=put(mz_facilitycode, z9.); 84 /*mailzip = put (mz_mailzip, z5.); 85 physzip = put (mz_physzip, z5.); */ 86 87 *--populate missing facilitytype; 88 if reportingstatus='Not Reported' and facilitytype=' ' then facilitytype='UNKNOWN'; 89 run; NOTE: Data file C.CAREFORMAT1920.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. ERROR: Some character data was lost during transcoding in the dataset C.CAREFORMAT1920. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding. NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1490 observations read from the data set F.CCALL1920. WARNING: The data set C.CAREFORMAT1920 may be incomplete. When this step was stopped there were 1489 observations and 47 variables. WARNING: Data set C.CAREFORMAT1920 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 15.87 seconds cpu time 0.14 seconds
... View more
