Hi, Can anyone take a look at my proc sql syntax error. I am not able to spot the error. SYMBOLGEN:  Macro variable PCODE2 resolves to AE MPRINT(_BUILD_METRICS):   CREATE TABLE WORK.AE_LINE_DELTA_Voc  AS SELECT t1.AELine as t1.AELineA, t1._AE_CustomHrBin as _AE_CustomHrBinA, t1.AEUnit as AEUnitA, t1._TYPE_, t1._FREQ_, t1.AE_Voc_Mean as AE_Voc_Mean_A , t2.AE_Voc_Mean AS AE_Voc_Mean_B , (t1.AE_Voc_Mean - t2.AE_Voc_Mean)  AS AE_Voc_Delta, t1.AE_Voc_stddev as t1.AE_Voc_stddev_A, t1.AE_Voc_var as t1.AE_Voc_var_A, t1.AE_Voc_sum as t1.AE_Voc_sum_A, t1.AE_Voc_N as t1.AE_Voc_N_A, t1.AE_Voc_nmiss as t1.AE_Voc_nmiss_A, t2.AELine AS AELineB, t2._AE_CustomHrBin AS _AE_CustomHrBinB, t2.AEUnit AS AEUnitB, t2._TYPE_ AS _TYPE_1, t2._FREQ_ AS _FREQ_1, t2.AE_Voc_stddev AS total_eff_StdDev_B, t2.AE_Voc_var AS total_eff_Var_B, t2.AE_Voc_sum AS total_eff_Sum_B, t2.AE_Voc_N AS total_eff_N_B, t2.AE_Voc_nmiss AS total_eff_NMiss_B FROM WORK.AE_LINE_DELTA_Voc t1, WORK.AE_LINE_DELTA_Voc t2 WHERE (t1.AEUnit = t2.AEUnit AND t1._AE_CustomHrBin = t2._AE_CustomHrBin) AND (t1.AELine CONTAINS 'A' AND t2.AELine CONTAINS 'B'); ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN,               LENGTH, TRANSCODE. ERROR 76-322: Syntax error, statement will be ignored. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. MPRINT(_BUILD_METRICS):   QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds Thanks, saspert ... View more

Hi, I have using sas macro to check the current system time and do calculations based on it. However, I am getting an error. Can someone point out if I have incorrect data usage? %global timeflag tc; %macro _timecheck; data _null_; call symput ('tc',strip(minute(time()))); run; %put "&tc is the system time" ; %if 0<= &tc <= 29 %then %do; %let timeflag = A ; %put "the flag is set to &timeflag"; %end; %else %if 30<= &tc <= 59 %then %do; %let timeflag = B; %put "the flag is set to &timeflag"; %end; %mend _timecheck; %_timecheck            (CATS('PBG',LEFT(put(t2.&prcname.Plant,11.),2), SUBSTR(t2.&prcname.Line,1,1))) LABEL="&prcname. Unit" AS             &prcname.Unit,           /* _30mintime */             (PUT(round(t2.&prcname.Time,hms(0,30,00)), DATETIME.)) LABEL="&prcname._30mintime" AS &prcname._30mintime,           /* _1hrtime */             (PUT(round(intnx('hour',t2.&prcname.Time,-1 )), DATETIME.) ) LABEL="&prcname._1hrtime" AS &prcname._1hrtime,           /* _daytime */             (put(datepart(t2.&prcname.Time), MMDDYY10.)) LABEL="&prcname._daytime" AS &prcname._daytime,           /* _CustomHrBin */             (CASE             WHEN ( &timeflag = A) and ( 0<= (minute(t2.&prcname.Time)) <= 29 )  THEN             PUT(round(t2.&prcname.Time,hms(1,0,00)), DATETIME.)             WHEN (  &timeflag = A) and ( 30<= (minute(t2.&prcname.Time)) <= 59 )  then PUT(intnx('hour'             ,round(t2.&prcname.Time,hms(1,0,00)),-1), DATETIME.)             when (  &timeflag = B) and ( 0<= (minute(t2.&prcname.Time)) <= 29 ) then PUT(intnx('minutes',             round(t2.&prcname.Time,hms(1,0,00)), -30),DATETIME.)             when   (  &timeflag = B)  and  ( 30<= (minute(t2.&prcname.Time)) <= 59 ) then PUT(intnx('minute'             ,round(t2.&prcname.Time,hms(1,0,00)),-30),DATETIME.)             END                         )  AS _&prcname._CustomHrBin SYMBOLGEN:  Macro variable PRCNAME resolves to FinalSim "the currenct process being executed is FinalSim" SYMBOLGEN:  Macro variable PRCNAME resolves to FinalSim SYMBOLGEN:  Macro variable TIMEFLAG resolves to A WARNING: Function LEFT requires at most 1 argument(s). The extra one(s) will be ignored. NOTE: A CASE expression has no ELSE clause. Cases not accounted for by the WHEN clauses will result in a missing value for the CASE       expression. ERROR: The following columns were not found in the contributing tables: A, B. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. MPRINT(_BUILD_METRICS):   QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds The case statement above worked before substituting the macro variable. Thanks, Raj. ... View more

Hi, Need help on running the macro to declare numbered macro variables like pcode1, pcode2.... data  MESTGT.include_processes; length pname $20.; cards; Finalsim ; run; data  _null_; set MESTGT.include_processes; symput ('pcode'||_n_,pname); symput ('nobs', _n_); ; run; Error is below - NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).       30:23   31:22   ERROR: Symbolic variable name PCODE           1 must contain only letters, digits, and underscores. NOTE: Invalid argument to function SYMPUT at line 30 column 6. pname=  _ERROR_=1 _N_=1 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1 observations read from the data set MESTGT.INCLUDE_PROCESSES. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds Thanks, saspert. ... View more

Hi, I have an issue with one of the datasets I am working on. The two date fields in my dataset are as below - 48 ELGBGNDT Num 8 MMDDYY10. 34 ELIGDT Num 8 MMDDYY10. DATE9. ELIGDT When I run this code, I get back 0 records which I am not able to resolve. data MHTST.MKTLVL_MBR_201112; set MHTST.FINALMBR; if eligdt='12/31/2011' then output; run; These are the values for the two variables in the sas dataset. ELIGDT      ELGBGNDT 07/31/2011 07/01/2011 08/31/2011 08/01/2011 09/30/2011 09/01/2011 10/31/2011 10/01/2011 11/30/2011 11/01/2011 12/31/2011 12/01/2011 Any suggestions are appreciated. Thanks, saspert ... View more