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: 
Antonio598
‎09-19-2023
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: %Do Statement combination

by Calcite | Level 5 in SAS Programming
‎09-15-2023 08:23 PM
‎09-15-2023 08:23 PM
The following worked as intended...Thank you all for your input...   %do i=01 %to 26; %LET n= %EVAL(&i+7); outer union corr select * from IN&n..VAPP22%sysfunc(putn(&i,z2)) %end; ... View more

Re: %Do Statement combination

by Calcite | Level 5 in SAS Programming
‎09-15-2023 04:25 PM
‎09-15-2023 04:25 PM
The problem is that it created multiple combinations and I just need IN7.VAPP2201 then IN8.VAPP2202 and so forth. Also I need a period that it seems to be removed.      ERROR: File WORK.IN7VAPP2201.DATA does not exist. ERROR: File WORK.IN7VAPP2202.DATA does not exist. ERROR: File WORK.IN7VAPP2203.DATA does not exist. ERROR: File WORK.IN7VAPP2204.DATA does not exist. ERROR: File WORK.IN7VAPP2205.DATA does not exist.     ... View more

%Do Statement combination

by Calcite | Level 5 in SAS Programming
‎09-15-2023 03:49 PM
‎09-15-2023 03:49 PM
How do I create one combination of the following? I need to merge IN7.VAPP2201, IN8.VAPP2202 IN9.VAPP2203 .... and so forth. However this macro doesn't work in creating only one combination and the leading 0 for 'i' is removed in the output. Any help is appreciated   %MACRO MERGED; PROC SQL ; CREATE VIEW MERGE AS SELECT * FROM IN1.VAPP2120 %do n=7 %to 33; %do i=01 %to 26; outer union corr select * from IN&n.VAPP22&i %end; %end; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-19-2023 11:29 AM
Quick links