Hi, I am trying to create a loop which runs several programs multiple times using the %include function. These programs all use the macro variable CUST_ID and I would like to change this macro variable for every loop based on a list I specify. This is what I have so far but I can't manage to change the macro variable in the loop. Does anyone know how to do this?   /* specify list of values that have to be inserted into a macro variable*/ Data CUST_ID_LIST; input CUST_ID; datalines; 230419732 20476814 49500430 106808266 ; run; /*calculate the length of the list to determine the number of iterations of the loop*/ proc sql; Select count(*) into: NO_CUST_ID from CUST_ID_LIST; run; /* do the loop*/ data CUST_ID; do i = 1 to &NO_CUST_ID; set CUST_ID_LIST point = i; output CUST_ID ; %include "Program 1"; %include "Program 2"; %include "Program 3"; %include "Program 4"; end; stop; run;   ... View more

Hi, So i have this dataset in Excel with 20 columns where the column headers consist of different dates. I am trying to write soms SAS EG code that removes the second column of this dataset and inserts a new column at the end of the dataset. I have managed to convert the excel dataset tot a SAS dataset which i have called WORK.Historie_DV_Nood. I have also managed to isolate the column name of the column that I want to remove using the code  /* column list extracted */ proc contents data=WORK.Historie_DV_Nood out=column_nm varnum; run; proc sort data=column_nm out=col_nm_sorted(keep = libname memname name); by varnum; run; data filtered_col; set col_nm_sorted(firstobs=&no_of_col obs=&no_of_col); run; proc sql noprint; select name into :_col_name from filtered_col; quit; %put &_col_name; This gives the output  52 %put &_col_name; 44305   However when I try to drop this column with this code: data want; set WORK.Historie_DV_Nood (drop= "&_col_name"); run; it gives the error  ERROR 214-322: Variable name "44305 " is not valid. ERROR 23-7: Invalid value for the DROP option.   I have tried to fix this using option validvarname = any; and by chaning the quotation marks but that does not work. Does anyone know what is going wrong?     ... View more