I want to amend my code so that there is a row after each school that sums the N count for grades 6, 7 and 8 and calculates the percent before going to the next school.  Below is a partial output and my code.   proc tabulate data=one; by schlevel; class efagrade school; class ela /preloadfmt; tables school='SCHOOL'*efagrade='GRADE' all='TOTAL', ela='PERFORMANCE LEVEL'*(n*f=6.0 pctn<ela>='PCT'*f=6.0) all='TOTAL'*(n*f=6.0)/rts=25 misstext='0' printmiss; format ela scready.; run;     PERFORMANCE LEVEL TOTAL Does Not Meet Approaches Meets Exceeds N PCT N PCT N PCT N PCT N SCHOOL GRADE 55 22 105 42 71 28 22 9 253 School A 06 07 56 22 91 36 65 25 44 17 256 08 56 22 79 31 82 32 41 16 258 School B 06 2 7 16 59 9 33 0 0 27 07 10 23 23 53 9 21 1 2 43 08 8 24 15 44 9 26 2 6 34 ... View more

I must have accidently hit some kind of keyboard combination that changed my cursor to a wider looking black one.  Now, I'm overwriting in a way I don't want.  Where to change this back? ... View more

what delimiter should I use for importing this .txt file?  Here is the first obs:   SCSchool District of*******         W******* High     007 ... View more

Here is the first obs of a txt file I need to import. I can't get the correct delimiter.  some vars have been starred out for privacy reasons.   SCSchool District of*******         W******* High     007            ******* ******  *******          1018****F9202120374                    09  NNNNNN    00000000  NNNNNNNNNNNNNNNNNNN                                                 400                                                                                                                                                 3021813113093082423102891.91.01.81.81.91.51.81.7X X X X X XXXX     X     X     X                     342262228134336286329289334282273211327293304274                                                                                                                                                                                     0030116                                                            990015090570   990015090638   990015090598   990015090622                                                               OnlineOnlineOnlineOnlineKB                                                              000000011001000110      101000010000100100000001   ... View more

  I have a SAS file that I cleaned up and now need to export it in the same format as the original dirty file. See the portion below. I starred out last and first name for privacy reasons. The original file does not have headers so I can't export those.   Original file to mimic:   "37-01-017",10045,"Ravenel Elementary","********","********","F",   SAS output I currently have:   VAR1 student_number VAR3 first_name last_name VAR6 37-01-017 10045 Ravenel Elementary ****** ****** F 37-01-027 10103 FairOak Elementary ****** ****** M 37-01-027 10327 FairOak Elementary ****** ****** F 37-01-022 10332 Walhalla Elementary ****** ****** M 37-01-028 10511 Orchard Park Elementary ****** ****** M ... View more

I'm running SAS 9.4 on a 64 bit PC (Windows 8.1 Pro).   Code I'm submitting: proc export data=cluster_snapshot outfile="G:\Departments\Research\test scores\act\yr2.\State Test Reporting\reports\SCDE Release by School\20&yr2. ACT SCDE Release for Cluster Snapshots.xlsb" dbms=excelcs replace; run;   Error Message I'm getting: ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver]General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x1e54 Thread 0x1554 DBC 0x2c276c4 Excel'. ERROR: Error in the LIBNAME statement. Connection Failed. See log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE EXPORT used (Total process time): real time 3.88 seconds cpu time 0.20 seconds   I run proc export a lot and have never gotten this error. ... View more

I made a change in one of the PROC FORMAT steps and when I try to save the program it won't allow me to save changes. I exited anyway and opened some other SAS programs, made few changes and SAS does save those changes.  My autoexec program is here: C:\Program Files\SASHome\SASFoundation\9.4   I'm baffled. ... View more