BookmarkSubscribeRSS Feed
u_chandra
Calcite | Level 5

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);

1 REPLY 1
PaigeMiller
Diamond | Level 26

You don't even attempt to state a question.

Please have a look at this:

--
Paige Miller

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1023 views
  • 1 like
  • 2 in conversation