Yesterday you posted this same macro and you were given options on how to correct it.   It doesn't appear you've made any of the changes suggested.   Again, you are passing more parameters to the macro than you have defined. ... View more

SASHELP.VTABLE exists always, as far as I know.   It might help your understanding of what this suggestion gives you if you view this table. It's essentially   PROC PRINT DATA=SASHELP.VTABLE;RUN; Either way, you can modify the where statement to choose any assigned library you want. You could also get rid of the library='SASHELP' piece of the where statement altogether to see all tables in all libraries you have assigned. e.g. data _null_; set sashelp.vtable; where memname=:'C'; call execute(cats('proc contents data=',libname,'.',memname,'; run;')); run; ... View more

You are passing three parameter (one , two , and three), while only defining one parameter to be passed (dt).   You can either quote what you are trying to pass to the macro   %nn(%quote(one,two,three)) Or, you can modify the macro to include a space as a delimiter in your scan function and pass the parameter separated by spaces. %macro nn(dt); %do i=1 %to 3; %let x=%sysfunc(scan(&dt,&i,', ')); %put &x; data t; set &x; run; proc print;run; %end; %mend; %nn(one two three)     ... View more

I'm not sure what you're looking for as an answer to that.   So here is a link to the LOCK statement in SAS Documentation. ... View more

There's some mixing of data step and macro functionality going on in previous posts. This would be an alternative to save those strings as dates.   %macro ab(strt,end); %let a="&strt"d; %let b="&end"d; %put a=&a. b=&b.; %mend; %ab(01jan2015,31jan2015); At that point, you should be able to use the dates in a function such as intck   e.g.   %macro ab(strt,end); %let diff = %sysfunc(intck(day,"&strt."d,"&end."d)); %put Days between = &diff.; %mend; %ab(01jan2015,31jan2015);   I'm assuming this is part of a larger macro, so you'll be able to use the resulting value in a variable.  ... View more

You can set an Other in the format, i.e.   proc format; format fclass 1 = 'Freshman' 2 = 'Sophomore' 3 = 'Junior' 4 = 'Senior' other = 'Other' run; Or you can set the label to a missing character, whatever fits your need best. ... View more

1. Use PROC PRINTTO to route the log to a file. 2. Use data step to read in that log file keeping the lines you're interested in   Quick example   /* route the log */ PROC PRINTTO LOG="directory/file.log' NEW; RUN; /* run all your regular sas code to generate the log */ /* return log to default */ PROC PRINTTO LOG=LOG; RUN; /* read in the generated log file and keep what you want to see */ data processed_log; length line $1000; infile "directory/file.log"; input; logfile = "directory/file.log"; line_num = _n_; line = _infile_; issue = 0; if index(upcase(line),"ERROR") > 0 then do; issue = 1; output; end; run; I would treat that as pseudocode, but it should be flexible to fit your need. You can look for errors, warnings, notes, etc. with similar logic. Good luck. ... View more

  For one thing, you don't want to substring ID, you want to substring concatenated_var.  Secondly, you can use the length of ID to determine where to start in concatenated_var (position 6 or 7), e.g.   date_var=input(substr(concatenated_var,length(ID)+1,5),5.); Then, assuming date_var is constant length (5) you can get your numeric var in a similar fashion.  ... View more

From RAND function documentation here   Generating Random Numbers The RAND function generates random numbers from various continuous and discrete distributions. Wherever possible, the simplest form of the distribution is used. The RAND function uses the Mersenne-Twister random number generator (RNG) that was developed by Matsumoto and Nishimura (1998). The random number generator has a very long period (219937 – 1) and very good statistical properties. The period is a Mersenne prime, which contributes to the naming of the RNG. The algorithm is a twisted generalized feedback shift register (TGFSR) that explains the latter part of the name. The TGFSR gives the RNG a very high order of equidistribution (623-dimensional with 32-bit accuracy), which means that there is a very small correlation between successive vectors of 623 pseudo-random numbers. The RAND function is started with a single seed. However, the state of the process cannot be captured by a single seed. You cannot stop and restart the generator from its stopping point. Reproducing a Random Number Stream If you want to create reproducible streams of random numbers, then use the CALL STREAMINIT routine to specify a seed value for random number generation. Use the CALL STREAMINIT routine once per DATA step before any invocation of the RAND function. If you omit the call to the CALL STREAMINIT routine (or if you specify a non-positive seed value in the CALL STREAMINIT routine), then RAND uses a call to the system clock to seed itself. For more information, see CALL STREAMINIT Creating a Reproducible Stream of Random Numbers. ... View more