cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
lchristensen
‎03-21-2024
  • 31 Posts
  • 4 Likes Given
  • 3 Solutions
  • 2 Likes Received

Re: SGPLOT creating vertical lines for each data point

by Obsidian | Level 7 in Statistical Procedures
‎08-07-2022 08:37 PM
‎08-07-2022 08:37 PM
I printed the data and there were multiple values for the RRS5POID and it interleaved them since it was sorted by date/time/RRS5POID and some of the RRS5POID values were zeroes. Adding a 'by SMFRSSN RRS5POID' gave me the proper results.   Thank you   ... View more

Re: SGPLOT creating vertical lines for each data point

by Obsidian | Level 7 in Statistical Procedures
‎08-07-2022 07:26 PM
‎08-07-2022 07:26 PM
Proc Sort data=Work.Read_Port; by SMFDTIME RRS5POID; run; ods pdf file = "z:\Mainframe\GPSE\MAR and HMAI\HMAI Samples\POID.pdf"; proc sgplot data=Work.Read_Port; series y = RRS5ERCS x = SMFDTIME; series y = RRS5EWCS x = SMFDTIME; title1 'Hitachi Mainframe Analytic Interpreter: Subtype-5, RRS5ERCS, RRS5EWCS'; run; ods pdf startpage=now; ods pdf close; ... View more

Re: SGPLOT creating vertical lines for each data point

by Obsidian | Level 7 in Statistical Procedures
‎08-07-2022 07:25 PM
‎08-07-2022 07:25 PM
Removing XAXIS discrete made no difference, I actually put that in hoping it would.   ... View more

Re: SGPLOT creating vertical lines for each data point

by Obsidian | Level 7 in Statistical Procedures
‎08-07-2022 07:23 PM
‎08-07-2022 07:23 PM
One person wants it imbedded as text, another as an attachment.  ... View more

SGPLOT creating vertical lines for each data point

by Obsidian | Level 7 in Statistical Procedures
‎08-07-2022 02:40 PM
‎08-07-2022 02:40 PM
I have code creating a plot via SGPLOT. The output has vertical lines for each data point. I want a line graph with each series. How we I get rid of the vertical lines?   ... View more

Re: SGPLOT need help with creating a vertical bar chart

by Obsidian | Level 7 in SAS Programming
‎06-22-2022 11:20 PM
‎06-22-2022 11:20 PM
I don't think I've ever provided data before, and did in the PDF attachment. Anyway, I have what I decided I'll go with:     proc sort data=Work.T70; by M9_Dump_Process startime; run; proc sgplot data=Work.T70; where (M9_Dump =: 'D'); /* by M9_Dump_Process startime; */ by M9_Dump; title 'Dump 8 Volumes: CP and ZIIP Usage'; yaxis label='CP and ZIP % Used'; vbar M9_Dump_Process / response=pctmvsby stat=MEAN; vbar M9_Dump_Process / response=pctzipby stat=MEAN barwidth=0.5; run; proc sgplot data=Work.T70; where (M9_Dump =: 'D'); title 'Dump 8 Volumes: CP and ZIIP Usage'; yaxis label='CP and ZIP % Used'; vbar M9_Dump_Process / response=pctmvsby stat=MEAN; vbar M9_Dump_Process / response=pctzipby stat=MEAN barwidth=0.5; run;       Thank you, ... View more

Re: SGPLOT need help with creating a vertical bar chart

by Obsidian | Level 7 in SAS Programming
‎06-22-2022 05:45 PM
‎06-22-2022 05:45 PM
Hit the post button too soon. Sorry. Attaching my SAS code and a PDF of the printed data I want and some not useful SGPLOTs.     ... View more

SGPLOT need help with creating a vertical bar chart

by Obsidian | Level 7 in SAS Programming
‎06-22-2022 05:43 PM
‎06-22-2022 05:43 PM
I am reading SMF/RMF data, specifically type 70 records and using MXG's generated Type70. I have a print that reflects the fields I am interested in. Two are fields I've added called 'M9_Dump_Process' and 'M9_Dump'. M9_Dump is the first 6 characters of M9_Dump_Process which is a name I made up reflecting the number of disk volumes being processed and the type of compression being used.   There are a varying number of SMF/RMF intervals (30 minutes per interval). I output the STARTIME (start of interval), M9_Dump_Process, IO*ACTIVITY*RATE (IORATE), MVS Busy(%) (pctmvsby), Zip Busy(%) (pctzipby). and IBM*4-HR*AVERAGE*HOURLY*MSU (smf70lac).   The number of SMF/RMF intervals can vary by M9_Dump_Process. For example, M9_Dump_Process 'Dump08Vols_DFDSS' took nearly three hours so there are six SMF/RMF intervals. Dump08Vols_None on the other hand completed within an hour and has two SMF/RMF intervals.   What I would like to do is create a vertical bar chart. The vertical axis would represent pctmvsby and pctzipby (0-100%). The horizontal axis would be the SMF intervals (STARTIME). For each interval, I want to have a bar representing the pctmvsby value next o pctzipby. I would like the value of the M9_Dump_Process to be in the vertical bar, or placed where you can immediately see which M9_Dump_Process the data reflects.    There are four values for P9_Dump_Process. Well, there's actually 20, four each for 'M9_Dump'. I'd like to have all M9_Dump_Process charts for a value of M9_Dump on a page, a new page for each M9_Process.     ... View more

Re: SAS V9.4 on Windows-7, creating file (PDS) for Mainframe, need hel...

by Obsidian | Level 7 in SAS Programming
‎03-20-2022 01:53 PM
‎03-20-2022 01:53 PM
Thank you. As part of downloading source I needed to make some changes. I really didn't expect anyone to download and run it; I really thought someone might know what is needed to FTP to a mainframe host and close each member. I know it can be done, we used to have Pat Arti's I/O Driver and it's JCLMAGIC piece did that.   I had little time, so I made a work around. I added control cards for IBM's IEBUPDTE ( './ ADD' , './ ENDUP') and when I did the file transfer thru ISPF option 6 I then ran IEBUPDTE. So I'm done. Thank you. ... View more

SAS V9.4 on Windows-7, creating file (PDS) for Mainframe, need help wi...

by Obsidian | Level 7 in SAS Programming
‎03-16-2022 10:34 AM
‎03-16-2022 10:34 AM
We run SAS V.9.4 on Windows-7 servers. I am building JCL for what will be a thousand or so jobs to do regression testing on some software. These jobs run on an IBM z/OS mainframe.   The intent is to FTP the output file. I want a member name for each job. I am not certain what is needed.   The code in LC_BLD_TESTJCL.txt sets some macro variables and then loads five arrays, then there is a series of do loops for each array. In the inner most do loop there's an INCLUDE for LC_INCURQRY.txt that performs the put statements building the jobs. One of the macro variables, BCMAJCL, contains the name of the PDS I want to create.   As it is, I create a file on Windows that has the JCL and it looks good; however, the intent is to write each job to a PDS member. The member name is to be the same as the jobname which is built and is variable BCMAJNAM.   The current file written has a FILENAME of JCLBUILT. In this code I'm creating 32 jobs. I'll have more to add later.   I think I need to change the program to use FILENAMEJCLFTP and that somewhere in the INCLUDE I need to set FILE JCLFTP(&BCMAJNAM). ... View more

Re: SAS Variable formatted as hex4. sometimes gets output in exponenti...

by Obsidian | Level 7 in SAS Programming
‎08-31-2021 08:01 PM
‎08-31-2021 08:01 PM
Yes. The output to .csv file results in being opened by Excel and apparently Excel doesn't know what HEX is, though I've read there are functions to switch from hex to decimal and back.   I may have to resort to putting quotes around the hex variable values and treating as text.   Thank you. ... View more

SAS Variable formatted as hex4. sometimes gets output in exponential n...

by Obsidian | Level 7 in SAS Programming
‎08-31-2021 06:13 PM
‎08-31-2021 06:13 PM
Creating pairs for z/OS device addresses for replication. The device addresses are a four digit HEX value: ie, 8E00 - 8E0F would be 16 addresses. When the variable Tgt_Address is output those values where the last digit of the hex string is a number between 0 and 9 (inclusive) the value is shown in exponential notation. When the last digit is alpha (A-F) the value is properly shown.   Code segment below: /* ---------------------------------------------------------------------------------------------------------------------------------------- */ /* Build pairs for the TPF volumes. */ /* ---------------------------------------------------------------------------------------------------------------------------------------- */ data Work.Build_TPF; file MOVETPF; format tpfa hex4.; format Tgt_Address hex4.; if _N_ = 1 then Put @ 001 'Unit_Address' + (0) ',' + (0) 'Tgt_Serial_Number' + (0) ',' + (0) 'Tgt_Address' + (0) ',' + (0) 'Tgt_Volser' + (0) ',' ; retain Tgt_Address 8E00x; do tpfa = 7800x to 787Fx; Tgt_Volser = 'XX' || put(Tgt_Address,hex4.); Tgt_Serial_Number = 50344; put @ 001 tpfa + (0) ',' + (0) Tgt_Serial_Number + (0) ',' + (0) Tgt_Address  + (0) ',' + (0) Tgt_Volser + (0) ',' ; Tgt_Address = Tgt_Address + 1; end; do tpfb = 7900x to 797Fx; Tgt_Volser = 'XX' || put(Tgt_Address,hex4.); Tgt_Serial_Number = 50344; put @ 001 tpfa + (0) ',' + (0) Tgt_Serial_Number + (0) ',' + (0) Tgt_Address  + (0) ',' + (0) Tgt_Volser + (0) ',' ; ; Tgt_Address = Tgt_Address + 1; end; run; ... View more

Re: PROC FREQ output to ODS Powerpoint: multi-slide output needed

by Obsidian | Level 7 in ODS and Base Reporting
‎02-17-2021 05:39 PM
‎02-17-2021 05:39 PM
Thanks. I've never used PROC REPORT but will look at it. ... View more

PROC FREQ output to ODS Powerpoint: multi-slide output needed

by Obsidian | Level 7 in ODS and Base Reporting
‎02-17-2021 03:36 PM
‎02-17-2021 03:36 PM
I have code that generates a lot of performance data combining SMF/RMF (mainframe performance) with information on my firm's disk subsystems. What is attached is a small part of what will exist.  I'm looking to produce a single-run that creates a PowerPoint that is going to be hundreds of slides. The code includes a lot of PROC FREQs that generate multiple pages of print, and also a lot of SGPLOT output.    I'm concerned that with PROC FREQ and ODS POWERPOINT I can't seem to set a number of lines of data for each PowerPoint slide, it seems to be trying to write more lines than can fit on a single slide.and I see a lot of text well outside the borders of the slide. With one example PROC FREQ in this code, doing a TABLE MARSSN * MARSCU, there might be as many as 10 subsystems (identified by serial number in MARSSN) and within each theoretically as many as 256 control units (MARSCU)) and that frequency table could be dozens of pages.    ODS seems to be very powerful but complicated. I really don't want to have to write a thousand lines of code for ODS templates for an eight-line proc. Can anyone suggest a way of limiting the number of lines of PROC FREQ output per slide? I thought maybe an OPTIONS PAGESIZE=10 or something at the start might work but I'm not sure it does. My test data isn't sufficient to generate a multi-page output from these procs.   A minor issue is coming up. I have used "ODS NOPROCTITLE" but that doesn't seem to stop the slides from having a PROC FREQ generated "The FREQ Procedure" title on the slides.   ... View more

SGPLOT: Legend is unreadable. I think it's trying to write out every ...

by Obsidian | Level 7 in Graphics Programming
‎10-29-2020 05:32 PM
‎10-29-2020 05:32 PM
SS V9.4 on Windows Server   My data includes a date/time field (CurrentTime) and an interval of time in minutes (CTDelta_Time_In_Minutes). The SGPLOT should have the CurrentTime value on the x-axis and the CTDelta_Time_In_Minutes on the y-axis....and it doesn't.   The CurrentTime value is date/time including seconds. There may be as many as 12 records for every hour. The input dataset could contain weeks, maybe even months, of data.   The problem is the legend is unintelligible. I think it's trying to list every value on the chart and that could be thousands.    What I'd like is to have something like every hour as a marker. Can you offer advice?   SAS code is attached. Also a PDF of the plot is attached as a PDF.     Code: filename URMETRCS 'z:\Mainframe\lchristensen\URMETRCS\URMETRCS_RPT.csv'; title; proc import datafile="URMETRCS" out=Work.Report_CSV dbms=csv; run; Data Work.URMETRCS_EVENTLOG Work.CTDelta_Time; infile URMETRCS end=eof length=reclen missover; data Work.Read_CSV; set Work.Report_CSV; format CTDelta_Minutes 6.0; CTDelta_Minutes = (CTDelta_Secs / 60); /* convert CTDelta_Secs to minutes */ run; proc print data=Work.Read_CSV noobs uniform; title "Word.Read_CSV"; run; proc sort data=Work.Read_CSV nodupkey; by CurrentTime; run; ods pdf; proc sgplot data=Work.Read_CSV; /* graph with date/time on bottom and CTDelta_Time on y axis */ series x = CurrentTime y = CTDelta_Minutes ; /* xaxis type = discrete; */ title1 "Hitachi Mainframe Replication Extenstion"; title2 "CTDelta Time in Minutes by Date/Time"; run; ods pdf close; quit; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-21-2024 03:57 PM
Likes given to
Likes from
View All
Quick links