Hi, there are some issues here with your code. But first lets talk about the variables. The variables can be either numeric or strings and SAS will assume numeric unless you tell it otherwise. So, all your "." is because SAS is trying to read a text but store it as a number and that wont work. The text being letters, not numbers stored as text.    I would first tell SAS what variables we have and their type plus lenght. then read the data and tell SAS where to store the values.  data name; *The order you want the variables in the table; length var1 $ 600 var2 8 nextVar $ 32; *var1 is a string ($) with maximum 600 bytes long, var2 is a numeric stored in 8 bytes (16 decimals) and nexVar is a string 32 chars.; *Caviat, 32 bytes, not chars but in your case it should be the same as number of chars.; infile "pathname" eov=eov filename=filename ENCODING="WLATIN1" dsd dlm='09'x truncover LRECL=32767; input nextVar var1 var2 ; *The order the data is in the text file.; Run; ... View more

I don't fully understand what you want to do. But a prompt is mainly used to select input parameters for the rest of your code. It is not specifically used to feed a table with data.  The prompt generates macro variables that could be used in the dialog boxes in EG or in code. The code could of course use the macro to create data in a data set, but I don't think that you want this.  If you want a way to look at a new data set and figure out what it is about, then prompts are not the way to go. ... View more

Please don't double post questions. 🙂 ... View more

I suspect that you want is in a prompt be able to dynamically show a list of values from a data set.  If so, then yes you can, but the table needs to be registered in the metadata. You can't dynamically point out the table in the prompt.    If you on the other hand just want a static list of values from a data set, then you can add (import) those when you create the prompt. But, of course, if the data changes, nothing changes in the prompt. ... View more

A slight variation of other persons code: data available_dates; input date_value date9.; format date_value date9.; datalines; 05MAR19 06MAR19 07MAR19 08MAR19 ;;; run; %macro bigCode(start_date); *Here you put your 5000 lines of code.; %put Do fun things with the startdate "&start_date"; %mend bigCode; %macro dates (ds_name, var_name); proc sql noprint; select count(*) into: ct from &ds_name; quit; %do i = 1 %to &ct.; data _null_; set available_dates (firstobs=&i obs=&i); *Only read one line at each pass.; call symputx('start_date',&var_name); run; **********************************************; * Call your big macro from here with &start_date as a parameter.; **********************************************; %bigCode (&start_date) %end; %mend; %dates (available_dates, date_value); ... View more

Maybe this: *Get the first and last date for each group; proc sql noprint; create table have_2 as select *, min(DateCharacter) as period_start, max(DateCharacter) as period_end from have group by ID order by ID, DateCharacter; quit; data want; set have_2; retain period; by id; *Fix the string dates to be SAS dates.; _d=cats(DateCharacter,"01"); _d_start=input(cats(period_start,"01"),yymmdd10.); _d_end=input(cats(period_end,"01"),yymmdd10.); d=input(_d,yymmdd10.); *Count the number of periods for this ID.; if first.id then period = 1; else period = period + 1; *Fix the table name by concatination.; table_name = cats(put(_d_start,date9.),"_",put(_d_end,date9.)); format d yymmdd10.; *Get rid of temporary variables; drop _d: period_start period_end; run; BTW, it is a bit confusing that you have to look at two messages to try to figure out what you want. Better to rewrite it to one instead. 🙂   ... View more

%let accmth=i; should be %let accmth=&i; As it is now, the macrovariable &accmth contains the letter i, not the number that the macro variable i contains. ... View more

Sort of what @Tom started with. This code takes the start date and end date and loops the number of months there is between the dates. In each loop you will have to add the four SQL queries with the correct month and year.   %macro onePass(Year, Month); *Do one of the passes of your four SQL; *No code for easier reading of a solution; %if &month < 10 %then %let month=0&month; *Make sure you have a leading 0 on the month; %put &=year &=month; * Use &year and &month in your code instead of the static years and month. %mend onePass; %macro dateLoop(Beg_YYYY=2018, Beg_MM=12,End_YYYY=2019,End_MM=02,Val_YYYY=2019,Val_MM=02); %let startDate = %sysfunc(mdy(&Beg_MM,01,&Beg_YYYY)); %let endDate = %sysfunc(mdy(&End_MM,01,&End_YYYY)); %let NumberOfMonths = %sysfunc(intck(month,&startDate,&endDate)); %do _i=1 %to &NumberOfMonths +1; *We have to add one month.; %let date=%sysfunc(intnx(month,&startDate,&_i)); %let month =%sysfunc(month(&date)); %let year =%sysfunc(year(&date)); %onePass(&year, &month); %end; %mend dateLoop; %dateLoop(Beg_YYYY=2018, Beg_MM=12,End_YYYY=2018,End_MM=12,Val_YYYY=2019,Val_MM=02);   ... View more