cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Rain_28
‎05-26-2022
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Assigning value to a macro variable within a datastep (without cal...

by Calcite | Level 5 in SAS Programming
‎04-27-2022 12:30 PM
‎04-27-2022 12:30 PM
Yes, the code worked by writing the whole datastep in call execute...this is the first time I wrote complicated call execute within multiple loops in a macro. It took me couple of days but got it....Thank you so much! Really appreciate your help. ... View more

Re: Assigning value to a macro variable within a datastep (without cal...

by Calcite | Level 5 in SAS Programming
‎04-22-2022 07:46 PM
‎04-22-2022 07:46 PM
Memname is actually a dataset name and dates is actual date variable (that I am extracting from _var1). want to put Dates in macro variable and call datasets with call execute. As the loop iterates want to pick memname and correspondaing dates variable from that memname.   MEMNAME  _var1 dates XY        XYSTDAT_1 xystdat ab abdat_1 abdat cd cddat_1 cddat   call execute('data test; set "||strip(libname)||"."||strip(memname)||"; %DT(DAT=&x);..........   There are 100s of datasets in memname and I don't know dates in each of those datasets. I am trying to identify date variable from the dataset and use those in call execute ... View more

Assigning value to a macro variable within a datastep (without call sy...

by Calcite | Level 5 in SAS Programming
‎04-22-2022 07:13 PM
‎04-22-2022 07:13 PM
Dummy Data: MEMNAME  _var1     var2      var3 var4 XY        XYSTDAT_1 XYENDAT_2 XYXYDDAT_3 XYXYDAT_4   I am looking for 2 different out in 2 different macro variables within a datastep:  1st macro variable should have XYSTDAT 2nd macro variable should have TEST_XYSTDAT   How do I assign value from this "strip(reverse(substr(strip(reverse(testcase(i))),3)));" to a macro variable? 1) %let x = strip(reverse(substr(strip(reverse(testcase(i))),3))); ------> will not work 2) b = strip(reverse(substr(strip(reverse(testcase(i))),3)));      %let y = b; ----------------------> is not resolving either 3) %let z = TEST_&x.  ----> Z resolves to TEST_strip(reverse(substr(strip(reverse(testcase(i))),3)))   I am looking for a solution without using Call Symput (I get desired value with this), because I want to use the macro variable within the same datastep as the loop iterates.   Appreciate your input! Thanks!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-26-2022 03:34 PM
Quick links