@Feifeitubies wrote:
Hi guys, i am new in SAS programming and i got stuck in defining macro variable from my code:
How new is "new"? Unless you have a very strong background with general text processing in another programming language I would recommend not starting with macros until you have a fairly good grounding in basic SAS usage.
I said "general text processing" because all the macro language is designed for is to automate generation of SAS code, ie. program text.
For instance your code look like you are attempting to extract three values from three data sets based on the value of a another variable and then combine them. Having an explicit value of As_of_date makes me think you are going to do this for many values of the date.
You would likely be better off joining the three data sets on the As_of_date variable, and creating your weighted variable as a calculation for all matching values of the date in a single pass through the data. If you have a specific range of dates then that could be specified in a where clause with either the IN operator or a range using Between, or a combination.
... View more