I am now writing a SQL to create an empty dataset with structured variable names for my school record as below. Is it possible for me to use macros with iteration loops for the PROC SQL ? e.g. variable names : student_id, boy_000-boy_300, girl_000-girl_300 and school_total proc sql; create table student (student_id char(3), boy_000 num format F3., boy_001 num format F3., .......................................... boy_299 num format F3., boy_300 num format F3., girl_000 num format F3., girl_001 num format F3., .......................................... girl_299 num format F3., girl_300 num format F3., school_total num format F5.); quit; run; Many thanks ! regards may
... View more