About G_I_Jeff

G_I_Jeff · ‎12-17-2013

I'm trying to play around with e-mailing basic 'excel' documents from z/OS. So far I've been able to create a simple workbook with one spreadsheet saved in a PDSE member. I can browse the member and see the xml code. But when I e-mail as attachment, it comes up empty. I don't think its a problem with the ODS logic but with what type of attachment I'm trying to tell the mainframe SMTP to send. My questions are: Is e-mailing basic spreadsheets from z/OS using Base SAS possible and if so, is my code sound? Is there a better way to store the xml code, possibly through Unix System Services? Thanks.

G_I_Jeff · ‎09-19-2013

Thanks Tom and Anca. Your examples proved to be helpful and I'm able to complete my example!

G_I_Jeff · ‎09-19-2013

Tom, That's a great example and your using SQL which I haven't attempted yet. I'll give it a shot! Jeff

G_I_Jeff · ‎09-19-2013

I've attached my original SAS code. Possible someone can see in it what I would like to change: For every SGPLOT and TABULATE procedure I would like to create a macro that the SYSTEM variable is passed to and loop through all unique values of the SYSTEM variable I can get the unique values of SYSTEM from the very first SUMMARY procedure I execute in the code

G_I_Jeff · ‎09-19-2013

Astounding, I don't have a program yet because I'm trying to design/write it and using the example I gave in my initial post is my attempt to do/show what I'm trying to accomplish. I can't even tell you if what I want to accomplish can be done. I'm reading articles about assigning macro arrays and trying it myself. I basically want to loop through unique variable values from a DATA step, that's it. The code I currently have is iterative logic that have hard coded values through multiple graphing statements to produce web reports and is growing. I don't want to have to add code every time the data changes. I'm probably not explaining myself properly.

G_I_Jeff · ‎09-19-2013

Here is what I am trying to accomplish, through this example (and pardon my SAS code, I'm winging this): DATA TESTS; INPUT NAME $ SCORE1 SCORE2 SCORE3 SCORE4 SCORE5 SCORE6 SCORE7 SCORE8 SCORE9 SCORE10; CARDS; ALICE 100 97.3 88.9 85.5 91.2 88.8 93.4 98.1 100 92 CARRIE 88.7 81.4 92.8 92.1 93 93.7 92 81.9 85.5 84 DARRYL 92.3 91 91 86.9 85 84.1 81.8 87.5 91 92.3 FRANK 79.8 77 82 85.7 85.5 81.2 88 79.9 77 86.6 HOLLY 83.4 85.1 88.7 92 81.3 84 81.9 87.3 80.6 79.6 JENNIFER 85.3 88.6 87.1 82.9 89.5 88.7 92.8 95.8 93.3 98.2 JOHN 76.3 77.3 82.5 84 73.8 78.3 80.2 80.9 79.7 84.8 MIKE 100 100 97.6 96.7 99.8 98 95.9 97.8 100 97.3 SALLY 86.6 89 92.3 94.5 86.1 91 91.7 86.4 91 91.9 TOM 86.4 88.2 81.9 84 85 82.6 91.7 88.2 91.7 84.8 ; RUN; PROC SUMMARY DATA=TESTS; BY NAME; VAR SCORE1; OUTPUT OUT=STUDENTS SUM=; %ARRAY(STUDENT,DATA=STUDENTS,VAR=NAME); %DO %STUDENT=1 to n (n being the max number of variables in macro array STUDENT); PROC SGPLOT DATA=HISTORY CYCLEATTRS; WHERE STUDENT=%STUDENT; TITLE ' Student's grade history'; VBAR DATE / FILL RESPONSE=GRADES DATALABEL LEGENDLABEL='Students grades'; VBAR DATE / FILL RESPONSE=AVERAGE DATALABEL LEGENDLABEL='District averages'; XAXIS LABEL='Date'; YAXIS LABEL='Grades'; RUN; PROC TABULATE DATA=TESTS F=COMMA3.1; WHERE NAME=%STUDENT ...... RUN; %END

G_I_Jeff · ‎09-19-2013

I'm trying to assign an array with the summarized student names so that I can use it through a loop.

G_I_Jeff · ‎09-19-2013

Need to remove growing iterative SAS code for graphing data by a single variable. I've started reading up on macros and have tried the following (as an example): DATA TESTS; INPUT NAME $ SCORE1 SCORE2 SCORE3 SCORE4 SCORE5 SCORE6 SCORE7 SCORE8 SCORE9 SCORE10; CARDS; ALICE 100 97.3 88.9 85.5 91.2 88.8 93.4 98.1 100 92 CARRIE 88.7 81.4 92.8 92.1 93 93.7 92 81.9 85.5 84 DARRYL 92.3 91 91 86.9 85 84.1 81.8 87.5 91 92.3 FRANK 79.8 77 82 85.7 85.5 81.2 88 79.9 77 86.6 HOLLY 83.4 85.1 88.7 92 81.3 84 81.9 87.3 80.6 79.6 JENNIFER 85.3 88.6 87.1 82.9 89.5 88.7 92.8 95.8 93.3 98.2 JOHN 76.3 77.3 82.5 84 73.8 78.3 80.2 80.9 79.7 84.8 MIKE 100 100 97.6 96.7 99.8 98 95.9 97.8 100 97.3 SALLY 86.6 89 92.3 94.5 86.1 91 91.7 86.4 91 91.9 TOM 86.4 88.2 81.9 84 85 82.6 91.7 88.2 91.7 84.8 ; RUN; PROC SUMMARY DATA=TESTS; BY NAME; VAR SCORE1; OUTPUT OUT=STUDENTS SUM=; %ARRAY(STUDENT,DATA=STUDENTS,VAR=NAME); I keep getting "ERROR 180-322: STATEMENT IS NOT VALID OR IT IS USED OUT OF PROPER ORDER." on the %ARRAY line. I tried simple %LET logic and it works fine assigning macro variables values. I'm am new to macro logic in SAS and am a little stumped on this one. Is there a better way I should be accomplishing this? Once I get an array, I want to loop through macro logic that produces several graphs for each variable. Thanks for any help/suggestions! Jeff

G_I_Jeff · ‎07-10-2013

Astounding, I totally agree with you and I believe that your numeric example should be working, but it doesn't. This is my exact code (latest I've tried). DEVNR is type=num len=5 format=HEX4: IF PUT(DEVNR,HEX4.) = 06X THEN DEVTYPE='V'; ELSE DEVTYPE='P'; My education/training tells me that the actual DEVNR field should look like '06EA0F', a 3 byte length field. When I list the variable, it shows a 4 numeric ( I assume) length field in the listing. Is SAS maybe padding this field with zeros? Is it NOT storing it as a true HEX compressed field? Or am I totally way off base here?

G_I_Jeff · ‎07-10-2013

data_null_; Thanks for the example. I can reference the first byte of the HEX field, but I need to check the first character. I know how to accomplish this in COBOL or Assembler, just don't know how to do it in SAS. Sorry, should have made myself a little clearer. I need to check the first character to see if it's a numeric 6 to assign another field a value: IF X1 =: '06'X THEN X2 = 'A'; I'm not 100% clear on how SAS is storing this value. I see the format in the storing pdb is HEX4, but it seems SAS is treating the value as character (which is baffling me).

G_I_Jeff · ‎07-10-2013

I need to check the value of the first byte from a HEX4 format field. The value of the first observation is: 6EA0. I've tried assiging the field to a defined character field in a data step and checking the substr(*,1,1) and various other ways with no success.

G_I_Jeff · ‎05-07-2013

Creating 1 pdb from multiple: DATA PDB1; SET PDBA SET PDBB SET PDBC SET PDBD SET PDBE; Is there a way to create and set a single variable with a value to distinguish each SET pdb? PDB=A for all observations from PDBA, so on and so on..... Jeff

G_I_Jeff · ‎02-05-2013

The real question is, can I imbed macro calls inside ODS statements, especially graphing procedures? Thanks for the link!

G_I_Jeff · ‎02-05-2013

Yes, I am trying to do 2+ (probably adding more in the future) procedures for each unique value of a variable before the next itteration. Guess I need to pick up a macro book. Never used them yet.

G_I_Jeff · ‎02-05-2013

Thanks Reeza, I have been using those in my original code. The code I'm uploading is just stuff I'm playing around with. But I do appreciate any helpful tips I can get!

Online Status	Offline
Date Last Visited	‎02-06-2024 05:52 PM

Re: Formatting change with email change

Re: Formatting change with email change

Re: Formatting change with email change

Re: Formatting change with email change

Formatting change with email change

SMTP to CSSMTP formatting

Re: Create variable from multiple sources

Re: Create variable from multiple sources

Create variable from multiple sources

Re: No lables header in ODS output?

Re: Create variable from multiple sources

Re: Create variable from multiple sources

Re: No lables header in ODS output?

Re: INPUT date conversion

Re: Conversions on space input field

Re: Summarize variables on PROC SQL UNION?

Can you use FIND function in SQL?

TAGSET.EXCELXP z/OS question

Re: Help with array macro (or possibly better way)?

Re: Help with array macro (or possibly better way)?

Re: Help with array macro (or possibly better way)?

Re: Help with array macro (or possibly better way)?

Re: Help with array macro (or possibly better way)?

Re: Help with array macro (or possibly better way)?

Help with array macro (or possibly better way)?

Re: Checking first byte of HEX4 format?

Re: Checking first byte of HEX4 format?

Checking first byte of HEX4 format?

Can you set a variable's value during multiple sets?

Re: Need to loop through unique variable from data step.

Re: Need to loop through unique variable from data step.

Re: Need to loop through unique variable from data step.