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: 
archana
‎10-03-2015
  • 31 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: to convert a date from date9 format to sas number

by Fluorite | Level 6 in SAS Programming
‎10-03-2015 07:51 AM
‎10-03-2015 07:51 AM
How can i add d to my date value. ... View more

Re: to convert a date from date9 format to sas number

by Fluorite | Level 6 in SAS Programming
‎10-03-2015 07:27 AM
‎10-03-2015 07:27 AM
Tom,    The vales in Xdata re of 12SEP2015, 01OCT2015.  when i try to assign it to new variable ydate i need to get the number but i am getting empty values.     ydate = datepart(xdate); - didnt work.     tried others too. ... View more

to convert a date from date9 format to sas number

by Fluorite | Level 6 in SAS Programming
‎10-02-2015 07:34 PM
‎10-02-2015 07:34 PM
to convert a date  variable - xdate  to SAS date values like 20340 . Xdate has values -12SEP2015 and xdate is of numeric and format date9         ... View more

How to convert date format of 01SEP2015 to number format like 20340.

by Fluorite | Level 6 in SAS Programming
‎10-02-2015 06:41 PM
‎10-02-2015 06:41 PM
How to convert date format of 01SEP2015 to number format like 20340.  ... View more

Re: Update existing and insert new record to sas dataset.

by Fluorite | Level 6 in SAS Procedures
‎04-07-2015 02:16 PM
‎04-07-2015 02:16 PM
Yes it worked after adding the semicolon. Thank you!! ... View more

Re: Update existing and insert new record to sas dataset.

by Fluorite | Level 6 in SAS Procedures
‎04-07-2015 01:18 PM
‎04-07-2015 01:18 PM
  ERROR 411-185: The UPDATE statement requires two data sets, too many data sets have been specified. This is the error i am getting when trying to execute the above. ... View more

Update existing and insert new record to sas dataset.

by Fluorite | Level 6 in SAS Procedures
‎04-07-2015 01:13 PM
‎04-07-2015 01:13 PM
Hi, my criteria is to update the existing record if it exists in the cumulative dataset else if it is new record then it needs to be added to the cumulative dataset. The cumulative data contains history data . I tried the below but it didnt work. Any other suggestions-   data adhoc.dly_cumulative; update adhoc.dly_cumulative  adhoc.dly_&day0 by column; run; ... View more

Re: passing variable into oracle query

by Fluorite | Level 6 in SAS Programming
‎03-13-2015 04:31 PM
‎03-13-2015 04:31 PM
Thank you. it worked after adding   (%unquote(%str(%'&child%'))) in the where statement. ... View more

Re: Passing sas character variables into oracle query

by Fluorite | Level 6 in SAS Data Management
‎03-13-2015 04:25 PM
‎03-13-2015 04:25 PM
Thank you. It is working after adding this-   (%unquote(%str(%'&child%'))) in where statement. ... View more

Re: Passing sas character variables into oracle query

by Fluorite | Level 6 in SAS Data Management
‎03-13-2015 02:09 PM
‎03-13-2015 02:09 PM
Actually it failed.   ERROR: ORACLE prepare error: ORA-00904: "&child": invalid identifier. ... View more

Re: passing variable into oracle query

by Fluorite | Level 6 in SAS Programming
‎03-13-2015 02:03 PM
‎03-13-2015 02:03 PM
This didnt work. ... View more

Re: Passing sas character variables into oracle query

by Fluorite | Level 6 in SAS Data Management
‎03-13-2015 12:42 PM
‎03-13-2015 12:42 PM
This didnt work. ... View more

Re: passing variable into oracle query

by Fluorite | Level 6 in SAS Programming
‎03-13-2015 10:00 AM
‎03-13-2015 10:00 AM
Program_id is defined in the same way. i wanted to enter the program id and child id in a file so that the query can pick them from file.   data program_id; infile "$inbound_path/program_id.txt" dlm=","; input id :8. @@; run; proc sql; select * into :program separated by ',' from program_id; quit; ... View more

passing variable into oracle query

by Fluorite | Level 6 in SAS Programming
‎03-13-2015 09:52 AM
‎03-13-2015 09:52 AM
Hi, I am trying the below but it is not working.  I am not getting any data. please suggest.   data child_id; infile "$inbound_path/program_child_id.txt" dlm=","; input id :$11. @@; run; proc sql; select * into :child separated by ',' from child_id; quit; create table x as select * from connection to oracle (select a.*, b.*   from table1 a,      table2           b where a.program_id in (&program) and trim(a.program_child_id) in ('&child') and a.program_id  = b.program_id and a.program_child_id  = b.program_child_id ); ... View more

Passing sas character variables into oracle query

by Fluorite | Level 6 in SAS Data Management
‎03-13-2015 09:51 AM
‎03-13-2015 09:51 AM
Hi, I am trying the below but it is not working.  I am not getting any data. please suggest.   data child_id; infile "$inbound_path/program_child_id.txt" dlm=","; input id :$11. @@; run; proc sql; select * into :child separated by ',' from child_id; quit; create table x as select * from connection to oracle (select a.*, b.*   from table1 a,      table2           b where a.program_id in (&program) and trim(a.program_child_id) in ('&child') and a.program_id  = b.program_id and a.program_child_id  = b.program_child_id ); ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-03-2015 11:36 AM
Likes given to
View All
Quick links