About lchristensen

PaigeMiller · ‎03-21-2024

From now on, when you have an error in a PROC, show us the log for that PROC. We need to see the code as it appears in the log, and any messages such as errors, warnins and noes. DO NOT show us just the error messages in the log, detached from the code in the log. where Work.Patient_HD.Patient_ID = Work.Patient_AGE.Patient_ID ; Try where patient_hd.patient_id =patient_age.patient_id;

lchristensen · ‎10-29-2023

Thank you. That works too. I must be losing my mind because I really think I tried this yesterday too.

lchristensen · ‎10-22-2023

Thank you

Tom · ‎05-05-2023

You do realize that the data step you posted Data Work.Gen_JCL; filename CFG_SW 'z:\mainframe\GPSE\ITPro32gb\SW_CMDS'; %FICON_SW(CHB_PAIR='1A'); run; makes NO sense what so ever. The macro you showed by for is generating a data step already. So it is as if you want this code: Data Work.Gen_JCL; filename CFG_SW 'z:\mainframe\GPSE\ITPro32gb\SW_CMDS'; Data Work.BLD_Switch_commands; ... run; Which is the equivalent of running Data Work.Gen_JCL; run; filename CFG_SW 'z:\mainframe\GPSE\ITPro32gb\SW_CMDS'; Data Work.BLD_Switch_commands; ... run; Not sure why you want to create GEN_JCL dataset with one observation and zero variables.

SASKiwi · ‎02-09-2023

If you want to combine detail and summarised data then do it as a join on a sub-query: Proc SQL; create table Work.DSPL_TBL1 as select * from Work.DSPL_CSV as A left join (select TapeStatus, sum(CompressedSize) as All_CompressedSize, sum(UncompressedSize) as All_UncompressedSize, mean(calculated All_CompressedSize) as as All_CompressedSize_Mean, mean(calculated All_UncompressedSize) as All_UncompressedSize_Mean from Work.DSPL_CSV where CompressedSize > 0 group by TapeStatus ) as B on A.TapeStatus = B.TapeStatus order by A.TapeStatus; quit;

lchristensen · ‎01-20-2023

I got it to work. The GROUP BY Unit_Cap_Cyl needed 'having Unit_Cap_Cyl GE 0' which also got rid of a lot of missing values. Proc SQL; title 'Sum of defined cylinders by volume emulation type'; select Unit_Cap_Cyl, count(Unit_Cap_Cyl) as Qty_Vols label='# Volumes' , sum(Unit_Cap_Cyl) as Sum_Unit_Cap_Cyl label='# Cylinders' from Work.DSPL_TBL GROUP BY Unit_Cap_Cyl having Unit_Cap_Cyl GE 0 order by Unit_Cap_Cyl; quit; Sum of defined cylinders by volume emulation type Unit_Cap_Cyl Volumes Cylinders 2107 32 67424 3339 576 1923264 5800 256 1484800 10017 2688 26925696 32760 160 5241600 65520 5561 3.6436E8 262668 80 21013440 263781 768 2.0258E8

lchristensen · ‎08-07-2022

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

lchristensen · ‎06-22-2022

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,

lchristensen · ‎03-20-2022

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.

ballardw · ‎08-31-2021

@lchristensen wrote: 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. Actually Excel doesn't know what any input is. It applies rules to each individual value because spreadsheets do not have the concept of "variable" with the same properties for all values. So depending on the ranges of values it treated some of the values as exponential. If you check closely in the Excel cell properties you would likely find that values like "8E0A" are actually character. One of the slightly advanced bits with data interchange is make your CSV directly from SAS, there are several ways such as Proc Export, and then do not open the file in Excel. Or if you must make sure that you do not save the file after opening in Excel. Other "nice" things that Excel will do is turn unquoted text values like 5-8 in a CSV file to a number representing the current year value of May 8 (possibly August 5 depending on system settings). Nothing like finding "dates" in the middle of a list of part numbers. The same comment applies to Tab delimited files if you have Excel associated with an extension that matches your file name.

lchristensen · ‎02-17-2021

Thanks. I've never used PROC REPORT but will look at it.

GraphGuy · ‎11-11-2020

One clarification on the terminology - I think you mean the X-axis, rather than the Legend(?) Since I don't have your data, I can't say for certain - but I suspect that the value you're plotting on the x-axis is character, rather than a numeric/datetime value. Convert those character values to numeric/datetime values, and then SAS won't feel compelled to show every x-value on the axis. 🙂

ballardw · ‎07-22-2020

Old and limited but if you are providing a known list of values for selection you might look into the WINDOW (data step) or %WINDOW (macro) to capture values as well. SAS/AF and FSP do take a lot of different work and may be overkill if you only need to collect a few strings.

Online Status	Offline
Date Last Visited	‎03-21-2024 03:57 PM

PROC SQL ON statement is rejecting a full dataset name period column n...

Re: SAS Macro: I need to put single quotes around the macro variable t...

Re: SAS Macro: I need to put single quotes around the macro variable t...

SAS Macro: I need to put single quotes around the macro variable to us...

Re: What is the best tool now for creating user menus? Something to be...

What is the best tool now for creating user menus? Something to be sim...

Re: Using a Windows folder in a filename statement and trying to write...

Re: Using a Windows folder in a filename statement and trying to write...

Re: Using a Windows folder in a filename statement and trying to write...

Using a Windows folder in a filename statement and trying to write man...

Re: SAS Macro: I need to put single quotes around the macro variable t...

Re: What is the best tool now for creating user menus? Something to be...

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

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

What is the best tool now for creating user menus? Something to be sim...

Re: Proc SQL Error with Summary functions are restricted tot he SELECT...

Re: PROC SQL ON statement is rejecting a full dataset name period colu...

Re: SAS Macro: I need to put single quotes around the macro variable t...

Re: What is the best tool now for creating user menus? Something to be...

Re: Using a Windows folder in a filename statement and trying to write...

Re: Learning PROC SQL and looking for a way to streamline what I have

Re: Proc SQL Error with Summary functions are restricted tot he SELECT...

Re: SGPLOT creating vertical lines for each data point

Re: SGPLOT need help with creating a vertical bar chart

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

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

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

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

Re: How to define and use panels.