topic Re: CSV file created from MXG in SAS Programming

CSV file created from MXG

dman1414 — Mon, 12 Nov 2018 21:56:57 GMT

I'm new to SAS programming and I've created a CSV file from a Mainframe MXG report. The CSV file doesn't have column headings and I'm trying to figure out how to make that happen.

This is what the CSV file looks like:

ABC123ID;ICL226ID;DEF1234;STEP020;SYSC;12/12/2017;0.21;4.23

ABC123ID;ICL226ID;DFSRRC00;STEP010;SYSC;12/12/2017;57.61;1650.17

ABC123ID;CTRLIST;DEF1234;CONTROLR;SYSC;12/12/2017;0.29;1.10

I'd like it to look like this:

Jobname Procname Program Stepname System Date CPUTM Elapsed

ABC123ID;ICL226ID;DEF1234;STEP020;SYSC;12/12/2017;0.21;4.23

ABC123ID;ICL226ID;DFSRRC00;STEP010;SYSC;12/12/2017;57.61;1650.17

ABC123ID;CTRLIST;DEF1234;CONTROLR;SYSC;12/12/2017;0.29;1.10

Thanks

Re: CSV file created from MXG

Tom — Mon, 12 Nov 2018 21:59:25 GMT

How did you create the CSV file?

Also wouldn't you want the line with the column headers to also include commas between the values?

Re: CSV file created from MXG

dman1414 — Tue, 13 Nov 2018 21:40:44 GMT

//RPT01 EXEC MXGSASV9

//PDB1 DD DSN=ABC.MXG.PDB.WEEKLY.G1150V00,DISP=SHR

//DMAN1 DD DISP=(,CATLG),DSN=TEST.ABCTESTA.CSV,

// RECFM=VB,LRECL=27000,BLKSIZE=0,SPACE=(CYL,(20,10),RLSE)

//SYSIN DD *

options nodsnferr nosource2 ;

data extract

(keep=system cputmx program job newdate

elapsed procstep stepname);

set pdb1.steps

;

format cputmx 9.2 ;

format elapsed 12.2 ;

format newdate DDMMYYS10.;

where substr(JOB,1,8) in ('ABC226ID');

cputmx = cputm ;

elapsed = selapstm ;

newdate = datepart(termtime);

Data _null_ ;

FILE DMAN1 DELIMITER =';' DROPOVER ;

set extract ;

put (_ALL_)(+0) ;

run ;

Re: CSV file created from MXG

Tom — Wed, 14 Nov 2018 00:33:09 GMT

Simplest thing would be to just add a PUT statement that runs only once.

data _null_ ;
  FILE DMAN1 DELIMITER =';' DSD ;
  if _n_=1 then put 'System;CPUTMX;Program;Job;Date;Elapsed;ProcStep;Stepname';
  set extract ;
  put (system cputmx program job newdate elapsed procstep stepname)(+0) ;
run ;

Re: CSV file created from MXG

dman1414 — Thu, 15 Nov 2018 15:10:43 GMT

Thanks that resolved my issue.