DATA Step, Macro, Functions and more

Dear All

Reply
New Contributor
Posts: 3

Dear All

infile ‘path/file*.txt.’ filename = dfnVAR;

%LET dfnLEN = LENGTH(dfnVAR);

%LET dfnSTART = dfnLEN – 15;

%LET MONTH = substr(dfnVAR, dfnSTART + 5, 2);

%LET FYread = substr(dfnVAR, dfnSTART + 3, 2);

%LET FYint = input(FYread, 2.);

%LET MONTHint = input(MONTH, 2.);

IF MONTHint > 9 THEN FYint = FYint + 1;

%LET FYstr = put(FYint, hex2.);

%LET FY = CAT(“FY”, FYstr);

%LET QRT = 0;

IF MONTHint < 4 THEN QRT = 2;

ELSE IF MONTHint < 7 THEN QRT = 3;

ELSE IF MONTHint < 10 THEN QRT = 4;

ELSE QRT = 1;

%LET QRT_YR_FULL = CAT(“Q”, QRT, “FY20”, FYstr);

Trusted Advisor
Posts: 1,615

Re: Dear All

You don't even attempt to state a question.

Please have a look at this:

Ask a Question
Discussion stats
  • 1 reply
  • 138 views
  • 1 like
  • 2 in conversation