This is a duplicate message but the original is several years old and I wasn't able to follow it, so I thought it was worth repeating.     I am new to a client and trying to connect EG.   I have PC SAS but nobody here uses EG, I'd like to use PC SAS and print the IP address to the log.  The idea is that I would get the IP address and port from the log in PC SAS, and use that to connect with EG.  I hope that makes sense, any help is appreciated.   ... View more

I am trying to stop a do loop once a value is divisible by three.  I have never come across the leave statement before but it looked like a good fit.  I'm running the code below and not getting the desired output.    There's no error but the code runs as if the line with 'leave' was commented out.  If anyone can provide any insight on this function and what I'm doing wrong I'd appreciate it.    data have; input id mob co; cards; 1 35 1 1 34 1 1 33 1 1 32 1 2 33 1 2 32 1 2 31 1 2 30 1 ; run; data want; input id mob co; cards; 1 35 0 1 34 0 1 33 1 1 32 1 2 33 1 2 32 1 2 31 1 2 30 1 ; run; data getting; input id mob co; cards; 1 35 0 1 34 0 1 33 1 1 32 0 2 33 1 2 32 0 2 31 0 2 30 1 ; run; data code; set have; by id; do i = 1 to 3; if mod(mob,3) ne 0 then co = 0; if mod(mob,3) = 0 then leave; end; drop i; run; ... View more

I am trying to input some stock data like below, I've dropped the infile statement, removed the dlm from the input statement and get the same message every time.  The output shows up with the headers but empty, log is below.  I haven't done this in a while, so I think it might be a simple syntax error but I'm not seeing it.  Appreciate any help in loading this data   Thanks:   data nflx; infile cards dsd dlm=','; informat date mmddyy10. close 8.; format date mmddyy10. close 8.; cards; 8/22/2017,169.34 8/23/2017,169.06 8/24/2017,168.13 8/25/2017,165.95   log:   74 data nflx; 75 infile datalines dsd dlm=','; 76 informat date mmddyy10. close 8.; 77 format date mmddyy10. close 8.; 78 datalines;   NOTE: Variable date is uninitialized. NOTE: Variable close is uninitialized. NOTE: The data set WORK.NFLX has 1 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ... View more

I am trying to use the value of one variable to reference another variable.   data have; input one two three value$; cards; 1 2 3 two 1 2 3 . 1 2 3 one ; run; data want; input one two three; cards; 1 . 3 1 2 3 . 2 3 ; run;   In row one the variable value = 'two', so I want the variable two to = null.  In row value is null so there is no action.  In row three value = 'one' so the variable one is changed to null.  If anyone can help do this I'd appreciate it.  I'm trying to use vvaluex() to do this but not getting there.   Cheers, ... View more

The code below works fine, the first part groups by date,fico,product, the second part does not group on fico, as I want it to be on the portfolio level, hence the variable 'Portfolio' as fico format=$9.   Is there a way to do this in one step without the union?  I'd like to only have one 'from' statement.  Pulling from the dataset twice doubles the time it takes to build this and I have many of them.    proc sql; create table avg_fico as select distinct intnx('month',OPEN_DT,0,'e') as OPEN_DT format=mmddyy10.,fico as fico,product,sum(cbscore_new) as cbscore_num,sum(n_cbscore_new) as cbscore_denom from mdj.uloc_format group by OPEN_DT,fico,product union select distinct intnx('month',OPEN_DT,0,'e') as OPEN_DT format=mmddyy10.,'Portfolio' as fico format=$9.,product,sum(cbscore_new) as cbscore_num,sum(n_cbscore_new) as cbscore_denom   from mdj.uloc_format group by OPEN_DT,product order by OPEN_DT,fico,product; ... View more