I want to create a variable that is the minimum value of a variable in my dataset.   How would I create a variable that refers to the MIN value of a single column? How would a get a variable say "min1" to report back the 50? I assume it has to do with arrays but I can't quite put my finger on it and every time I try just the "MIN" function I get an error of not enough arguments. data work.test; input value1; datalines; 100 200 300 250 50 400 ; run; Thanks!   ... View more

Friends,   The following code works beautifully for batch importing CSV files. I'm asking for a basic tweak.  I would like the imported sas file to have the same name as the actual csv being imported. I've been playing around with the "out=dsn&cnt" command line, but can't seem to find the right logic.  Suggestions? %macro drive(dir,ext); %local cnt filrf rc did memcnt name; %let cnt=0; %let filrf=mydir; %let rc=%sysfunc(filename(filrf,&dir)); %let did=%sysfunc(dopen(&filrf)); %if &did ne 0 %then %do; %let memcnt=%sysfunc(dnum(&did)); %do i=1 %to &memcnt; %let name=%qscan(%qsysfunc(dread(&did,&i)),-1,.); %if %qupcase(%qsysfunc(dread(&did,&i))) ne %qupcase(&name) %then %do; %if %superq(ext) = %superq(name) %then %do; %let cnt=%eval(&cnt+1); %put %qsysfunc(dread(&did,&i)); proc import datafile="&dir\%qsysfunc(dread(&did,&i))" out=dsn&cnt dbms=csv replace; run; %end; %end; %end; %end; %else %put &dir cannot be opened.; %let rc=%sysfunc(dclose(&did)); %mend drive; %drive(c:\temp,csv) ... View more

So, let's say I have a list of student enrollments by class.    Each observation lists the student id (ID), their credits attempted (SCH), and their class (class_id).  Through proc tabulate, how do I tabulate the total number of hours (instead of counts) for each course for all students?  I've already tried by changing the VAR statement to var SCH; but that still delivers counts. Is there a way to change that to deliver the SUM of the SCH instead of the count... ... View more

Friends:   After I run a procedure like MEANS or TABULATE, the option to "Create > Report" are grayed out in the results tab.   Help/Suggestions? I'm currently using SAS Enterprise Guide 8.2   Thanks!   ... View more

Friends:   I used to use SAS EG 7.2 and when I would run a proc tabulate I would get the following options in Table A to format the report (e.g. fit page to width, remove headers/footers, etc.).  We moved to SAS EG 8.2 and I cannot find the options from Table A, I only have those available in Table B - which is basically nothing.  It's as if I cannot manually edit any reports using the Tools from Table A anymore.  I hardly think that is actually the case.  Where might I find them?  Am I missing an add-in or something to that effect?   Table A: Table B:     ... View more