Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Macro Definition Not Working
KLaz, I had some time to work on this and I added the following statement: %global nbr_&num.; The macro is working now! Here's the full code. Thanks for your help. -Javi %macro javi(num); %global nbr_&num.; proc sql noprint; select "'"||trim(a.vkont)||"'" into :nbr_&num. separated by ' '...- jvelez1
- Post #4
- Forum: SAS Institute, Inc. solutions
-
Macro Definition Not Working
I'm not understanding this. I run the macro definition and then use: %javi(num=7); Isn't this calling the macro? When I run %javi(num=7) it should execute the sql code and macro definition and output the new macro &nbr_7. Proof of that is the output that shows the content of my new macro...- jvelez1
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Macro Definition Not Working
Hello! I am running into a problem with a macro definition. When I run the sql code with a %let statement it works fine: options macrogen mlogic symbolgen mprint mfile; %let num=6; proc sql ; select "'"||trim(a.vkont)||"'" into :nbr_&num. separated by ' ' from armdb2.ext_WO_list2 a where...- jvelez1
- Thread
- Replies: 3
- Forum: SAS Institute, Inc. solutions
