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: 
Way2go
‎12-11-2017
  • 8 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: dates conversion

by Calcite | Level 5 in SAS Procedures
‎10-29-2012 07:19 AM
‎10-29-2012 07:19 AM
Sorry for this 'compilation' of already solved problem, but I think this thread must be marked as 'Answered' and was sure it's due to problems with interpretation. I saw all the answers but I haven't had the occasion to try them yet. As soon as I try them in SAS I won't hesitate to mark it answered ... View more

Re: dates conversion

by Calcite | Level 5 in SAS Procedures
‎10-27-2012 12:37 PM
‎10-27-2012 12:37 PM
Each week starts on monday and finishes on sunday. The week #1 of 2011 is the one that ends on the first sunday of january 2011, so i don't have a week 0. I hope I've made this more clear to you ... View more

Re: dates conversion

by Calcite | Level 5 in SAS Procedures
‎10-27-2012 12:30 PM
‎10-27-2012 12:30 PM
Ok, right. I have made a bad formulation of the problem. I don't have a single date, but a variable date (DD/MM/YYYY), week and week_t. Imagine the dataset made this way: DATE             WEEK    WEEK_T 08/07/2011          .              . 16/07/2011          .              . etc etc for about 8 millions observation (so i can't put this line date='08Jul2011'd; for every date in my dataset ). How can i find the values for week and week_t? the value of week_t in my example should be 10/07/2011 because the week starts on monday. Thanks for your help ... View more

dates conversion

by Calcite | Level 5 in SAS Procedures
‎10-27-2012 11:36 AM
‎10-27-2012 11:36 AM
Hello, I have a date in my dataset in format DD/MM/YYYY and i have to convert it in two different variables: the first is the variable WEEK and has to be YYYYWW where WW is the number of the week of the year YYYY the second is WEEK_T and has to be in format DD/MM/YYYY where the day must be the sunday of the corresponding week. How can I do it? I'll leave you an example: DATE: 08/07/2011 (it's a friday) WEEK: 201127 WEEK_T: 10/07/2011 (it's the sunday of the week #27 of 2011) Thank you very much for your help ... View more

Re: If/where contains problem while merging

by Calcite | Level 5 in SAS Procedures
‎08-06-2012 06:31 PM
‎08-06-2012 06:31 PM
Thanks for your help too :smileygrin: Very helpful indeed In fact I used the index function! ... View more

Re: If/where contains problem while merging

by Calcite | Level 5 in SAS Procedures
‎08-06-2012 06:27 PM
‎08-06-2012 06:27 PM
As I said to mkeintz this is a 3 dataset merge Btw I haven't tried with your method yet, but sure thing is I'll give it a try anyway Thanks for your help ... View more

Re: If/where contains problem while merging

by Calcite | Level 5 in SAS Procedures
‎08-06-2012 06:24 PM
‎08-06-2012 06:24 PM
Actually is a 3 dataset merge where item_descr producer and brand appear in different datasets, so there isn't the overwriting issue! (I said that i only had 2 datasets A and B just to simplify the question) Anyway I have tried this if index(item_desc,'Nutella') > 0 then do; ... ...  end; and it works!  Also you supposed right: the text in item_descr is all in uppercase but I didn't need to use this if index(upcase(item_desc,'NUTELLA')>0 then do; ... ... end; because it worked in the first way. Thank you for your help ... View more

If/where contains problem while merging

by Calcite | Level 5 in SAS Procedures
‎08-06-2012 09:09 AM
‎08-06-2012 09:09 AM
Hello! I have to perform a task in SAS but I don't know how to do 😕 I've already searched in the forums but I couldn't find anything. I hope you can help me Let's say you are merging 2 data set and some of the variables are: ITEM_description (string), producer (string) and brand (string) but the last 2 have missing values. Your goal is to put a value (string) to producer and brand that depends on ITEM_description. I'll make an example: pdv - ITEM_desc  -  producer - brand        12  - Nutella 500g - (missing) - (missing) 76  - Nutella 750g - (missing) - (missing) data C; merge A B; by pdv; where ITEM_desc CONTAINS Nutella then do; producer=Ferrero; brand=Nutella; end; run; So I know that WHERE doesn't work with THEN and DO but IF doesn't work with CONTAINS (that is the operator I need). How should I write the syntax to make it work? Thank you in advance ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-11-2017 04:56 AM
Likes given to
View All
Quick links