Hi Mark. Yes, there is a way (there are probably plenty). One way would be to define a macro: %macro models(outcome = );      proc glimmix data = ....;      model &outcome. = .....;      run; %mend models; Then you could call the macro %models(outcome = y1); %models(outcome = y2).. all the way to the fiftieths outcome. Or, you could save your outcomes of interest in a macro variable, then use a scan function... So, proc sql;      select name into: my_outcomes separated by " "      from dictionary.columns      where libname = "WORK" & memname = "YOUR_DATASET_IN_CAPITAL_LETTERS"      & name ....  ---at this point it would be nice if your outcome has some sort of pattern... quit; then change a bit the macro: %macro models(outcome = ); %do i = 1 %to 50;      proc glimmix data = ....;      model %scan(&outcome., &i., "") = .....;      run; %mend models; That's all. Anca. ... View more

How about this? LIBNAME foo excel "your_path\your_excel.xlsx' ;    data step;     set foo.'Sheet1$'n; run; Would this work? Anca. ... View more

You can try something like this: proc cimport data = data_out infile='d:\vsn.xpt'; run; quit; Good luck. Anca. ... View more

Thank you, Tom. I am yet to be comfortable with quotes and macro variables. I was not aware of the &sqlobs. Thank you. Cheers. Anca. ... View more

How about this? DATA TESTS;                                               INPUT NAME $ SCORE1 SCORE2 SCORE3 SCORE4 SCORE5                        SCORE6 SCORE7 SCORE8 SCORE9 SCORE10;        CARDS;                                                   ALICE 100 97.3 88.9 85.5 91.2 88.8 93.4 98.1 100 92      CARRIE 88.7 81.4 92.8 92.1 93 93.7 92 81.9 85.5 84       DARRYL 92.3 91 91 86.9 85 84.1 81.8 87.5 91 92.3         FRANK 79.8 77 82 85.7 85.5 81.2 88 79.9 77 86.6          HOLLY 83.4 85.1 88.7 92 81.3 84 81.9 87.3 80.6 79.6      JENNIFER 85.3 88.6 87.1 82.9 89.5 88.7 92.8 95.8 93.3 98.2 JOHN 76.3 77.3 82.5 84 73.8 78.3 80.2 80.9 79.7 84.8     MIKE 100 100 97.6 96.7 99.8 98 95.9 97.8 100 97.3        SALLY 86.6 89 92.3 94.5 86.1 91 91.7 86.4 91 91.9        TOM 86.4 88.2 81.9 84 85 82.6 91.7 88.2 91.7 84.8        ; RUN;                                                                                                                PROC SUMMARY DATA=TESTS;                                    BY NAME;                                                VAR SCORE1;                                              OUTPUT OUT=STUDENTS                                      SUM=;  run; proc transpose data = tests out = foo;     var score:;     id name; run;                                                                                                               proc sql;     select name into: names separated by " "     from tests; quit; %let num_students = %eval(%sysfunc(countw(&names.))); %macro ARRAY(); %DO i = 1 %to &num_students.;      PROC SGPLOT DATA = foo;          TITLE " Student's grade history";          VBAR %scan(&names., &i., " ") / FILL RESPONSE= %scan(&names., &i., " ")   DATALABEL LEGENDLABEL='Students grades'; /*         VBAR DATE / FILL RESPONSE=AVERAGE DATALABEL LEGENDLABEL='District averages';*/          XAXIS LABEL="Date";          YAXIS LABEL="Grades";      RUN; /*    PROC TABULATE DATA=TESTS F=COMMA3.1;*/ /*        WHERE name = %scan("&names.", &i., " ");*/ /*        */ /*        ......*/ /**/ /*    RUN;*/ %END; %mend array; %array(); ... View more

Is this what you want? proc transpose data = tests out = foo;     var score:;     id name; run; ... View more

Hi. What are you trying to accomplish? Sorry just finished reading the entire post. Ok, so you could define a macro:....umm, but what kind of plot?? %macro plot(var = ); %do i = 1 %to 10; proc gplot data = tests;      plot &var&i. * &var&i.; run;quit; %end; %mend plot; %plot(var = score); provide a bit more detail ... View more