About laura6728

laura6728 · ‎08-04-2016

That works perfectly, thank you so much!

laura6728 · ‎08-04-2016

Is it possible to have default code appear when I open a new program in Enterprise Guide? For instance, our department has a program header that we place at the top of all of our programs. Is there a way to make that appear when I open a new program to enter code? Right now I have to open the header in notepad++ and copy/paste it in; just trying to see if there is a way to utilize my time better 🙂 Thanks!

laura6728 · ‎05-13-2016

This worked perfectly, thank you so much!!

laura6728 · ‎05-13-2016

This is getting me towards what I am looking for!! Thank you so much! One last question, is it possible to do a file break after the end of the last call execute? This is putting the file in the correct order which, is great because then even if I have to manually break up the pdf file, that's a lot easier than reorganizing or recompiling files.

laura6728 · ‎05-12-2016

Unfortunately that doesn't work either. It puts all my procs into one file, but all the tables from the first proc print, then all the tables from the second. I want the table from proc print 1 & print 2 to show on one page per by grouping.

laura6728 · ‎05-12-2016

In the code below my intent is to have the two proc prints print on either the same page or one on page one & the other on page two of a pdf document. I have by groups on both proc print statements, but what I end up with is 50+ pdfs. 2 per by group, one with the 1st proc print and one with the 2nd proc print. Is there a way to have them both print on the same, and keep the by groupings? I have read several articles using regions, listings and/or macros and none would give me what I was really looking for, and I think it is my groupings messing it up. Tips/ideas? ods pdf file="\\MCC-DATA\IEDATA\Projects\CE_Evals\&YEAR.&QUARTER.\summary.pdf" newfile=bygroup startpage=yes notoc style=MyJournal3; OPTIONS NONUMBER NODATE; TITLE "Summary Results for Continuing Education Courses Taught During &YEAR. - &QUARTER."; PROC PRINT DATA=WORK.RESULTS_TOTALS LABEL WIDTH=FULL NOOBS; BY TITLE INSTRUCTOR; WHERE QUESTION <= 'Q14'; VAR QUESTION SA PERCENT_SA A PERCENT_A D PERCENT_D SD PERCENT_SD; LABEL SA = 'Strongly Agree' PERCENT_SA = '% Strongly Agree' A = 'Agree' PERCENT_A = '% Agree' D = 'Disagree' PERCENT_D = '% Disagree' SD = 'Strongly Disagree' PERCENT_SD = '% Strongly Disagree' TITLE = 'Course' INSTRUCTOR = 'Instructor'; RUN; PROC PRINT DATA=WORK.RESULTS_TOTALS LABEL NOOBS; BY TITLE INSTRUCTOR; WHERE QUESTION = 'Q15'; VAR QUESTION EX PERCENT_EX GD PERCENT_GD AV PERCENT_AV BAV PERCENT_BAV PR PERCENT_PR; LABEL EX = 'Excellent' PERCENT_EX = '% Excellent' GD = 'Good' PERCENT_GD = '% Good' AV = 'Average' PERCENT_AV = '% Average' BAV = 'Below Average' PERCENT_BAV = '% Below Average' PR = 'Poor' PERCENT_PR = '% Poor'; RUN; ods pdf close;

laura6728 · ‎05-12-2016

I'm not sure if you got this working yet or not. I have the following code between my ods pdf code that works and puts it all on one page of my pdf. TITLE1 "Profile of all Students, &LTERM. &YEAR5. to &LTERM. &YEAR1."; TITLE2 'Gender'; FOOTNOTE1; PROC TABULATE DATA=WORK.DEMO_&STERM._ALL; VAR TOTAL; CLASS TERM/ ORDER=UNFORMATTED MISSING; CLASS SEX / ORDER=UNFORMATTED MISSING; TABLE SEX={LABEL=''} all = 'Total' , TERM={LABEL=''} *(TOTAL={LABEL=''} * N={LABEL="#" S=[CELLWIDTH=.5in]}*f=comma6. TOTAL={LABEL=''} * ColPctN={LABEL="%" S=[CELLWIDTH=.5in]}*f=pctfmt. );; FORMAT SEX $SEX.; RUN; RUN; QUIT; ods startpage=no; /* GENDER TREND CHART */ PROC SGPLOT DATA=WORK.&STERM._GENDER noborder; VBAR TERM / GROUP = SEX RESPONSE = PERCENT DATALABEL=PERCENT DATASKIN=PRESSED; YAXIS LABEL = ' '; XAXIS LABEL = ' '; TITLE 'Percent of Enrollment'; DISCRETELEGEND / TITLE=''; FORMAT SEX $SEX.; RUN;

laura6728 · ‎08-13-2015

This is what I ultimately used and worked, thank you!

laura6728 · ‎05-29-2015

Thank you, I am going to try this and see how it goes!

laura6728 · ‎05-29-2015

What should I do or search for on how to accomplish this? Is there a specific macro I can use?

laura6728 · ‎05-29-2015

Is it possible for code to be ran by cycling through macros that I have listed? For example, I am trying to run the exact same code three, on 3 different main datasets; One dataset is all course types, one is face to face only course types, and the last is online only course types. Right now I have three separate SAS files, one for each course type previously listed. Is there a way that I can write a macro or program to run all the code for all course types, then run again for face to face, and then again for online? I know that I can create macro variables and change the macro three times and have it work, but can I have it 'cycle' or 'run' through 3 macros that I have listed with changing it and running it 3 times, or running 3 separate files? Reasoning for wanting this: Since the three files are exact with the exception of the main datasets used initially and the naming of created datasets (i.e. face to face have F2F_ as a prefix on all WORK files and internet have IT_), I am thinking that if I have an addition or edit I think have to edit 3 files, rather than just one. Editing that many files can lead to more errors that may be avoidable. Thanks in advance!

laura6728 · ‎04-14-2015

Ugh such a rookie mistake!! DEAN is character not numeric, so I needed the ""! I also didn't have the "" in the where statement. I've ran it 4 times now and it is working like a champ. Thank you so much!

laura6728 · ‎04-14-2015

Adding %put DEAN1A = >>&DEAN1A<< ; before my tabulate didn't work. I thought it had, but now i reran it to show a coworker and it populated the same error.

laura6728 · ‎04-14-2015

I made a couple changes and now get the following error log: 7959 PROC TABULATE 7960 DATA=GRDDIST.&STERM.vpi_secgcat; SYMBOLGEN: Macro variable STERM resolves to FA14 7961 BY DIV; 7962 WHERE DEAN = &DEAN1A.; SYMBOLGEN: Macro variable DEAN1A resolves to 1 ERROR: WHERE clause operator requires compatible variables. 7963 VAR CAMPUS; 7964 CLASS grdcat DPT COURSE name_1 SEC3 / ORDER=UNFORMATTED MISSING; 7965 CLASSLEV grdcat; 7966 CLASSLEV DPT / STYLE=[OUTPUTWIDTH=1in]; 7967 CLASSLEV COURSE / STYLE=[OUTPUTWIDTH=.5in]; 7968 CLASSLEV name_1 / STYLE=[OUTPUTWIDTH=2in]; 7969 CLASSLEV SEC3 / STYLE=[OUTPUTWIDTH=.5in]; 7970 7971 TABLE 7972 /* ROW Statement */ 7973 DPT={LABEL=""}*COURSE={LABEL=""}*name_1={LABEL=""}*SEC3={LABEL=""}, 7974 /* COLUMN Statement */ 7975 grdcat={LABEL=""} *(CAMPUS={LABEL=""} * N={LABEL="#" S=[CELLWIDTH=.5in]} CAMPUS={LABEL=""} 7976 * RowPctN={LABEL="%" S=[CELLWIDTH=.5in]}*f=pctfmt.) 7977 all = 'Total' *(CAMPUS={LABEL=""} * N={LABEL="#" S=[CELLWIDTH=.5in]} CAMPUS={LABEL=""} 7978 * RowPctN={LABEL="%" S=[CELLWIDTH=.5in]}*f=pctfmt.) ; 7979 ; 7980 RUN; CODE: %let DEAN1A = 1; /* Dean of Arts & Sciences Code (1) */ PROC TABULATE DATA=GRDDIST.&STERM.vpi_secgcat; BY DIV; WHERE DEAN = &DEAN1A.; VAR CAMPUS; CLASS grdcat DPT COURSE name_1 SEC3 / ORDER=UNFORMATTED MISSING; CLASSLEV grdcat; CLASSLEV DPT / STYLE=[OUTPUTWIDTH=1in]; CLASSLEV COURSE / STYLE=[OUTPUTWIDTH=.5in]; CLASSLEV name_1 / STYLE=[OUTPUTWIDTH=2in]; CLASSLEV SEC3 / STYLE=[OUTPUTWIDTH=.5in]; TABLE /* ROW Statement */ DPT={LABEL=""}*COURSE={LABEL=""}*name_1={LABEL=""}*SEC3={LABEL=""}, /* COLUMN Statement */ grdcat={LABEL=""} *(CAMPUS={LABEL=""} * N={LABEL="#" S=[CELLWIDTH=.5in]} CAMPUS={LABEL=""} * RowPctN={LABEL="%" S=[CELLWIDTH=.5in]}*f=pctfmt.) all = 'Total' *(CAMPUS={LABEL=""} * N={LABEL="#" S=[CELLWIDTH=.5in]} CAMPUS={LABEL=""} * RowPctN={LABEL="%" S=[CELLWIDTH=.5in]}*f=pctfmt.) ; ; RUN; QUIT;

laura6728 · ‎04-14-2015

I have the code below that I am trying to run, but keep getting errors on the where clause. The error is "Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, GE, GT, LE, LT, NE, NOT, OR, ^, ^=, |, ||, ~, ~=" Is there something else I can do to get this to work? I'm new to SAS so I'm open to suggestions if this is possible. %let DEAN1A = 1; /* Dean of Arts & Sciences Code (1) */ PROC TABULATE DATA=GRDDIST.&STERM.vpi_secgcat; BY DIV; WHERE DEAN = &DEAN1A.; VAR CAMPUS; CLASS grdcat DPT COURSE name_1 SEC3 / ORDER=UNFORMATTED MISSING; CLASSLEV grdcat; CLASSLEV DPT / STYLE=[OUTPUTWIDTH=1in]; CLASSLEV COURSE / STYLE=[OUTPUTWIDTH=.5in]; CLASSLEV name_1 / STYLE=[OUTPUTWIDTH=2in]; CLASSLEV SEC3 / STYLE=[OUTPUTWIDTH=.5in]; TABLE /* ROW Statement */ DPT={LABEL=""}*COURSE={LABEL=""}*name_1={LABEL=""}*SEC3={LABEL=""}, /* COLUMN Statement */ grdcat={LABEL=""} *(CAMPUS={LABEL=""} * N={LABEL="#" S=[CELLWIDTH=.5in]} CAMPUS={LABEL=""} * RowPctN={LABEL="%" S=[CELLWIDTH=.5in]}*f=pctfmt.) all = 'Total' *(CAMPUS={LABEL=""} * N={LABEL="#" S=[CELLWIDTH=.5in]} CAMPUS={LABEL=""} * RowPctN={LABEL="%" S=[CELLWIDTH=.5in]}*f=pctfmt.) ; ; RUN; QUIT;

Online Status	Offline
Date Last Visited	‎09-10-2024 07:34 PM

Auto Delete Temporary Files

ODS PDF Filename from Variable

Re: ODS PDF Unwanted Blank Pages

ODS PDF Unwanted Blank Pages

Graphs repeated on ODS PDF output

Re: Tabulate & Template Issues

Re: Tabulate & Template Issues

Tabulate & Template Issues

Re: Updating Macro Variable with Macro?

Updating Macro Variable with Macro?

Re: Format Title

Re: ods text html link

Re: Proc print - Center justify column heading

Re: Proc Tabulate Column Boarders

Re: Default Code in New Program

Re: Default Code in New Program

Default Code in New Program

Re: ODS pdf with 2 proc prints in same page with by groups

Re: ODS pdf with 2 proc prints in same page with by groups

Re: ODS pdf with 2 proc prints in same page with by groups

ODS pdf with 2 proc prints in same page with by groups

Re: ods pdf 2 different reports in same page

Re: Cycle Through Maco List?

Re: Cycle Through Maco List?

Re: Cycle Through Maco List?

Cycle Through Maco List?

Re: Macro in Where within Tabulate?

Re: Macro in Where within Tabulate?

Re: Macro in Where within Tabulate?

Macro in Where within Tabulate?