libname libref '<directory-specification>'; despite my macro variable name of libname sashelp is a libref, i.e. maximum length of 8 characters. to me it looks like you provided the directory-specification for the value of a libname statement. ... View more

gee whiz you are working too hard, having to read all that old-style UPCASE Here is code that is easier on the eyes for the task of writing the list of variables and types to output file. %let libname = sashelp; %let memname = class; DATA _null_; dsid   = open ("&libname..&memname"      ); lrecl  = attrn(dsid,'lrecl'); n_obs  = attrn(dsid,'nobs '); n_vars = attrn(dsid,'nvars'); do i = 1 to n_vars;    name   = varname(dsid,i);    type   = vartype(dsid,i);    putlog name= type=;    end; rc = close (dsid); stop; run; ... View more

1. Don't do this. use by-processing instead 2. YeahBut for the learning --- making mistakes --- experience read up on the history of the problem. Category:Making subsets - sasCommunity ... View more

the autocall and compiled features are different. * autocall means that SAS search for a macro definition reference in a set of filerefs (folders) which are the value of the option sasautos the autocall is turned on my default %put mautosource:%sysfunc(getoption(mautosource));*is boolean; %put %sysfunc(getoption(sasautos,keyword));* is character; when a macro is called SAS searched the filerefs for a file with the name of the macro and %includes it, the result of which is that the macro is compiled and stored in the work.sasmacr catalog. * compiled and stored (stored and compiled: not alphabetical, nor the sequence of events, but ...) macros have the %macro statement option "/store" and when they are submitted, or %included, then they are compiled and written not to work.sasmacr catalog but to the libref which is the value of the option sasmstore. %put mstored:%sysfunc(getoption(mstored));*is boolean; %put %sysfunc(getoption(sasmstore,keyword));*is character I kind of like the idea of copying the compiled and stored catalog to the user's work fileref but that is a solution for multiple users in multiple sessions. I think that is a lot of copying another solution is to reset the libref of sasmstore. it does not have to be 'library'. note: files with macros with the store option set ought not to be in any of the filerefs in the sasautos search list. see also: http://www.sascommunity.org/wiki/SASautos_Companion_Reusing_Macros ... View more

examine the functions fipname fipnamel fipstate which convert the Federal Information Processing integers for each state to corresponding name (upcase), name-lowcase and two-letter postal code see also stfips stname stnamel check this trick, which is known as an associative array %let n = 37; %let st37 = NC; %let state37 = North Carolina; %put st&n=&&st&n; %put state&n=&&state&n; %let NC = North Carolina; %put st&n=&&&&&&st&n; ... View more