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: 
anu1989s
‎03-30-2017
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Length of the value of the macro variable error (65534).

by Calcite | Level 5 in SAS Programming
‎03-25-2017 06:13 PM
‎03-25-2017 06:13 PM
Hello Kurt!   Thanks for the reply.   Based on these variables, I am creating a counter in my macro which will produce the output based on these multiple combinations.    Is there any other way where I can create a key which would be a combination of  multiple variable apart from the way I have created them in my earlier post?   Since i am new to macro I am unable to understand what exactly is the problem. Kindly help me resolve this issue. ... View more

Length of the value of the macro variable error (65534).

by Calcite | Level 5 in SAS Programming
‎03-25-2017 05:49 PM
‎03-25-2017 05:49 PM
Hi All, I am new to SAS Macros, any help would be appreciated.  I am creating a ID which is basically a combination of different variables, and then trying to call the distinct ids inside my macro. When I try to exceute the macro, I get the below mentioned error   ERROR: The length of the value of the macro variable DT1 (65540) exceeds the maximum length (65534). The value has been truncated to 65534 characters.   Can someone please help me resolve this error?   PFB the code I have written.   data test1; set test2; id1 = trim("_"||catx("_",put(minDate, date9.), put(maxDate, date9.), Sales_id ,Division, Roll_Up)); run;   proc sql; select distinct id1 into: dt1 separated by " " from test`; %macro dly_mlt_lock; ........... %mend   TIA ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-30-2017 12:48 AM
Quick links