cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ashwini2
‎11-20-2018
  • 25 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: ORA-01840: input value not long enough for date format

by Fluorite | Level 6 in SAS Programming
‎08-03-2018 12:36 PM
‎08-03-2018 12:36 PM
I am using the connect statement    proc sql; connect to odbc as ods ... View more

Re: ORA-01840: input value not long enough for date format

by Fluorite | Level 6 in SAS Programming
‎08-03-2018 12:00 PM
‎08-03-2018 12:00 PM
I am running a passthrough. Weirdly my code works just fine in Oracle SQL. ... View more

ORA-01840: input value not long enough for date format

by Fluorite | Level 6 in SAS Programming
‎08-03-2018 11:30 AM
‎08-03-2018 11:30 AM
case when status not in ('Cancelled', 'Closed', 'Filled' ) then sysdate when date_filled < date_req_approved then date_last_status_change else coalesce(date_filled, date_last_status_change) end as date_filled     I think the issue is with sysdate. ERROR: CLI cursor fetch error: [Oracle][ODBC][Ora]ORA-01840: input value not long enough for date format   Any suggestions how to make this work? ... View more

Re: Need to create flag for Top 5% members by Total Cost for every Emp...

by Fluorite | Level 6 in SAS Programming
‎07-06-2018 12:12 PM
‎07-06-2018 12:12 PM
Attaching sample data set. And flag is the variable i want to create. 1= For member who falls in top 5% by total cost bucket and 0= Not in the Top 5% bucket and i want to do this for every employer group. ... View more

Re: Need to create flag for Top 5% members by Total Cost for every Emp...

by Fluorite | Level 6 in SAS Programming
‎07-06-2018 11:55 AM
‎07-06-2018 11:55 AM
Thank you. But how would i create a distinct flag for every Employer ID? The flag should be something like 1(If member falls in the top 5% range) and 0, if not.   Or if you know a better way to deal this, Please suggest. ... View more

Need to create flag for Top 5% members by Total Cost for every Employe...

by Fluorite | Level 6 in SAS Programming
‎07-06-2018 11:43 AM
‎07-06-2018 11:43 AM
I have about 4000 distinct Employer groups in my data set and i need a flag or something similar that gives me top 5% members by Total Cost for each employer Group ID. How do i do it in SAS? ... View more

Need a SAS macro to append .txt files

by Fluorite | Level 6 in SAS Programming
‎11-07-2016 06:53 PM
‎11-07-2016 06:53 PM
Need a SAS macro to append .txt files.   My .txt files are in SAS server SASApp and i am using SAS EG.   I have the same number and type of variables in all .txt files and there are about 20 of them.   Can anybody help please? ... View more

Requesting help with macro error

by Fluorite | Level 6 in SAS Procedures
‎08-18-2016 02:14 PM
‎08-18-2016 02:14 PM
options mprint; %MACRO V22I9ED1(AGE=, SEX=, ICD9= ); IF &SEX= "2" AND &ICD9 IN ("2860", "2861") THEN CC=" 48 "; ELSe IF &AGE < 18 AND &ICD9 IN ("4910", "4911", "49120", "49121", "49122", "4918", "4919", "4920", "4928", "496", "5181", "5182") THEN CC=" 112 "; ELSE IF &AGE < 18 AND &ICD9 IN ("49320", "49321", "49322") THEN CC=" -1 "; %IF &SEDITS = 1 %THEN %DO; _TAGE=PUT(&ICD9, $&AGEFMT9..); IF _TAGE NE "-1" AND (&AGE < INPUT(PUT(_TAGE, $AGEL.),8.) OR &AGE > INPUT(PUT(_TAGE, $AGEU.),8.)) THEN CC='-1'; _TSEX=PUT(&ICD9, $&SEXFMT9..); IF _TSEX NE "-1" & _TSEX NE &SEX THEN CC='-1'; %END; %MEND V22I9ED1; Attached is the error message ... View more

Macro not working and several errors

by Fluorite | Level 6 in SAS Procedures
‎08-18-2016 02:07 PM
‎08-18-2016 02:07 PM
options mprint; %MACRO V22I9ED1(AGE=, SEX=, ICD9= ); IF &SEX= "2" AND &ICD9 IN ("2860", "2861") THEN CC=" 48 "; ELSe IF &AGE < 18 AND &ICD9 IN ("4910", "4911", "49120", "49121", "49122", "4918", "4919", "4920", "4928", "496", "5181", "5182") THEN CC=" 112 "; ELSE IF &AGE < 18 AND &ICD9 IN ("49320", "49321", "49322") THEN CC=" -1 "; %IF &SEDITS = 1 %THEN %DO; _TAGE=PUT(&ICD9, $&AGEFMT9..); IF _TAGE NE "-1" AND (&AGE < INPUT(PUT(_TAGE, $AGEL.),8.) OR &AGE > INPUT(PUT(_TAGE, $AGEU.),8.)) THEN CC='-1'; _TSEX=PUT(&ICD9, $&SEXFMT9..); IF _TSEX NE "-1" & _TSEX NE &SEX THEN CC='-1'; %END; %MEND V22I9ED1; Error is attached below: Could somebody please help me with it?   ... View more

How to convert date9. to datetime20. or vice versa using proc sql

by Fluorite | Level 6 in SAS Procedures
‎05-26-2016 05:32 PM
‎05-26-2016 05:32 PM
How to convert date9. to datetime20. or vice versa using proc sql. Could somebody please help me with that?   Thanks 🙂  ... View more

Re: Trying to stack three datasets in one

by Fluorite | Level 6 in SAS Programming
‎05-26-2016 12:02 PM
‎05-26-2016 12:02 PM
I figured it was a silly mistake. I did a proc contents and matched the variable type 🙂 Thanks so much guys. ... View more

Trying to stack three datasets in one

by Fluorite | Level 6 in SAS Programming
‎05-26-2016 11:43 AM
‎05-26-2016 11:43 AM
proc sql; create table final_data_set as select field_name , value1 from HSD.types_OfAttempts UNION ALL select put(field_name, Z3.) , value1 from HSD.number_attempts UNION ALL select put(field_name, Z3.) , value1 from HSD.final_timeframes ; quit; The first dataset has field_name as character. It has types of attempts made like phone, email, face2face.   The last two datasets have field_name as numeric.   ERROR: Numeric format Z in PUT function requires a numeric argument. ... View more

datetime20. format filtering in where clause

by Fluorite | Level 6 in SAS Programming
‎05-24-2016 01:14 PM
‎05-24-2016 01:14 PM
  proc sql; select distinct MINOFTRANSFER_EFF_DT from HSD.master_table where MINOFTRANSFER_EFF_DT between '01APR2016'd and '30JUN2016'd ; quit; I am trying to filter data based on the date and it returns no values.   MINOFTRANSFER_EFF_DT is in datetime20. format. ... View more

Re: Difference in Dates in SAS

by Fluorite | Level 6 in SAS Programming
‎05-23-2016 01:21 PM
‎05-23-2016 01:21 PM
That worked! 🙂 Thanks so much for the quick reply. ... View more

Difference in Dates in SAS

by Fluorite | Level 6 in SAS Programming
‎05-23-2016 01:05 PM
‎05-23-2016 01:05 PM
If the difference between b.HRA_Unreachable_Date AND TODAY is < 15 then i want to categorize it as "1-15". But the statemenet i wrote does not work. b.HRA_Unreachable_Date  is numeric (Date integer from Jan 1, 1960). Error: ERROR: Function INTCK requires a numeric expression as argument 2. ERROR: Function INTCK requires a numeric expression as argument 3. ERROR: The following columns were not found in the contributing tables: null     proc sql; create table timeframes as select distinct a.medicaid_id , b.min_transfer_Dt , b.HRA_Unreachable_Date , case when intck('day', "b.HRA_Unreachable_Date", "today()") < "15" then "1-15" else null end as timeframe from HSD.tbl_unreachables as b inner join HSD.Final_attempts as a on b.medicaid_id= a.medicaid_id ; quit; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-20-2018 10:06 PM
Likes given to
View All
Quick links