Hi,   I have a dataset, aggr_tmp_1, which has aggr and aggr_raw as "Character". However, when, using the aggr_tmp_1, proc sql creates a new dataset, aggr_tmp_2, both aggr and aggr_raw are "Numeric". Can anyone provide insight on why this is happening? Thank you for your help!   Code: data aggr_tmp_1;     set aggr_tmp_1;     by AGGR_INSTRUMENT_ID;     length attribute $25.;     attribute = "&var_name.";     retain diff;     if first.AGGR_INSTRUMENT_ID then         diff = 0;     if (not missing(aggr)) and (aggr ne '0') and (aggr ne aggr_raw) then         diff = 1; run; proc sql noprint;     create table aggr_tmp_2 as     select aggr_instrument_id,         aggr,         count(aggr_raw) as aggr_raw,         avg (diff) as diff     from aggr_tmp_1     group by aggr_instrument_id, aggr; quit; ... View more

Hi,   This is driving me crazy as, this is too simple, but I may be too tired to see what is wrong.   In the code below, I have a snippet from a data step. When "LnMonthsToFinalStepCount " is missing, then instead of "Step_indicator = 'Never Step', I keep getting 'Finished Stepping'. What am I missing?   Thank you for your help!   Code:         length Step_Indicator $20;         if LnMonthsToFinalStepCount >= 0 then             Step_Indicator = 'Currently Stepping';         else if LnMonthsToFinalStepCount < 0 then             Step_Indicator = 'Finished Stepping';         else             Step_Indicator = 'Never Step'; ... View more

Hi,   I'm executing some SAS code where my log file is quite large. My job stops and SAS Enterprise Guide gives me a useless error after the log file reaches a certain size. I am able to work around that by using a "proc printto" to create a log file not within SAS Enterprise Guide but on the Linux machine.   Is there something I can do to increase the log size in SAS Enterprise Guide? What is the default log size?       ... View more

Hi,   I'm trying to read a file from a text file, which has data separated by spaces. I'm having difficulty reading the 2nd column of numeric values. Some numbers do not have decimal but others have up to 15 decimal points. See below for example of data:   Data: 2017-08-01 1 2017-07-01 0.996240902217826 2017-06-01 0.992495935251788   I am using the following data step to read this file:   Code: data dataset1;     infile "&file_location./&file_name." dlm=" "         dsd missover firstobs=1;     input         data_Month : yymmdd10.         data_Value : comma17.15         ;     format data_Month     DDMMYY8.         data_Value comma17.15; run;   Data read in "dataset1": 01/08/17    0.000000000000001 01/07/17    0.996240902217820 01/06/17    0.992495935251780   I am running into two problems: When the data value in 2nd column is just an integer, it is incorrectly read as a very small value. For example, "1" is read as " 0.000000000000001". How do I fix this? Also, for decimal values, the very last decimal point is not read. For example, the value "0.996240902217826" is read as "0.996240902217820" Can you please guide me what I may be doing wrong? ... View more

Hi,   I'm trying to run an Oracle SQL query, which I inherited from somone, in the Proc SQL as a pass-through query. However, while I'm able to run the query in a stand-alone, I'm unable to run it in Proc SQL. I suspect that it has something to do with implicit conversions that Oracle performs but Proc SQL doesn't.   I've provided the SAS Code and Log below. Thank you in advance for your help!   SAS Code: proc sql noprint;     CONNECT to oracle (user="XXXX" pass="yyyyy" path='@yyyyy');         CREATE table ratings_raw as                 select cusip_id, src, val, rtg_dt,                   DECODE (rtg_typ, 'LT', 1, 'ST', 2, 3) as rtg_typ,                   min( DECODE (rtg_typ, 'LT', 1, 'ST', 2, 3) ) over (partition by cusip_id) min_rtg_typ                 from                 (                     select distinct c.cusip_id, rs.src, r.val, r.rtg_dt, r.rtg_typ, r.upd_dt,                     max(r.upd_dt) over (partition by c.cusip_id, r.rtg_typ) max_upd_dt,                     max(r.rtg_dt) over (partition by c.cusip_id, r.rtg_typ) max_rtg_dt,                     DECODE (r.rtg_typ, 'LT', 1, 'ST', 2, 3) rtgtyp,                     min( DECODE (r.rtg_typ, 'LT', 1, 'ST', 2, 3) ) over (partition by c.cusip_id) min_rtgtyp                      from cusip_rtg_src_mapg c, rtg_src rs, rtgs_mthy_spst r                      where c.rtg_src_oid = rs.rtg_src_oid                     and r.cusip_rtg_src_mapg_oid = c.cusip_rtg_src_mapg_oid                     and src='MOODY'                     and r.RTG_CATG = 'RATING'                     and r.hist_dt = to_date('20160630', 'YYYYMMDD')                     and rtg_dt <= sysdate             )             where rtgtyp = min_rtgtyp               and upd_dt = max_upd_dt     );          disconnect from oracle; QUIT;   Log: 62         proc sql noprint; 63             CONNECT to oracle 63       ! (user="xxxx" pass="yyyy" path='@XXXX'); 64                 CREATE table ratings_raw as 65                         select cusip_id, src, val, rtg_dt, 66                           DECODE (rtg_typ, 'LT', 1, 'ST', 2, 3) as rtg_typ, 67                           min( DECODE (rtg_typ, 'LT', 1, 'ST', 2, 3) ) over (partition by cusip_id) min_rtg_typ                                                               ____                                                               22                                                               76 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN,               CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.   ERROR 76-322: Syntax error, statement will be ignored. 68                         from 69                         ( 70                             select distinct c.cusip_id, rs.src, r.val, r.rtg_dt, r.rtg_typ, r.upd_dt, 71                             max(r.upd_dt) over (partition by c.cusip_id, r.rtg_typ) max_upd_dt, 72                             max(r.rtg_dt) over (partition by c.cusip_id, r.rtg_typ) max_rtg_dt, 73                             DECODE (r.rtg_typ, 'LT', 1, 'ST', 2, 3) rtgtyp, 74                             min( DECODE (r.rtg_typ, 'LT', 1, 'ST', 2, 3) ) over (partition by c.cusip_id) min_rtgtyp 75                              from cusip_rtg_src_mapg c, rtg_src rs, rtgs_mthy_spst r 76                              where c.rtg_src_oid = rs.rtg_src_oid 77                             and r.cusip_rtg_src_mapg_oid = c.cusip_rtg_src_mapg_oid 78                             and src='MOODY' 79                             and r.RTG_CATG = 'RATING' 80                             and r.hist_dt = to_date('20160630', 'YYYYMMDD') 81                             and rtg_dt <= sysdate 82                     ) 83                     where rtgtyp = min_rtgtyp 84                       and upd_dt = max_upd_dt 85             ); NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 86             disconnect from oracle; NOTE: Statement not executed due to NOEXEC option. 87         QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time):       real time           0.09 seconds       cpu time            0.02 seconds ... View more

Hi,   I'm using SAS University Edition. I tried to use the following statement:   "goptions reset=all;"   However, I got the following error: ERROR 180-322: Statement is not valid or it is used out of proper order.   Does this mean that the free SAS University Edition does not have SAS/GRAPH licensed? Is there a way for me to check it?   Thank you! ... View more