https://communities.sas.com/t5/SAS-Programming/substr/m-p/848777#M335560 <P>Hello team</P> <P>What is the reason &nbsp;we use substr &nbsp;in a macro?</P> <P>I understand that some of the functions are built to be used in macro as well.</P> <P>respectfully,&nbsp;</P> <P>bittenapple</P> Fri, 09 Dec 2022 18:33:50 GMT GN0001 2022-12-09T18:33:50Z https://communities.sas.com/t5/SAS-Programming/substr/m-p/848777#M335560 <P>Hello team</P> <P>What is the reason &nbsp;we use substr &nbsp;in a macro?</P> <P>I understand that some of the functions are built to be used in macro as well.</P> <P>respectfully,&nbsp;</P> <P>bittenapple</P> Fri, 09 Dec 2022 18:33:50 GMT https://communities.sas.com/t5/SAS-Programming/substr/m-p/848777#M335560 GN0001 2022-12-09T18:33:50Z https://communities.sas.com/t5/SAS-Programming/substr/m-p/848778#M335561 <P>Macro functions, such as %SUBSTR, work on macro variables, and produce output that is can be manipulated by the macro processor.</P> <P>&nbsp;</P> <P>Data step functions, such as SUBSTR, work on data set variables, and produce output that can be used in the DATA step.</P> Fri, 09 Dec 2022 18:38:01 GMT https://communities.sas.com/t5/SAS-Programming/substr/m-p/848778#M335561 PaigeMiller 2022-12-09T18:38:01Z