I have a need to write a program that runs manually on EG connected to a server and on SAS/Win submitting to a server and on Linux with the job submitted as batch with Cron.  In the past I've used &sysscp to identify if we're running on SAS/Win or a server but how to identify EG?   EG creates automatic macro variables not created by the other environments (like _clientVersion) and I could use %SYMEXIST to see if one of them is in the global macro table, but is there an automatic variable like &sysscp that says 'EG'?   I couldn't find one.   https://blogs.sas.com/content/sasdummy/2012/10/09/special-macro-vars-in-eg/   Thanks in advance.   John ... View more

I'm reworking a program that has a data set with about 400 million records sorted by account number with one account number per time period.  There are about 300 time periods but each account can be in the data set only maybe 20 times. We have to process by account_number because we need to derive running totals for each account number across all time periods.   Some derived variables requires lagging.  Here's the existing code-.  For each record a series of lagged variables are created and then referenced in the code later.    dpd_lag1=lag(dpd);  pay_lag1=lag(payment_amount);  prin_lag1=lag(payment);  dpd_lag2=lag2(dpd);  pay_lag2=lag2(payment_amount);  prin_lag2=lag2(payment);  dpd_lag3=lag3(dpd);  pay_lag3=lag3(payment_amount);  prin_lag3=lag3(payment);  dpd_lag4=lag4(dpd);  pay_lag4=lag4(payment_amount);  prin_lag4=lag4(payment);  dpd_lag5=lag5(dpd);  pay_lag5=lag5(payment_amount);  prin_lag5=lag5(payment);    if loan_count=2 then do;         max_dpd=max(dpd,dpd_lag1);         max_dpd_2=dpd_lag1;         if dq_monthly_payment > 0 then do;           chrva421=(100*payment)/dq_monthly_payment;           chrva421p=(100*sum(payment_amount,pay_lag1))/(dq_monthly_payment*2);        end;        else do;           chrva421=.;           chrva421p=.;       end;     end;   else if loan_count=3 then do;       max_dpd=max(dpd,dpd_lag1,dpd_lag2);       max_dpd_2=max(dpd_lag1,dpd_lag2);       if dq_monthly_payment > 0 then do;          chrva421=(100*sum(payment,prin_lag1))/(dq_monthly_payment*2);          chrva421p=(100*sum(payment_amount,pay_lag1,pay_lag2))/(dq_monthly_payment*3);       end;     else do;       chrva421=.;       chrva421p=.;     end;   end;   ** continues up to loan_count=6 ;   The program takes Hours to run on our server.    My question is, do you think it would be faster to lag the variables 'on the fly' instead of creating them as we're doing here?  We'd remove the lag assignment statements and the code would look like this with LAG functions used on-the-fly. (may be parenthesis issues in here.)    if loan_count=2 then do;         max_dpd=max(dpd,lag(dpd));         max_dpd_2=lag(dpd);        if dq_monthly_payment > 0 then do;          chrva421=(100*payment)/dq_monthly_payment;          chrva421p=(100*sum(payment_amount,lag(payment_amount))/(dq_monthly_payment*2);        end;        else do;         chrva421=.;         chrva421p=.;       end;     end;   else if loan_count=3 then do;     max_dpd=max(dpd,lag(dpd),lag2(dpd));    max_dpd_2=max(dpd_lag1,dpd_lag2);     if dq_monthly_payment > 0 then do;      chrva421=(100*sum(payment,lag(payment))/(dq_monthly_payment*2);      chrva421p=(100*sum(payment_amount,lag(payment),lag2(payment))/(dq_monthly_payment*3);     end;     else do;       chrva421=.;       chrva421p=.;     end;   end;   I'm also thinking of putting this into a macro do-loop.   Thanks in advance for your thoughts.   John ... View more

I need the median in a Proc Means output data set.  It doesn't get output.  But when I run the same step without output out= the median is in the listing.  Any ideas?  I haven't tried Proc Summary yet.   Here's the log and output I've produced.  Comments explain what's going on.   ** Generate 6 descriptive statistics including median/p50 and write values to an output data set. ; 380 proc means data=shared.&program(obs=500000) 381 n nmiss mean p50 std min max maxdec=0; 382 var amtFinanced; 383 output out=stats; 384 run; NOTE: There were 500000 observations read from the data set SHARED.PRODV02_INDIRECT_TTD. NOTE: The data set WORK.STATS has 5 observations and 4 variables.   ** The note above says the output data set has 5 observations, not 6.  The median is missing. ; ** In the source dataset the variable is formatted as dollar12. ; ** Here's the data set. Obs _TYPE_ _FREQ_ _STAT_ AMTFINANCED 1 0 500000 N $500,000 2 0 500000 MIN $0 3 0 500000 MAX $34400368 4 0 500000 MEAN $18,756 5 0 500000 STD $54,091 　 ** Now just print the 6 statistics, with no output data set. All is normal. ; 387 proc means data=shared.&program(obs=500000) 388 n nmiss mean p50 std min max maxdec=0; 389 var amtFinanced; 390 /* output out=stats;*/ 391 run;  NOTE: There were 500000 observations read from the data set SHARED.PRODV02_INDIRECT_TTD.   ** Here's the listing ; The MEANS Procedure Analysis Variable : AMTFINANCED $Financed N N Miss Mean 50th Pctl Std Dev Minimum Maximum ------------------------------------------------------------------------------------------------ 500000 0 18756 17359 54091 0 34400368 ------------------------------------------------------------------------------------------------   ... View more

There are quite a few questions about unquoting but none provide a solution for my problem.  I have a macro variable containing a directory string that is created in the SAS desktop environment and passed to a server via %syslput.  %syslput requires that the macro variable be %bquoted or else it will return an 'unrecognized options' error because of the / delimiters.  That's ok.   When I use the macro variable in the server environment in an X-Command it works just fine but SYMBOLGEN returns the "Some characters in the above value which were subject to macro quoting have been unquoted for printing." message.  Using the %unquote function doesn't make the message go away.  I'm wondering how to make it go away, other than use NOSYMBOLGEN.  This does not run inside a macro.   %let dirFieldList=/risk/data/201808/filelist.txt; %syslput dirFieldList=%bquote(&dirFieldList); RSUBMIT; options symbolgen; x rm %unquote(&dirFileList);    ** Returns same message when &dirFileList is not inside " " ; 496 options symbolgen;  497 498 x rm %unquote("&dirFileList");     SYMBOLGEN: Macro variable DIRFILELIST resolves to /sasapp/credrisk/wfdscrdm/filelist.txt SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.   ... View more