I'm not sure how to do it in pdf output, but if html output would be ok then you could use htmlpanel'ing. Here's an example:   http://robslink.com/SAS/democd_mpg/gas_class_2017.htm http://robslink.com/SAS/democd_mpg/gas_class.sas   ... View more

If you have more than one name with the maximum weight what would the output look like?   This should get one record per date group: proc sort data=have; by date group descending weight; run; data want ; set have; by date group; if first.group; run; ... View more

Another one : data code; input code $; cards; 35 10 20 50 3540 36x40 ; run; data B; input x $80.; cards; a35,a90 a36,a3540 zz72 jj36x40, jj3640,jj72 a10,x1010 ; run; data want; if _n_=1 then do; if 0 then set code; declare hash h(dataset:'code'); h.definekey('code'); h.definedone(); end; set b; do i=1 to countw(x,','); temp=scan(x,i,','); temp1=prxchange('s/^\D+//',1,temp); if h.find(key:temp1)=0 then new_code=temp; end; drop temp temp1 i code; run; ... View more

Rick Wicklin wrote: They haven't always existed. I introduced them in SAS/IML 12.3 because without them it is difficult to define banded and other structured matrices.  See http://blogs.sas.com/content/iml/2012/02/29/defining-banded-and-triangular-matrices.html Ah, okay. That's great to know, and I'm sure I will be using these tools. Thanks again. ... View more

HDG, I last ran .cmd files in 2004 so I am rusty.  There are several different ways to do what you need. I'll work on this tonight and tomorrow and see if I can find what I want to show you.  You cannot actually "call" a macro from a .cmd or .bat file.  Every time you  start a SAS session, you wipe out any macros previously defined in a session **.  When you invoke "getdata", you are not executing a macro, you are executing a SAS program (*.sas).  You have to initialize your libraries and macros (include a sas file with all the initializations) every time you execute sas.exe. ** unless you compile them to a permanent library.  I do not have the skillset of using permanent compiled macros. stored in initialize.sas. %macro Initialize; %mend; %initialize; stored in getdata.sas. %macro getdata; %mend; %getdata; stored in domything.sas. %macro domything; %mend; %getdata; stored in callgetdata.sas; %include Initialize.sas; %include getdata.sas; stored in calldomything.sas; %include Initialize.sas; %include calldomything.sas; How  do i invoke these macros separately in my bat file "C:\Program Files\SAS\SASFoundation\9.2(32-bit)\sas.exe" -sysin   "First invoke getdata" "C:\Program Files\SAS\SASFoundation\9.2(32-bit)\sas.exe" -sysin  "Then do mything" ... View more

%let x=%sysfunc(pathname(maps)); %put &x ; ... View more

I mean for example below is  a sample code - not very good naming or anything but just as an example I would like to list all the macros that are being used in Test - in this case subtest subtest2 subtest3 and where they are stored example C:\temp\etc.. %macro Test(input); %subtest(&input); %subtest2(&input); %mend; %macro subtest2(&input); %subtest3(&input); %mend; ... View more

Doesn't look like a sort at this point just a column reorder. There are several threads in the forum about reordering data columns in a data set. ... View more

data have; input CODE $ cluster_id a1 a2 a3 a4 a5; datalines; a1 1 0 0.19516 0.19242 0.24021 0.32064 a2 2 0.19516 0 0.22981 0.30144 0.31116 a3 2 0.19242 0.22981 0 0.10592 0.11456 a4 3 0.24021 0.30144 0.10592 0 0.16124 a5 3 0.32064 0.31116 0.11456 0.16124 0 ; run; data want;   do i=1 by 1 until (last);   set have end=last;   array temp  x1-x5 ;    temp(i)=cluster_id;    end;   do point=1 to nobs;   set have point=point nobs=nobs;   array vars a1-a5;    do i=1 to dim(vars);       retain vars;      retain cluster_id;      code_n=vname(vars(i));      cluster_idn=temp(i);      dist=vars(i);      output;   end; end; drop x: i a:; run; ... View more

Here's an approach like _null_ suggested: data _null_ ;   set sashelp.vmacro ;   where scope='GLOBAL' and offset=0 and name like "DATE%" ;   call execute('%nrstr(%%)symdel '||trim(left(name))||';') ; run ; ... View more