Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- About colleenbogucki
12-17-2024
colleenbogucki
Calcite | Level 5
Member since
06-28-2022
- 7 Posts
- 1 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by colleenbogucki
Subject Views Posted 660 10-23-2024 02:45 PM 1146 09-19-2024 03:21 PM 1165 09-19-2024 02:58 PM 1184 09-19-2024 02:49 PM 1358 08-14-2024 09:57 AM 1489 08-13-2024 04:38 PM 1530 08-13-2024 03:51 PM -
Activity Feed for colleenbogucki
- Posted Call execute to label variables getting statement not valid error on SAS Programming. 10-23-2024 02:45 PM
- Posted Re: Extra space when using & macros not resolving correctly on SAS Programming. 09-19-2024 03:21 PM
- Posted Re: Extra space when using &&& macros not resolving correctly on SAS Programming. 09-19-2024 02:58 PM
- Posted Extra space when using && macros not resolving correctly on SAS Programming. 09-19-2024 02:49 PM
- Liked Re: Extra table row appearing when table spans pages when using proc report and ods tagsets.rtf for Ksharp. 08-14-2024 10:17 AM
- Posted Re: Extra table row appearing when table spans pages when using proc report and ods tagsets.rtf on SAS Programming. 08-14-2024 09:57 AM
- Posted Re: Extra table row appearing when table spans pages when using proc report and ods tagsets.rtf on SAS Programming. 08-13-2024 04:38 PM
- Posted Extra table row appearing when table spans pages when using proc report and ods tagsets.rtf on SAS Programming. 08-13-2024 03:51 PM
-
Posts I Liked
Subject Likes Author Latest Post 1
10-23-2024
02:45 PM
Hello, I am trying to systematically label newly created variables using the label of an old variable. When I use the call execute command, I am getting an error saying "Statement is not valid or it is used out proper order." I used this source as reference. %macro zscore(var=,);
proc means data = jobquality_2 noprint;
var &var.;
output out = &var._stat;
run;
*create macro var of var mean & std;
data _null_;
set &var._stat;
if _STAT_ = "MEAN" then call symputx('mean',&var.);
if _STAT_ = "STD" then call symputx('std',&var.);
run;
data &var._zscore;
set jobquality_2;
&var._m = &mean.;
&var._s = &std.;
&var._z = ((&var.-&var._m)/&var._s);
format &var.;
run;
*copy label from original var;
data &var._zscore;
set &var._zscore end=eof;
if eof then call execute ("label &var._z = "||'"'||strip(vlabel(&var.))||'";');
run;
%mend zscore;
%zscore(var=c11); 1 The SAS System 14:39 Wednesday, October 23, 2024
NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead.
NOTE: All registry changes will be lost at the end of the session.
WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this
session.
NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.
NOTE: All profile changes will be lost at the end of the session.
NOTE: Copyright (c) 2023 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M8)
Licensed to ABT ASSOCIATES INC - SERVICE PROVIDER, Site 70213852.
NOTE: This session is executing on the X64_DSRV22 platform.
NOTE: Analytical products:
SAS/STAT 15.3
SAS/ETS 15.3
SAS/IML 15.3
NOTE: Additional host information:
X64_DSRV22 WIN 10.0.20348 Server
NOTE: SAS initialization used:
real time 4.85 seconds
cpu time 0.31 seconds
1 options nofmterr;
2
3 libname data "S:\projects\HPOG_2.0_Eval\Analysis\01 Data\Special Topics\Job Quality";
NOTE: Libref DATA was successfully assigned as follows:
Engine: V9
Physical Name: S:\projects\HPOG_2.0_Eval\Analysis\01 Data\Special Topics\Job Quality
4 libname output "S:\projects\HPOG_2.0_Eval\Analysis\04 Outputs\Special Topics\Job Quality";
NOTE: Libref OUTPUT was successfully assigned as follows:
Engine: V9
Physical Name: S:\projects\HPOG_2.0_Eval\Analysis\04 Outputs\Special Topics\Job Quality
5
6 *read in cleaned data;
7
8 data jobquality_2;
9 set data.cleaned_longterm;
10 run;
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C2DKF was not found or could not be loaded.
NOTE: Format INDUSTRY was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C8AF was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C16DKF was not found or could not be loaded.
2 The SAS System 14:39 Wednesday, October 23, 2024
NOTE: Format INDUSTRY was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C26A_F was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format SCHEDULE was not found or could not be loaded.
NOTE: Format SCHEDULE2_F was not found or could not be loaded.
NOTE: Format SCHEDULE3_F was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format ALOT was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format SATISFIED was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format PROMOTIONS was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format X00001F was not found or could not be loaded.
NOTE: Format INDUSTRY was not found or could not be loaded.
NOTE: There were 1616 observations read from the data set DATA.CLEANED_LONGTERM.
NOTE: The data set WORK.JOBQUALITY_2 has 1616 observations and 59 variables.
NOTE: DATA statement used (Total process time):
real time 0.19 seconds
cpu time 0.07 seconds
11
12 *******************************************
13 *caluclate zscores for all variables;
14
15 %macro zscore(var=,);
16
17 proc means data = jobquality_2 noprint;
18 var &var.;
19 output out = &var._stat;
20 run;
21
22 *create macro var of var mean & std;
3 The SAS System 14:39 Wednesday, October 23, 2024
23 data _null_;
24 set &var._stat;
25 if _STAT_ = "MEAN" then call symputx('mean',&var.);
26 if _STAT_ = "STD" then call symputx('std',&var.);
27 run;
28
29 data &var._zscore;
30 set jobquality_2;
31 &var._m = &mean.;
32 &var._s = &std.;
33 &var._z = ((&var.-&var._m)/&var._s);
34 format &var.;
35 run;
36
37 *copy label from original var;
38 data &var._zscore;
39 set &var._zscore end=eof;
40 if eof then call execute ("label &var._z = "||'"'||strip(vlabel(&var.))||'";');
41 run;
42
43 %mend zscore;
44
45 %zscore(var=c11);
NOTE: There were 1616 observations read from the data set WORK.JOBQUALITY_2.
NOTE: The data set WORK.C11_STAT has 5 observations and 4 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.10 seconds
cpu time 0.03 seconds
NOTE: There were 5 observations read from the data set WORK.C11_STAT.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C2DKF was not found or could not be loaded.
NOTE: Format INDUSTRY was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C8AF was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C16DKF was not found or could not be loaded.
NOTE: Format INDUSTRY was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C26A_F was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format SCHEDULE was not found or could not be loaded.
NOTE: Format SCHEDULE2_F was not found or could not be loaded.
4 The SAS System 14:39 Wednesday, October 23, 2024
NOTE: Format SCHEDULE3_F was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format ALOT was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format SATISFIED was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format PROMOTIONS was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format X00001F was not found or could not be loaded.
NOTE: Format INDUSTRY was not found or could not be loaded.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
1545 at 61:120
NOTE: There were 1616 observations read from the data set WORK.JOBQUALITY_2.
NOTE: The data set WORK.C11_ZSCORE has 1616 observations and 62 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C2DKF was not found or could not be loaded.
NOTE: Format INDUSTRY was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C8AF was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C16DKF was not found or could not be loaded.
NOTE: Format INDUSTRY was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format C26A_F was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format SCHEDULE was not found or could not be loaded.
5 The SAS System 14:39 Wednesday, October 23, 2024
NOTE: Format SCHEDULE2_F was not found or could not be loaded.
NOTE: Format SCHEDULE3_F was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format ALOT was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format SATISFIED was not found or could not be loaded.
NOTE: Format AGREE was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format PROMOTIONS was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format YESNO was not found or could not be loaded.
NOTE: Format X00001F was not found or could not be loaded.
NOTE: Format INDUSTRY was not found or could not be loaded.
NOTE: There were 1616 observations read from the data set WORK.C11_ZSCORE.
NOTE: The data set WORK.C11_ZSCORE has 1616 observations and 62 variables.
NOTE: DATA statement used (Total process time):
real time 0.05 seconds
cpu time 0.03 seconds
NOTE: CALL EXECUTE generated line.
NOTE: Line generated by the CALL EXECUTE routine.
1 + label c11_z = "C11. About how much did you typically earn per hour before taxes?";
_____
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
46 %zscore(var=c11a);
NOTE: The SAS System stopped processing this step because of errors.
NOTE: Due to ERROR(s) above, SAS set option OBS=0, enabling syntax check mode.
This prevents execution of subsequent data modification statements.
WARNING: The data set WORK.C11A_STAT may be incomplete. When this step was stopped there were 0
observations and 0 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
6 The SAS System 14:39 Wednesday, October 23, 2024
cpu time 0.01 seconds
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
386: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 386-185: Expecting an arithmetic expression.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
WARNING: Apparent symbolic reference MEAN not resolved.
386: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 386-185: Expecting an arithmetic expression.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
WARNING: Apparent symbolic reference STD not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.C11A_ZSCORE may be incomplete. When this step was stopped there were 0
observations and 62 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.C11A_ZSCORE has 0 observations and 62 variables.
WARNING: Data set WORK.C11A_ZSCORE was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
47 %zscore(var=c13);
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.C13_STAT may be incomplete. When this step was stopped there were 0
observations and 0 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
7 The SAS System 14:39 Wednesday, October 23, 2024
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
386: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 386-185: Expecting an arithmetic expression.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
WARNING: Apparent symbolic reference MEAN not resolved.
386: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 386-185: Expecting an arithmetic expression.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
WARNING: Apparent symbolic reference STD not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.C13_ZSCORE may be incomplete. When this step was stopped there were 0
observations and 62 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.C13_ZSCORE has 0 observations and 62 variables.
WARNING: Data set WORK.C13_ZSCORE was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
48 %zscore(var=c18);
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.C18_STAT may be incomplete. When this step was stopped there were 0
observations and 0 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
8 The SAS System 14:39 Wednesday, October 23, 2024
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
386: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 386-185: Expecting an arithmetic expression.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
WARNING: Apparent symbolic reference MEAN not resolved.
386: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 386-185: Expecting an arithmetic expression.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
WARNING: Apparent symbolic reference STD not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.C18_ZSCORE may be incomplete. When this step was stopped there were 0
observations and 62 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.C18_ZSCORE has 0 observations and 62 variables.
WARNING: Data set WORK.C18_ZSCORE was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
49 %zscore(var=c18a);
ERROR: Variable C18A not found.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.C18A_STAT may be incomplete. When this step was stopped there were 0
observations and 0 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: DATA statement used (Total process time):
9 The SAS System 14:39 Wednesday, October 23, 2024
real time 0.00 seconds
cpu time 0.00 seconds
386: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 386-185: Expecting an arithmetic expression.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
WARNING: Apparent symbolic reference MEAN not resolved.
386: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 386-185: Expecting an arithmetic expression.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where
the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
WARNING: Apparent symbolic reference STD not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.C18A_ZSCORE may be incomplete. When this step was stopped there were 0
observations and 63 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.C18A_ZSCORE has 0 observations and 63 variables.
WARNING: Data set WORK.C18A_ZSCORE was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
ERROR: Errors printed on pages 5,6,7,8,9.
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 5.64 seconds
cpu time 0.56 seconds
... View more
09-19-2024
03:21 PM
Ahh, I didn't realize I should include the asterisks. I removed the space by using symputx instead of symput. Thanks so much! Also thanks for the tip on the numbered variables.
... View more
09-19-2024
02:58 PM
560 *******************************************
561 ** NHWC RCQI Dashboard Input Creator
562 *******************************************;
563 options mprint;
564
565 *** Set up input/output destinations;
566 libname inputse "S:\projects\Workforce_Institute\5. RCQI\1. Phase One\7. Stakeholder
566! Engagements\SAS Datasets\Test";
NOTE: Libref INPUTSE was successfully assigned as follows:
Engine: V9
Physical Name: S:\projects\Workforce_Institute\5. RCQI\1. Phase One\7. Stakeholder
Engagements\SAS Datasets\Test
567 libname inputhc "S:\projects\Workforce_Institute\5. RCQI\1. Phase One\7. Stakeholder
567! Engagements\SAS Datasets\Test";
NOTE: Libref INPUTHC refers to the same physical library as INPUTSE.
NOTE: Libref INPUTHC was successfully assigned as follows:
Engine: V9
Physical Name: S:\projects\Workforce_Institute\5. RCQI\1. Phase One\7. Stakeholder
Engagements\SAS Datasets\Test
568 libname inputttl "S:\projects\Workforce_Institute\5. RCQI\1. Phase One\7. Stakeholder
568! Engagements\SAS Datasets\Test";
NOTE: Libref INPUTTTL refers to the same physical library as INPUTHC.
NOTE: Libref INPUTTTL was successfully assigned as follows:
Engine: V9
Physical Name: S:\projects\Workforce_Institute\5. RCQI\1. Phase One\7. Stakeholder
Engagements\SAS Datasets\Test
569 libname inputws "S:\projects\Workforce_Institute\5. RCQI\1. Phase One\8. Workshops\SAS Datasets";
NOTE: Libref INPUTWS was successfully assigned as follows:
Engine: V9
Physical Name: S:\projects\Workforce_Institute\5. RCQI\1. Phase One\8. Workshops\SAS Datasets
570 libname inputot "S:\projects\Workforce_Institute\5. RCQI\1. Phase One\9. OT Events\SAS Datasets";
NOTE: Libref INPUTOT was successfully assigned as follows:
Engine: V9
Physical Name: S:\projects\Workforce_Institute\5. RCQI\1. Phase One\9. OT Events\SAS Datasets
571
572 %let filepath="S:\projects\Workforce_Institute\5. RCQI\0. Dashboard\Input Files\Phase
572! One\DashboardInput_(%sysfunc(today(),mmddyyd10.)).xlsx";
573 %put &=filepath;
FILEPATH="S:\projects\Workforce_Institute\5. RCQI\0. Dashboard\Input Files\Phase
One\DashboardInput_(09-19-2024).xlsx"
574
575 %let setup="S:\projects\Workforce_Institute\5. RCQI\0. Dashboard\DashboardInputFile.csv";
576
577
578 proc format;
579 value good
580 1 = 'Very poor'
581 2 = 'Poor'
582 3 = 'Average'
583 4 = 'Good'
584 5 = 'Very good';
NOTE: Format GOOD is already on the library WORK.FORMATS.
NOTE: Format GOOD has been output.
585
586 value agree
587 1 = 'Strongly disagree'
588 2 = 'Disagree'
589 3 = 'Neither agree nor disagree'
590 4 = 'Agree'
591 5 = 'Strongly agree';
NOTE: Format AGREE is already on the library WORK.FORMATS.
NOTE: Format AGREE has been output.
592
593 value duration
594 1 = 'Far too short'
595 2 = 'Slightly too short'
596 3 = 'Perfect length'
597 4 = 'Slightly too long'
598 5 = 'Far too long';
NOTE: Format DURATION is already on the library WORK.FORMATS.
NOTE: Format DURATION has been output.
599
600 value future
601 1 = 'Very unlikely'
602 2 = 'Unlikely'
603 3 = 'Neutral'
604 4 = 'Likely'
605 5 = 'Very likely';
NOTE: Format FUTURE is already on the library WORK.FORMATS.
NOTE: Format FUTURE has been output.
606 run;
NOTE: PROCEDURE FORMAT used (Total process time):
real time 0.02 seconds
cpu time 0.03 seconds
607
608 *make table shells;
609
610 data role_shell;
611 length role $37.;
612 infile datalines dlm='|';
613 input role $ sort;
614 datalines;
NOTE: The data set WORK.ROLE_SHELL has 7 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
622 ;
623 run;
624
625 data org_shell;
626 length org $40.;
627 infile datalines dlm = '|';
628 input org $ sort;
629 datalines;
NOTE: The data set WORK.ORG_SHELL has 6 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
636 ;
637 run;
638
639 data hptp_shell;
640 length hptp $12.;
641 input hptp $ sort;
642 datalines;
NOTE: The data set WORK.HPTP_SHELL has 3 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
646 ;
647 run;
648
649
650 data duration_shell;
651 length duration $18.;
652 infile datalines dlm='|';
653 input duration $ sort;
654 datalines;
NOTE: The data set WORK.DURATION_SHELL has 5 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
660 ;
661 run;
662
663 data good_shell;
664 length value $10;
665 infile datalines dlm='|';
666 input value $ sort;
667 datalines;
NOTE: The data set WORK.GOOD_SHELL has 5 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
673 ;
674 run;
675
676 data agree_shell;
677 length value $26;
678 infile datalines dlm='|';
679 input value $ sort;
680 datalines;
NOTE: The data set WORK.AGREE_SHELL has 5 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
686 ;
687 run;
688
689 data likely_shell;
690 length value $26;
691 infile datalines dlm='|';
692 input value $ sort;
693 datalines;
NOTE: The data set WORK.LIKELY_SHELL has 5 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
699 ;
700 run;
701
702 ********************************************
703 Step 1: Read in input file;
704 *******************************************;
705
706 proc import datafile = &setup.
707 dbms = csv
708 out = setup
709 replace;
710 guessingrows=max;
711 run;
712 /**********************************************************************
713 * PRODUCT: SAS
714 * VERSION: 9.4
715 * CREATOR: External File Interface
716 * DATE: 19SEP24
717 * DESC: Generated SAS Datastep Code
718 * TEMPLATE SOURCE: (None Specified.)
719 ***********************************************************************/
720 data WORK.SETUP ;
721 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
722 infile 'S:\projects\Workforce_Institute\5. RCQI\0. Dashboard\DashboardInputFile.csv'
722! delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
723 informat event_type $2. ;
724 informat event_num best32. ;
725 informat rcqi_1 $9. ;
726 informat rcqi_2 $12. ;
727 informat rcqi_3 $10. ;
728 informat rcqi_4 $6. ;
729 informat rcqi_5 $2. ;
730 informat rcqi_6 $2. ;
731 informat rcqi_7 $1. ;
732 informat likert_1 $5. ;
733 informat likert_2 $4. ;
734 informat likert_3 $4. ;
735 informat likert_4 $4. ;
736 informat likert_5 $5. ;
737 informat likert_6 $5. ;
738 informat likert_7 $1. ;
739 informat oe_1 $9. ;
740 informat oe_2 $7. ;
741 informat oe_3 $11. ;
742 informat oe_4 $11. ;
743 informat oe_5 $8. ;
744 informat oe_6 $3. ;
745 informat oe_7 $1. ;
746 format event_type $2. ;
747 format event_num best12. ;
748 format rcqi_1 $9. ;
749 format rcqi_2 $12. ;
750 format rcqi_3 $10. ;
751 format rcqi_4 $6. ;
752 format rcqi_5 $2. ;
753 format rcqi_6 $2. ;
754 format rcqi_7 $1. ;
755 format likert_1 $5. ;
756 format likert_2 $4. ;
757 format likert_3 $4. ;
758 format likert_4 $4. ;
759 format likert_5 $5. ;
760 format likert_6 $5. ;
761 format likert_7 $1. ;
762 format oe_1 $9. ;
763 format oe_2 $7. ;
764 format oe_3 $11. ;
765 format oe_4 $11. ;
766 format oe_5 $8. ;
767 format oe_6 $3. ;
768 format oe_7 $1. ;
769 input
770 event_type $
771 event_num
772 rcqi_1 $
773 rcqi_2 $
774 rcqi_3 $
775 rcqi_4 $
776 rcqi_5 $
777 rcqi_6 $
778 rcqi_7 $
779 likert_1 $
780 likert_2 $
781 likert_3 $
782 likert_4 $
783 likert_5 $
784 likert_6 $
785 likert_7 $
786 oe_1 $
787 oe_2 $
788 oe_3 $
789 oe_4 $
790 oe_5 $
791 oe_6 $
792 oe_7 $
793 ;
794 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
795 run;
NOTE: The infile 'S:\projects\Workforce_Institute\5. RCQI\0. Dashboard\DashboardInputFile.csv' is:
Filename=S:\projects\Workforce_Institute\5. RCQI\0. Dashboard\DashboardInputFile.csv,
RECFM=V,LRECL=32767,File Size (bytes)=997,
Last Modified=19Sep2024:13:41:42,
Create Time=19Sep2024:12:43:46
NOTE: 8 records were read from the infile 'S:\projects\Workforce_Institute\5. RCQI\0.
Dashboard\DashboardInputFile.csv'.
The minimum record length was 78.
The maximum record length was 119.
NOTE: The data set WORK.SETUP has 8 observations and 23 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds
8 rows created in WORK.SETUP from S:\projects\Workforce_Institute\5. RCQI\0.
Dashboard\DashboardInputFile.csv.
NOTE: WORK.SETUP data set was successfully created.
NOTE: The data set WORK.SETUP has 8 observations and 23 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.27 seconds
cpu time 0.25 seconds
796
797 ************************************************************************************
798 STEP 2a: Create macro lists of variables from the input excel. Macro will iterate
799 through these lists to produce outputs.
800 ***********************************************************************************;
801
802 proc sql noprint;
803 create table macros as
804 select event_type
805 ,event_num
806 ,rcqi_1
807 ,rcqi_2
808 ,rcqi_3
809 ,rcqi_4
810 ,rcqi_5
811 ,rcqi_6
812 ,rcqi_7
813 ,likert_1
814 ,likert_2
815 ,likert_3
816 ,likert_4
817 ,likert_5
818 ,likert_6
819 ,likert_7
820 ,oe_1
821 ,oe_2
822 ,oe_3
823 ,oe_4
824 ,oe_5
825 ,oe_6
826 ,oe_7
827 from setup
828 order by event_type, event_num
829 ;
NOTE: Table WORK.MACROS created, with 8 rows and 23 columns.
830
831 /*Create a macro that holds a list of the column values from the input csv. In step 2b, we number
831! each value so the do loop
832 can run through each row of the csv using their numbered suffix. */
833 select event_type into: event_type separated by " "
834 from setup;
835 select event_num into: event_num separated by " "
836 from setup;
837 select rcqi_1 into: rcqi_1 separated by " "
838 from setup;
839 select rcqi_2 into: rcqi_2 separated by " "
840 from setup;
841 select rcqi_3 into: rcqi_3 separated by " "
842 from setup;
843 select rcqi_4 into: rcqi_4 separated by " "
844 from setup;
845 select rcqi_5 into: rcqi_5 separated by " "
846 from setup;
847 select rcqi_6 into: rcqi_6 separated by " "
848 from setup;
849 select rcqi_7 into: rcqi_7 separated by " "
850 from setup;
851 select likert_1 into: likert_1 separated by " "
852 from setup;
853 select likert_2 into: likert_2 separated by " "
854 from setup;
855 select likert_3 into: likert_3 separated by " "
856 from setup;
857 select likert_4 into: likert_4 separated by " "
858 from setup;
859 select likert_5 into: likert_5 separated by " "
860 from setup;
861 select likert_6 into: likert_6 separated by " "
862 from setup;
863 select likert_7 into: likert_7 separated by " "
864 from setup;
865 select oe_1 into: oe_1 separated by " "
866 from setup;
867 select oe_2 into: oe_2 separated by " "
868 from setup;
869 select oe_3 into: oe_3 separated by " "
870 from setup;
871 select oe_4 into: oe_4 separated by " "
872 from setup;
873 select oe_5 into: oe_5 separated by " "
874 from setup;
875 select oe_6 into: oe_6 separated by " "
876 from setup;
877 select oe_7 into: oe_7 separated by " "
878 from setup;
879
880 *create macro that identifies the number of each type of event;
881 select count(event_type) into: max_se
882 from setup
883 where event_type='se';
884 select count(event_type) into: max_ws
885 from setup
886 where event_type='ws';
887 *create macro that identifies the last row in format csv to use as end of do loop in step 5;
888 select count(event_type) into: max
889 from setup;
890
891 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.09 seconds
cpu time 0.09 seconds
892
893 run;
894
895 *******************************************************************************
896 ** STEP 2b: Use the macro list created in step 2a to create numbered macros that
897 will allow us to iterate through each row of the input csv
898 (e.g., event_type_1 = se, rcqi_1 = Q7, etc.
899 ******************************************************************************;
900
901 data _null_;
902 set setup;
903 call symput(strip(cats("event_type_",_N_)),event_type);
904 call symput(strip(cats("event_num_",_N_)),event_num);
905 call symput(strip(cats("rcqi_1_",_N_)),rcqi_1);
906 call symput(strip(cats("rcqi_2_",_N_)),rcqi_2);
907 call symput(strip(cats("rcqi_3_",_N_)),rcqi_3);
908 call symput(strip(cats("rcqi_4_",_N_)),rcqi_4);
909 call symput(strip(cats("rcqi_5_",_N_)),rcqi_5);
910 call symput(strip(cats("rcqi_6_",_N_)),rcqi_6);
911 call symput(strip(cats("rcqi_7_",_N_)),rcqi_7);
912 call symput(strip(cats("likert_1_",_N_)),likert_1);
913 call symput(strip(cats("likert_2_",_N_)),likert_2);
914 call symput(strip(cats("likert_3_",_N_)),likert_3);
915 call symput(strip(cats("likert_4_",_N_)),likert_4);
916 call symput(strip(cats("likert_5_",_N_)),likert_5);
917 call symput(strip(cats("likert_6_",_N_)),likert_6);
918 call symput(strip(cats("likert_7_",_N_)),likert_7);
919 call symput(strip(cats("oe_1_",_N_)),oe_1);
920 call symput(strip(cats("oe_2_",_N_)),oe_2);
921 call symput(strip(cats("oe_3_",_N_)),oe_3);
922 call symput(strip(cats("oe_4_",_N_)),oe_4);
923 call symput(strip(cats("oe_5_",_N_)),oe_5);
924 call symput(strip(cats("oe_6_",_N_)),oe_6);
925 call symput(strip(cats("oe_7_",_N_)),oe_7);
926
927 run;
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
904:47
NOTE: There were 8 observations read from the data set WORK.SETUP.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
928
929 *************************************************************************
930 STEP 3: Do processing code using macro that will run for each row of the
931 input csv.
932 *************************************************************************;
933
934
935 %macro dashboard;
936
937 %do i=1 %to &max.;
938
939 proc sql noprint;
940 create table &&event_type_&i.._&&event_num_&i.._complete as
941 select "Completed RCQI" as cat, count(*) as N_&&event_num_&i..
942 from input&&event_type_&i...&&event_type_&i.._&&event_num_&i.;
943 quit;
944
945 %end;
946
947 %mend dashboard;
948
949 %dashboard;
MPRINT(DASHBOARD): proc sql noprint;
NOTE: Line generated by the macro variable "EVENT_NUM_1".
1 se_ 1_complete
-
22
200
NOTE 138-205: Line generated by the macro variable "EVENT_NUM_1".
1 N_ 1
-
22
ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: ',', LEN, LENGTH.
NOTE: Line generated by the macro variable "EVENT_NUM_1".
1 inputse.se_ 1
-
22
76
MPRINT(DASHBOARD): create table se_ 1_complete as select "Completed RCQI" as cat, count(*) as N_ 1
from 1;
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
MPRINT(DASHBOARD): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
MPRINT(DASHBOARD): proc sql noprint;
NOTE: Line generated by the macro variable "EVENT_NUM_2".
1 se_ 2_complete
-
22
200
NOTE 138-205: Line generated by the macro variable "EVENT_NUM_2".
1 N_ 2
-
22
ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: ',', LEN, LENGTH.
NOTE: Line generated by the macro variable "EVENT_NUM_2".
1 inputse.se_ 2
-
22
76
MPRINT(DASHBOARD): create table se_ 2_complete as select "Completed RCQI" as cat, count(*) as N_ 2
from 2;
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
MPRINT(DASHBOARD): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.03 seconds
MPRINT(DASHBOARD): proc sql noprint;
NOTE: Line generated by the macro variable "EVENT_NUM_3".
1 se_ 3_complete
-
22
200
NOTE 138-205: Line generated by the macro variable "EVENT_NUM_3".
1 N_ 3
-
22
ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: ',', LEN, LENGTH.
NOTE: Line generated by the macro variable "EVENT_NUM_3".
1 inputse.se_ 3
-
22
76
MPRINT(DASHBOARD): create table se_ 3_complete as select "Completed RCQI" as cat, count(*) as N_ 3
from 3;
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
MPRINT(DASHBOARD): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
MPRINT(DASHBOARD): proc sql noprint;
NOTE: Line generated by the macro variable "EVENT_NUM_4".
1 ws_ 1_complete
-
22
200
NOTE 138-205: Line generated by the macro variable "EVENT_NUM_4".
1 N_ 1
-
22
ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: ',', LEN, LENGTH.
NOTE: Line generated by the macro variable "EVENT_NUM_4".
1 inputws.ws_ 1
-
22
76
MPRINT(DASHBOARD): create table ws_ 1_complete as select "Completed RCQI" as cat, count(*) as N_ 1
from 1;
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
MPRINT(DASHBOARD): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
MPRINT(DASHBOARD): proc sql noprint;
NOTE: Line generated by the macro variable "EVENT_NUM_5".
1 ws_ 2_complete
-
22
200
NOTE 138-205: Line generated by the macro variable "EVENT_NUM_5".
1 N_ 2
-
22
ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: ',', LEN, LENGTH.
NOTE: Line generated by the macro variable "EVENT_NUM_5".
1 inputws.ws_ 2
-
22
76
MPRINT(DASHBOARD): create table ws_ 2_complete as select "Completed RCQI" as cat, count(*) as N_ 2
from 2;
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
MPRINT(DASHBOARD): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
MPRINT(DASHBOARD): proc sql noprint;
NOTE: Line generated by the macro variable "EVENT_NUM_6".
1 ws_ 3_complete
-
22
200
NOTE 138-205: Line generated by the macro variable "EVENT_NUM_6".
1 N_ 3
-
22
ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: ',', LEN, LENGTH.
NOTE: Line generated by the macro variable "EVENT_NUM_6".
1 inputws.ws_ 3
-
22
76
MPRINT(DASHBOARD): create table ws_ 3_complete as select "Completed RCQI" as cat, count(*) as N_ 3
from 3;
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
MPRINT(DASHBOARD): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
MPRINT(DASHBOARD): proc sql noprint;
NOTE: Line generated by the macro variable "EVENT_NUM_7".
1 ws_ 4_complete
-
22
200
NOTE 138-205: Line generated by the macro variable "EVENT_NUM_7".
1 N_ 4
-
22
ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: ',', LEN, LENGTH.
NOTE: Line generated by the macro variable "EVENT_NUM_7".
1 inputws.ws_ 4
-
22
76
MPRINT(DASHBOARD): create table ws_ 4_complete as select "Completed RCQI" as cat, count(*) as N_ 4
from 4;
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
MPRINT(DASHBOARD): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
MPRINT(DASHBOARD): proc sql noprint;
NOTE: Line generated by the macro variable "EVENT_NUM_8".
1 ws_ 5_complete
-
22
200
NOTE 138-205: Line generated by the macro variable "EVENT_NUM_8".
1 N_ 5
-
22
ERROR 22-322: Syntax error, expecting one of the following: (, '.', AS, LIKE.
ERROR 200-322: The symbol is not recognized and will be ignored.
ERROR 22-322: Syntax error, expecting one of the following: ',', LEN, LENGTH.
NOTE: Line generated by the macro variable "EVENT_NUM_8".
1 inputws.ws_ 5
-
22
76
MPRINT(DASHBOARD): create table ws_ 5_complete as select "Completed RCQI" as cat, count(*) as N_ 5
from 5;
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
MPRINT(DASHBOARD): quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
950
951 %put &event_num_1;
1
... View more
09-19-2024
02:49 PM
Hello, I am using a csv to generate variable lists in macros so I can run code through the rows of the csv. When I run the code below I get a syntax error on all the references to &&event_num_&i.. It's weird because the macro seems to be resolving correctly. The log shows the correct values (in the screenshot the event_num = 5), but there is this extra space which causes the syntax error (see screenshot). %macro dashboard; %do i=1 %to &max.; proc sql noprint; create table &&event_type_&i.._&&event_num_&i.._complete as select "Completed RCQI" as cat, count(*) as N_&&event_num_&i.. from input&&event_type_&i...&&event_type_&i.._&&event_num_&i.; quit; %end; %mend dashboard; %dashboard;
... View more
08-14-2024
09:57 AM
This worked!! Thank you so much.
... View more
08-13-2024
04:38 PM
Thanks for the suggestion. If you run what you have, the word "Continued" still appears in the box and sometimes causes a page break.
... View more
08-13-2024
03:51 PM
Hello, I am using ods tagsets.rtf to print several outputs of proc report to a word document. Everything is working well except an extra table row/page break appears whenever one of the tables spans multiple pages (pic below). It appears as a black rectangle at the top or bottom of the page then the rest of the table is either a page below or right below. It originally said "Continued" in it but I used the pretext="" code in the template to make it blank. Anybody know how to get rid of the actual box and space it takes up? I want no message of "continued" and no indication that the table was split, I just want the table to continue on the next page. I can't post the data. My template code: proc template; define style styles.siteprofile; parent=styles.sasweb; style Continued from Continued / pretext=""; style parskip / fontsize = 1pt; end; run; My ods code: ods tagsets.rtf file="filepath\file.rtf" startpage=off style=styles.siteprofile uniform; title "County1"; proc report data = county1._admin style(header)={background=aliceblue foreground=black}; column administrative col1; define administrative / style(column)=[cellwidth=4.5in] style(header)=[just=l];; define col1 / '' style(column)=[cellwidth=2.5in]; run; proc report data = county1._fund style(header)={background=aliceblue foreground=black}; column funding col1; define funding / style(column)=[cellwidth=4.5in] style(header)=[just=l]; define col1 / '' style(column)=[cellwidth=2.5in]; run; proc report data = &county._rentasst style(header)={background=aliceblue foreground=black}; column assistance col1; define assistance / style(column)=[cellwidth=4.5in] style(header)=[just=l]; define col1 / '' style(column)=[cellwidth=2.5in]; run; ods tagsets.rtf close; I've also tried adding "class continued / width=0%" to the template and it just makes the box small, but the page break is still there. @Cynthia_sas
... View more
