topic Re: print list of values in line by line in into clause in SAS Programming

print list of values in line by line in into clause

pavank — Tue, 02 Jul 2024 07:28:54 GMT

proc sql noprint;
  select name into :mvar1 - :mvar99  
  from sashelp.class
  ;
quit;

%macro printMvars();
  %do i=1 %to &sqlobs;
    %put &&mvar&i;
  %end;
%mend;
%printMvars()

i want to print list of values line by line without macro do loop using proc sql into clause block only

required output

Alfred
Alice
Barbara
Carol
Henry
James
Jane
Janet
Jeffrey
John
Joyce
Judy
Louise
Mary
Philip
Robert
Ronald
Thomas
William

Re: print list of values in line by line in into clause

Kurt_Bremser — Tue, 02 Jul 2024 08:21:18 GMT

Why so complicated? A simple SELECT will do it:

proc sql;
select name from sashelp.class;
quit;

Re: print list of values in line by line in into clause

PaigeMiller — Tue, 02 Jul 2024 10:32:18 GMT

@pavank wrote:
proc sql noprint;
  select name into :mvar1 - :mvar99  
  from sashelp.class
  ;
quit;

%macro printMvars();
  %do i=1 %to &sqlobs;
    %put &&mvar&i;
  %end;
%mend;
%printMvars()
i want to print list of values line by line without macro do loop using proc sql into clause block only

Why do you even specify using SQL and macros here? You make your programming harder by specifying it has to be done a certain way.

You could use PROC PRINT. You should be specifying the output you want, rather than using a specific PROC and the INTO clause.

Re: print list of values in line by line in into clause

Tom — Tue, 02 Jul 2024 12:53:57 GMT

If the goal is to list the name to the SAS log then skip the SQL and the macro code code.

data _null_;
  set sashelp.class;
  put name;
run;

If you have a set of macro variables with a common prefix and numeric suffix then you can also print them to the log using a data step.

data _null_;
  do i=1 to &sqlobs;
       value = symget(cats('mvar',i));
       put value;
  end;
run;