Lu, If you really, REALLY are trying to learn how to write macros, then let the forum know so that others will provide feedback regarding how to do what you want by writing a macro. However, your problem is easily solved in a data step using arrays. I changed the names of your suffix variables so that they would be more ammenable to puting them in a variable list. data mydata (drop=i); array vars(*) var1-var5; array suffix(*) suffix_var1-suffix_var5; input var1 suffix_var1 var2 suffix_var2 var3 suffix_var3 var4 suffix_var4 var5 suffix_var5; do i=1 to dim(vars); if suffix(i) eq 1 then do; call missing(vars(i)); end; end; datalines; 4.2 1 1.8 0 2.3 0 3.5 0 2.3 1 3 0 2.5 0 5.2 1 6.4 0 2.4 0 ; run; HTH, Art ... View more

If you're not familiar with concatenating libraries take a look at: http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000933322.htm Art ... View more

Will concatenating lhe libname to include both suffice? Art ... View more

Peter is probably more familiar with this topic than I am. I understood that you were simply looking for a way to point-and-click your way to view files within subdirectories. That said, you could probably combine Favorite Folders with file shortcuts to be able to reference them within your code. Take a look at: http://support.sas.com/documentation/cdl/en/hostwin/63285/HTML/default/viewer.htm#refextfile.htm or, in short form: http://xrl.us/bh2uys Art ... View more

Would assigning the directory to My Favorite Folders suffice? ... View more

Mush, Of course! To avoid seeing the table, simply start your call with: proc sql noprint; Then, before your select statement, simply add: create table you_choos_a_name as Then continue on with the rest of your statements. HTH, Art ... View more

LB, I don't know enough about your problem to know whether the following is relevant but, a few years ago, datanull proposed a solution for a problem that I thought could only be solved with macro variables. Thus, my suggestion is simply to read the following SAS-L thread: http://groups.google.com/group/comp.soft-sys.sas/browse_thread/thread/19c742867a27cbb1/4999ff4a5a3cd6ad?q=putn+tabachneck+datanull+group:comp.soft-sys.sas If it helps you solved your problem, case solved! If not, it should provide some useful tools for solving other problems. Art ... View more

I agree with Cynthia that you have provided conflicting information regarding what you want to format. Presuming that you want to format the dependent variable, one way you can do that is by modifying the template. Some fairly simple examples are provided at: http://www.ssc.wisc.edu/sscc/pubs/4-8.htm Like Cynthia said, though, it might not make sense for all of the measures, but might for obtaining the mean time. HTH, Art ... View more

I agree with Cynthia's suggested approach and, if you're really, really interested in learning macros, the paper she suggested. However, since I wrote a macro (but didn't test it), I thought I'd share it before deleting it. options noxwait nxsync; %macro www(folder,subfolder,fname,numruns); data _null_; %do i=1 %to &numruns.; call system ("md &folder.&subfolder.&fname.&i."); %end; run; %mend; %www(C:\saswork\,alex\,runs,50) Art ... View more

Since you only want to move your Comments variable, that is the only variable that has to be on the retain or length statment. And, since you probably have to assign a length to the variable, I'd use the length statement to accomplish the task. Thus, the following should do what you want: data test; length Comments $ 250; set sashelp.class (rename=( age=Variable_1)); if Variable_1 >14 then comments ="Old"; else Comments ="New"; run; HTH, Art ... View more

I'm not sure I understand what you are looking for. The following is based on the understanding that the data desribes the years and channels, but a where statement is the only thing that describes the desired 'types' you want to include. If that is correct, then I'd suggest including the where statement as a macro variable and using it to build a file that contains all of the possible permutations. For example: proc format; value $ channellbl 'A'='First' 'B'='Second' 'C'='Third'; run; data loan_all; input year (channel type) ($1.) numloans; cards; 1 A1 100 2 B1 5 3 C1 23 4 A2 7 5 B2 10 ; %let where='1','2','3'; proc sort data=loan_all (keep=year) nodupkey out=allcombos1; by year; run; proc sort data=loan_all (keep=channel) nodupkey out=allcombos2; by channel; run; data allcombos3 (drop=_:); length type $1; _want=compress("&where.","'"); _i=1; do while (scan(_want,_i) NE ""); type=put(scan(_want,_i),$1.); _i+1; output; end; run; proc sql; create table selectlevels as select * from Allcombos1,Allcombos2,Allcombos3 ; quit; proc summary data=loan_all completetypes missing nway classdata=selectlevels; class year channel type; var numloans; output out=test sum=; format channel $channellbl.; where type in (&where.); run; data test; set test; if missing(numloans) the numloans=0; run; proc print data=test; run; The code, of course, could be reconfigured to be a SAS macro, in itself, but I didn't think it was worth the effort until we find out that it is close to what you were seeking. Art ... View more

You already have the answer you needed. Now, if you want to learn more about working with dates, times and datetimes in SAS, take a look at: http://www2.sas.com/proceedings/sugi25/25/btu/25p058.pdf HTH, Art ... View more

Chad, Unless you are just trying to learn how to write macros, I would avoid using a macro for this problem. Instead, you can use proc sql to create a macro variable that does what you want. For example: /* Create some test data */ data test2; set sashelp.class (rename=( name=row_labels age=Col0001 height=Col0002 weight=Col0003 )); month=mod(_n_,3); run; /*Create a macro variable with proc sql */ proc sql noprint; select "Sum ("||trim(name)||") as Sum"||substr(name,4) into :sumCol separated by "," from dictionary.columns WHERE libname eq "WORK" and memname = "TEST2" and name like 'Col%'; quit; proc sql noprint; create table testMacro as select row_labels, &sumCol. from test2 group by row_labels,month; quit; HTH, Art ... View more

Garnett, Fascinating question .. never thought about it and totally out of my area. That said, I came across an interesting thread elsewhere that might provide some direction. You can find it at: http://boards.straightdope.com/sdmb/showthread.php?t=577361 HTH, Art ... View more