Solved: Re: Fetching previous dates - SAS Support Communities

☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.

Calcite | Level 5

Calcite | Level 5

Fetching previous dates

Posted 03-17-2023 03:45 AM (1328 views)

I have a dataset with quarter end dates such as:
Date
31.03.2022
30.06.2022
30.09.2022
31.12.2022

Using one date i need to fetch the data with the previous date. (Eg: fetch data with 30.09.2022 using date 31.12.2022)How can i do this. Please provide a solution.

1 ACCEPTED SOLUTION

Accepted Solutions

Super User

Super User

Re: Fetching previous dates

Posted 03-17-2023 04:44 AM (1285 views) | In reply to hasnasherin

Use the INTNX Function with a "qtr" interval and "end" alignment.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

View solution in original post

1 REPLY 1

Super User

Super User

Re: Fetching previous dates

Posted 03-17-2023 04:44 AM (1286 views) | In reply to hasnasherin

Use the INTNX Function with a "qtr" interval and "end" alignment.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

744853-sas-innovate-data-ai (1).jpg

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →