List all columns (names) in my table in a macro variable

Gick — Tue, 03 Oct 2023 05:47:24 GMT

Hi,

I have a database. I want to create a macro-variable listing all the columns in my database.

I tried to do an sql proc. it does not work.

Result : %put &var_list.

Nom sexe classe_age Pond organe

data BDD_recod;
  input Nom $ sexe $ classe_age $ Pond organe;
  datalines;
Jean Masculin 0-4ans 10572.50 21
Marie Feminin 5-14ans 10572.50 2
Pierre Masculin 15-24ans 10572.5 0
J Feminin 0-4ans 10572.50 7
M Feminin 5-14ans 10572.50 6
Pe Masculin 0-4ans 10572.50 90
Je Masculin 15-24ans 10572.50 32
Ma Masculin 0-4ans 10572.50 2  
Pire Feminin 25-30ans 10572.5 10
Mfir Feminin 35-40ans 10572.50 2.1
Pell Masculin 40-45ans 10572.50 4.53
Jeurs Masculin 15-24ans 10572.50 8
Mam Masculin 0-4ans 10572.50 56   
Piress Feminin 15-24ans 10572.5 21.30
;
/*I tried this code*/
proc sql noprint;
  select name into :var_list separated by ' '
  from dictionary.columns
  where libname = 'WORK' and memname = 'BDD_recod';
quit;

%put &var_list;

Can someone help me please.

Thanking you in advance.
Gick.

Re: List all columns (names) in my table in a macro variable

Kurt_Bremser — Tue, 03 Oct 2023 06:04:18 GMT

In the DICTIONARY tables, library and member names are all uppercase.

where libname = 'WORK' and memname = 'BDD_RECOD'

topic List all columns (names) in my table in a macro variable in SAS Programming

List all columns (names) in my table in a macro variable

Re: List all columns (names) in my table in a macro variable