cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Michelle_
‎11-07-2023
  • 7 Posts
  • 6 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Call Macro in a Macro

by Fluorite | Level 6 in SAS Enterprise Guide
‎08-21-2023 04:50 AM
‎08-21-2023 04:50 AM
Apologies. Can ignore the previous coding i asked. The issue seems like appear after the %datecreate macro.  If only run until %setting then it works. However, when run one more macro (i.e. %datecreate) then it won't auto generate the second and third run.  So, i have create delete specific global macro.    %macro repeat(n); %do i = 1 %to &n.; %if &i. = 1 %then %do; %let month = 4; %let lag = 2; %end; %if &i. = 2 %then %do; %let month = 7; %let lag = 2; %end; %if &i. = 3 %then %do; %let month = 4; %let lag = 1; %end; %month_setting; %setting; %datecreate; %deleteALL; %end; %mend; %repeat(3); %macro month_setting; %global begin end; %if %sysevalf(&lag = 2) %then %do; %let begin = "%sysfunc(intnx(month,%sysfunc(inputN(&period.01,yymmdd10.)),-&month.),date9.)"d; %let end = "%sysfunc(intnx(month,%sysfunc(inputN(&period.01,yymmdd10.)), +&lag.),date9.)"d; %end; %else %if %sysevalf(&lag = 1) %then %do; %let begin = "%sysfunc(intnx(month,%sysfunc(inputN(&period.01,yymmdd10.)),-&month.+1),date9.)"d; %let end = "%sysfunc(intnx(month,%sysfunc(inputN(&period.01,yymmdd10.)), +&lag.+1),date9.)"d; %end; %let end_YM = %sysfunc(inputn(%sysfunc(substr(%sysfunc(putn(&end., yymmddn8.)),1, 6)), 6.)); %let beg_YM = %sysfunc(inputn(%sysfunc(substr(%sysfunc(putn(&begin., yymmddn8.)),1, 6)), 6.)); %mend; /*macro sample*/ %macro setting; Data working.M&Month._Setting; month = &month.; lag = &lag.; begin = put(&begin.,yymmddn8.); end = put(&end.,yymmddn8.); run; %mend; %macro datecreate; %global dif; %let dif = %sysfunc(intck(MONTH,&begin,&end)); %do i= 1 %to &dif; %global date_&i; %let date_&i=%sysfunc(intnx(month,&begin,&i,B),yymmn6.); %put &&date_&i; %end; %mend; %macro deleteALL; options nonotes; %local vars; proc sql noprint; select name into: vars separated by ' ' from dictionary.macros where scope = 'GLOBAL' and (name contains 'DATE_' or name in ('MONTH', 'LAG', 'BEGIN','END', 'BEG_YM', 'END_YM', 'DIF')); quit; %symdel &vars; options notes; %put NOTE: Macro variables deleted.; %mend; But, the above coding not working also. It didn't pop any errors. However, it will not generate the results for Month 7  + Lag 2 and Month 4 + lag 1.  ... View more

Re: Call Macro in a Macro

by Fluorite | Level 6 in SAS Enterprise Guide
‎08-21-2023 02:16 AM
‎08-21-2023 02:16 AM
No error pop up.  It only able to run one times.  I have write %repeat(3). But, it only able to run &i.= 1 ... View more

Call Macro in a Macro

by Fluorite | Level 6 in SAS Enterprise Guide
‎08-17-2023 09:39 PM
‎08-17-2023 09:39 PM
Hi all, seeking help on how to write a macro to call another macro for different period. I have different setting to run each month. Im wondering can I write a macro to auto repeat run the same macro.    %macro repeat(n); %do i = 1 %to &n.; %if &i. = 1 %then %do; %let month = 4; %let lag = 2; %end; %if &i. = 2 %then %do; %let month = 7; %let lag = 2; %end; %if &i. = 3 %then %do; %let month = 4; %let lag = 1; %end; %month_setting; %setting; %end; %mend; %repeat(3); %macro month_setting; %global begin end; %if %sysevalf(&lag = 2) %then %do; %let begin = "%sysfunc(intnx(month,%sysfunc(inputN(&period.01,yymmdd10.)),-&month.),date9.)"d; %let end = "%sysfunc(intnx(month,%sysfunc(inputN(&period.01,yymmdd10.)), +&lag.),date9.)"d; %end; %else %if %sysevalf(&lag = 1) %then %do; %let begin = "%sysfunc(intnx(month,%sysfunc(inputN(&period.01,yymmdd10.)),-&month.+1),date9.)"d; %let end = "%sysfunc(intnx(month,%sysfunc(inputN(&period.01,yymmdd10.)), +&lag.+1),date9.)"d; %end; %let end_YM = %sysfunc(inputn(%sysfunc(substr(%sysfunc(putn(&end., yymmddn8.)),1, 6)), 6.)); %let beg_YM = %sysfunc(inputn(%sysfunc(substr(%sysfunc(putn(&begin., yymmddn8.)),1, 6)), 6.)); %mend; /*macro sample*/ %macro setting; Data working.M&Month._Setting; month = &month.; lag = &lag.; begin = put(&begin.,yymmddn8.); end = put(&end.,yymmddn8.); run; %mend;     ... View more

Re: Connection to ODBC

by Fluorite | Level 6 in New SAS User
‎07-17-2023 09:12 AM
‎07-17-2023 09:12 AM
It works. I have to add the %sysfunc in the &period_YM too. Thanks! ... View more

Connection to ODBC

by Fluorite | Level 6 in New SAS User
‎07-17-2023 02:12 AM
‎07-17-2023 02:12 AM
Hi all, seeking help on the coding below. I would like to set %let statement to read the period equal to 2 months after begin date.  (i.e. 202304) If i direct set period_YM = 202304, the program is works. However, instead of direct set the period_YM, i would like to build a %let statement to calculate in future. But, the error pop up as below. Would like to seek any solution to solve this issue?   ERROR: CLI describe error: [Oracle][ODBC][Ora]ORA-00907: missing right parenthesis : [Oracle][ODBC]Invalid descriptor index <1>.   %let begin = 202302; %let period = "%sysfunc(intnx(month,%sysfunc(inputN(&begin.01,yymmdd10.)),+2),date9.)"d; %let period_YM = input(substr(put(&period., yymmddn8.),1, 6), 6.); Proc sql; CONNECT TO ODBC (DATAsrc=KPODA01 USER=&OD_USER_ID PASSWORD=&OD_PASSWORD); CREATE TABLE working.output as select * from connection to ODBC (select distinct Column 1, Column 2 from oracle.File_Name_&period_YM.);     Thanks in advance!    ... View more

Re: The %TO value of the %DO I loop is invalid

by Fluorite | Level 6 in New SAS User
‎07-15-2023 02:33 AM
‎07-15-2023 02:33 AM
It works! Thank you so much. ... View more

The %TO value of the %DO I loop is invalid

by Fluorite | Level 6 in New SAS User
‎07-14-2023 02:08 PM
‎07-14-2023 02:08 PM
Hi all, i have write the macro as shown below. Initially, I direct put the begin date and end date (example stated in orange font below). The macro manages to run.  However, for ease of efficiency in future, I would like to set a formula to indicate the begin date and end date.  But, it pops the error as below.   ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: &dif ERROR: The %TO value of the %DO I loop is invalid. ERROR: The macro DATECREATE will stop executing.   %let Period = 202304; %let Month = 4; %macro month_setting(); %global begin end; %if %sysevalf(&month = 4) %then %do; %let begin = put(intnx('month',input(strip(put(&period, 6.)||'01'), yymmdd10.), -6), date9.); %let end = put(intnx('month',input(strip(put(&period, 6.)||'01'), yymmdd10.), -1), date9.); /* %let begin = 01OCT2022;*/ /* %let end = 01APR2023;*/ %end; %else %if %sysevalf(&month = 13) %then %do; %let begin = put(intnx('month',input(strip(put(&period, 6.)||'01'), yymmdd10.), -13), date9.); %let end = put(intnx('month',input(strip(put(&period, 6.)||'01'), yymmdd10.), -1), date9.); /* %let begin = 01JAN2022;*/ /* %let end = 01APR2023;*/ %end; %mend month_setting; %month_setting(); %macro datecreate; %let startdate = %sysfunc(inputn(&begin,anydtdte9.)); %let enddate = %sysfunc(inputn(&end,anydtdte9.)); %let dif = %sysfunc(intck(MONTH,&startdate,&enddate)); %do i=0 %to &dif; %global date_&i; %let date_&i=%sysfunc(intnx(month,&startdate,&i,B),yymmn6.); %put &&date_&i; %end; %mend; %datecreate; Would like to seek for help to solve the issue. Thanks in advance!    ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-07-2023 02:40 PM
Likes given to
Quick links