We read multiple a SAS files with 2 numeric variables that can have missing values. We output selective fields to a CSV which is downloaded from the mainframe to a server. Server software has a problem with the Period(.) when the data is missing as it's expecting either a number or 2 consecutive delimiters(a comma in this case.) Varibles REALSIZE and VIRTSIZE are both numeric. Code is below and sample output below code.   DATA IPLOUT; SET IPLDATA; date2=put(ipldate,mmddyys10.); time2=put(ipltime,time11.2); downtm2=put(downtm,time11.2); keyind=compress(system||ipldate||ipltime); delim=","; recout= system||delim||custid||delim||date2||delim||time2 ||delim||downtm2||delim||realsize||delim||virtsize ||delim||product||delim||sysplex||delim||keyind ; recout=compress(recout); FILE IPLPOUT NOTITLES; put recout;   AXX1,TE,11/06/2016,16:11:56.86,0:00:00.03,.,.,,,ADTE2076458316.86 AXX1,TE,11/06/2016,17:56:58.08,0:00:00.03,.,.,,,ADTE2076464618.08 AXX2,TP,11/06/2016,22:49:39.93,0:00:00.12,.,.,,,ADTP2076482179.93 AXX2,TP,11/20/2016,0:55:26.42,0:00:00.14,5242880,2097152,SP7.2.1,ZZPLEX1,ADTP207 ... View more

We bring in 7 daily MXG PDBs and read RMFINTRV to check that we have 96 intervals each day before we build a Weekly PDB. We use PROC FREQ to check that. We'd like to add 1 column to the current output...SYSTEM. Just to verify that we have the correct data. I have tried performing the procedure using a "BY SYSTEM" which give sme a "TITLE" at the top of the report with the value for SYSTEM. And when I test it with data from another LPAR it does abend with a message...ERROR: DATA SET WORK.R1 IS NOT SORTED IN ASCENDING SEQUENCE. THE CURRENT BY GROUP HAS SYSTEM*ID = MVSX AND THE NEXT BY GROUP HAS SYSTEM*ID = MVSM...so in a way that does give me the information that one of the input files is incorrect.       DATA RMFINTRV ; SET MON.RMFINTRV TUE.RMFINTRV WED.RMFINTRV THU.RMFINTRV FRI.RMFINTRV SAT.RMFINTRV SUN.RMFINTRV ; DATA R1; SET RMFINTRV; KEEP DATE; IF WEEKDAY(DATE)=5 AND HOUR=12 THEN CALL SYMPUT('MEANDATE',PUT(DATE,DATE.)); PROC FREQ ORDER=DATA DATA=R1; TABLES DATE / OUT=R2; THE FREQ PROCEDURE DATE*OF*STARTIME CUMULATIVE CUMULATIVE DATE FREQUENCY PERCENT FREQUENCY PERCENT -------------------------------------------------------------- 05DEC2016 96 14.29 96 14.29 06DEC2016 96 14.29 192 28.57 07DEC2016 96 14.29 288 42.86 08DEC2016 96 14.29 384 57.14 09DEC2016 96 14.29 480 71.43 10DEC2016 96 14.29 576 85.71 11DEC2016 96 14.29 672 100.00 This is what we would like the output to be                                       CUMULATIVE CUMULATIVE DATE      SYSTEM  FREQUENCY PERCENT FREQUENCY  PERCENT -------------------------------------------------------------- 05DEC2016  MVSM      96       14.29    96       14.29 06DEC2016  MVSM      96       14.29    192      28.57 07DEC2016  MVSX      96       14.29    288      42.86 08DEC2016  MVSM      96       14.29    384      57.14 09DEC2016  MVSM      96       14.29    480      71.43 10DEC2016  MVSM      96       14.29    576      85.71 11DEC2016  MVSM      96       14.29    672     100.00   ... View more