Hello Experts,   I have following code;   %Macro Relcontclien_Module(); Proc sql; Create table IFRS.RELCONTCLIEN_&Period._Nordic as select Distinct "&date."d format YYMMDDn8. as FECREPOR, /*Format conversion needed */ Country_ISO_01 format $5. as CORUNIT, /*Clarification need on how to report unit*/ Contract_Key as CODCONTR, CustomerID as CODIDPER, '1' as CODINTER from IFRS.Module_Cal_&Period._Nordic order by Contract_Key; quit; %Mend; When I run it, it displays the following error in the log; NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. But the Log summary has not got any error marks. I have already seen other posts on the same question. I could not figure out still how to fix it.    Thanks in advance ... View more

Hi experts,   I have the following macro and I want the macro to assign correct values.   %Macro Month_Pre_Selection (close, period1); %if &Close. = 1 %then %do; %let input_contracts = CONTRACT_&period1.; %let input_customers = CUSTOMER_&period1.; %let input_object = OBJECT_&period1.; %let input_payplan = PAYMENTPLAN_&period1.; %end; %if &Close. = 2 %then %do; %let input_contracts = CONTRACT_&period1._PRE; %let input_customers = CUSTOMER_&period1._PRE; %let input_object = OBJECT_&period1._PRE; %let input_payplan = PAYMENTPLAN_&period1._PRE; %end; %mend; when I run it with following code    %Month_Pre_Selection (1, 201805); %put &input_contracts; I get the following message in the log WARNING: Apparent symbolic reference INPUT_CONTRACTS not resolved. &input_contracts What am I doing wrong?   Thanks in advance.   ... View more

Hi all!   I would have to use a dataset that is provided by another unit. last part of the dataset name(day part) changes each month, and rest stays the same. such as    datasetxyz_20180523 datasetxyz_20180630 datasetxyz_20180710   I want my code to pick up the correct dataset when I run. If I am running on 2018 may, it should grab the dataset --> datasetxyz_20180523.    Please help me how to achieve this.    Thanks in advance     ... View more

I have following table     I want to have previous month data joined to the table. something like this.     Please help me.   ... View more

Hi!   Is there a way to combine multiple program into one single program? I need to print the file for reference.   Thanks in advance. ... View more

Hi! I do not understand why my second column does not read as date.   data test; input date_one date9. date_two date9. ; datalines; 10Jan2000 20Mar2010 ; run; As I am new to SAS, please help me.     Thanks in advance ... View more

I am new to sas. I am trying to run following code. It runs for ever. What am I doing wrong? I am tryting to see how many years it takes to payback loan.       data loan; initial_payment=1000; loan=30000-initial_payment; payment=500; years=0; do until (loan_end=0); years+1; loan_end=loan-payment; end; run; Thanks in advance.           run;   ... View more