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: 
Dipu
‎12-11-2017
  • 43 Posts
  • 36 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Convert First letter of string to upper case WITHOUT using upcase

by Calcite | Level 5 in SAS Programming
‎03-28-2014 05:09 PM
‎03-28-2014 05:09 PM
Thank you for the explanation. I would like to go through the links first (Very well answered). -- Actually, I have assigned this task by the data management (Oracle) Dpt of my company. They can do this with oracle as well but they wanted to do it in SAS. Thanks though and also concatenation is the great approach Thank you all of you.. ... View more

Re: Convert First letter of string to upper case WITHOUT using upcase

by Calcite | Level 5 in SAS Programming
‎03-28-2014 03:19 PM
‎03-28-2014 03:19 PM
Propcase is not allowed. Thats the problem- Though What Arthur has suggested, it works but not in my case, as mentioned above. (Please explain that step with RANK and BYTES and how did you calculate those numbers--97:122 and -32) secondly @data_null_ has also suggested, it will work but looking for w/o propcase and upcase. Even this works-                                       But as I said  looking for alternative data j; input name $50.; cards; lavanya daniel nandu rachel vandana run; data J1;   set j;   Length name_newvalues $50.; lenstr=length(trim(name)); name_newvalue=upcase(substr(trim(name),1,1))||substr(trim(name),2,lenstr-1); run; ... View more

Re: Convert First letter of string to upper case WITHOUT using upcase

by Calcite | Level 5 in SAS Programming
‎03-28-2014 03:03 PM
‎03-28-2014 03:03 PM
@@@- This is what I tried!! Please guide- data j; input name $20.; cards; mahesh deepak alex susan maxia run; data J1 ;   set J;   if rank(substr(string,1,1)) in (97:122) then     substr(string,1,1)=byte(rank(substr(string,1,1))-32); run; ERRRORRRR****** 66   data J1 ; 67     set J; 68     if rank(substr(string,1,1)) in (97:122) then 69       substr(string,1,1)=byte(rank(substr(string,1,1))-32);                 -                 356 ERROR: Argument to SUBSTR must be character. NOTE 356-185: The SUBSTR pseudo-variable function does not allow character constants,               expressions, or numeric constants for the first argument. 70   run; NOTE: Numeric values have been converted to character values at the places given by:       (Line):(Column).       68:18   69:41 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.J1 may be incomplete.  When this step was stopped there were 0          observations and 2 variables. WARNING: Data set WORK.J1 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.00 seconds ... View more

Re: Convert First letter of string to upper case WITHOUT using upcase

by Calcite | Level 5 in SAS Programming
‎03-28-2014 02:02 PM
‎03-28-2014 02:02 PM
Hi Arthur, This is awesome but again it is not working on my dataset. Before writing errors which I am getting can you please throw some light, what exactly you did? I am unable to understand those figures. Please guide @Reeza- Even I don't know. why not upcase, I assume upcase will convert the entire string. Thank you ... View more

Re: Convert First letter of string to upper case WITHOUT using upcase

by Calcite | Level 5 in SAS Programming
‎03-28-2014 11:42 AM
‎03-28-2014 11:42 AM
Hi Jagdish thank you for the prompt response. unfortunately I can not use Propcase as well.Please suggest me other option, if we have Thank you Deepak ... View more

Convert First letter of string to upper case WITHOUT using upcase

by Calcite | Level 5 in SAS Programming
‎03-28-2014 11:07 AM
‎03-28-2014 11:07 AM
Hello All, Can you please suggest me- How to convert the first letter of string to upper case without using upcase function.The data is in SAS dataset. Thank you ... View more

Re: Please Help Computing the Values using Data step or proc sql

by Calcite | Level 5 in SAS Programming
‎02-12-2014 06:03 PM
‎02-12-2014 06:03 PM
No Problem. I am working on that. The best part is I understood the logic, now I can give a try. Thank you so much Reeza. Dipu ... View more

Re: Please Help Computing the Values using Data step or proc sql

by Calcite | Level 5 in SAS Programming
‎02-12-2014 05:51 PM
‎02-12-2014 05:51 PM
You are awesome Reeza.... In the previous code there was minor syntax error, sorry for troubling you for that. Now for N_flag =1 Can I write like this? proc sql;     create table want as     select max(ID) as ID, min(E_Flag) as E_Flag, min(N_Flag) as N_Flag, max(Center) as Center, min(tdate) as first_date format=date9.,                         case when max(center)>2 then sum((center=2)*tdate)                             else . end as second_date format=date9.,                         max(tdate) as last_date format=date9.     from have     where E_Flag=1 and N_Flag=1     group by ID     order by id; quit; ... View more

Re: Please Help Computing the Values using Data step or proc sql

by Calcite | Level 5 in SAS Programming
‎02-12-2014 05:06 PM
‎02-12-2014 05:06 PM
@Reeza Is this the correct syntax? case when max(center)>2 then sum((center=2)*tdate) else . end as second_date format=date9., it is showing error here. ... View more

Re: Please Help Computing the Values using Data step or proc sql

by Calcite | Level 5 in SAS Programming
‎02-12-2014 05:01 PM
‎02-12-2014 05:01 PM
Right, both are numeric Reeza. But I did not get the results. :smileyplain: ... View more

Re: Please Help Computing the Values using Data step or proc sql

by Calcite | Level 5 in SAS Programming
‎02-12-2014 04:46 PM
‎02-12-2014 04:46 PM
Thank you Reeza, it is showing some syntax error           ,case when max(center)>2 then sum((center=2)*tdate else . end as                                                                         ----       --                                                                         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: Syn I am trying to work on it... ... View more

Re: Please Help Computing the Values using Data step or proc sql

by Calcite | Level 5 in SAS Programming
‎02-12-2014 03:58 PM
‎02-12-2014 03:58 PM
Thanks reeza- if E_flag =0 and N_Flag=1 then it should process the same query for N_Flag as we need for E_Flag ... View more

Re: Please Help Computing the Values using Data step or proc sql

by Calcite | Level 5 in SAS Programming
‎02-12-2014 03:35 PM
‎02-12-2014 03:35 PM
Hello First of all thank you, tdate is the date value numeric date9. E_flag may have value 0 but one more variable is their called N_flag. so if e_flag is 0 then N_flag is 1 and vice versa ... View more

Please Help Computing the Values using Data step or proc sql

by Calcite | Level 5 in SAS Programming
‎02-12-2014 12:09 PM
‎02-12-2014 12:09 PM
Hello Experts, back to you again, please guide I have four variables as shown below in the table 'Items'- ID          E_Flag          tdate                    Center       12          1                  12Jun2012             1            12          1                  15Aug2012            2           25          1                   25May2012           1 25          1                   27Jun2012            2 25          1                   12Jul2012             3    25          1                   28Aug2012           4 25          1                   21Sep2012           5 31          1                   02Jul2012             1 31          1                   08Aug2012           2    31          1                   02Sep2012           3 31          1                   22Octl2012           4 I need the out put as shown below (I am creating the datasets/tables in SAS) Condition is- for Id =12 when E_flag=1 and Center=1 then first_date= "First date of " tdate when E_flag=1 and Center=2 then second_date= "second date of  "  tdate when E_flag=1 and Center=Max of that no (i.e. 2 or 5 or 4 )then last_date= "last date of " tdate that is tdate value corresponding to (2 or 5 or 4) Same thing for all the id's Please see the output dataset- Out put data set- ID          E_Flag              Center          First_date                   Second_date               Last_date 12          1                          2                12Jun2012                  .                                15Aug2012 25          1                          5               25May2012                  27Jun2012                  21Sep2012 25          1                          4               02Jul2012                    08Aug2012                 22Octl2012 Thank you Dipu ... View more

Re: NOTE: A CASE expression has no ELSE clause. Cases not accounted fo...

by Calcite | Level 5 in SAS Programming
‎02-09-2014 03:14 PM
‎02-09-2014 03:14 PM
Thank you PG. I think that was the most correct solution you told me. Thanks Dipu ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-11-2017 03:32 PM
Likes given to
Quick links