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: 
yaswanthj
‎11-28-2017
  • 70 Posts
  • 2 Likes Given
  • 0 Solutions
  • 15 Likes Received

Re: SAS dataset error

by Fluorite | Level 6 in SAS Programming
‎02-27-2013 04:53 AM
‎02-27-2013 04:53 AM
ohk great...its working.. Thanks Sanjeev.. Thanks, Yaswanth J. ... View more

Re: problem with RBREAK Statement in PROC report

by Fluorite | Level 6 in SAS Procedures
‎02-27-2013 04:51 AM
‎02-27-2013 04:51 AM
Hi Cynthia, Thank you for your reply..sorry for delayed response, because i was on holiday.. actually what i want to display is, for the variables(minfee, maxfee). i required to get the sum of "min fee" and sum of  "max fee". should be like below displayed. when i trying to execute above code i am getting min value for "min fee", max value for "maxfee" while using rbreak like below. Please help.. Thanks, Yaswanth J ... View more

Re: SAS dataset error

by Fluorite | Level 6 in SAS Programming
‎02-27-2013 04:28 AM
‎02-27-2013 04:28 AM
Thanks TOM and DOC.., i will try.. Thanks & Regards, Yaswanth J. ... View more

SAS dataset error

by Fluorite | Level 6 in SAS Programming
‎02-26-2013 11:10 AM
‎02-26-2013 11:10 AM
Hi all, I have a issue with dataset. whenever i am trying to open some of the dataset in sas viewer and also in sas , i can not able to open the dataset it is pop up with a below window. but i can able to open the dataset with universal viewer. Could any one help, how to over come this issue..with out using updated viewers.. Thanks & Regards, Yaswanth J. ... View more

Re: problem with RBREAK Statement in PROC report

by Fluorite | Level 6 in SAS Procedures
‎02-20-2013 05:46 AM
‎02-20-2013 05:46 AM
Hi Daman, Thanks for your quick reply I have tried with your code. but not meeting exact requirement what i want is, i need to display sum of _C2_ column value in end of the report, same as for the column height.. Thanks, yaswanth ... View more

problem with RBREAK Statement in PROC report

by Fluorite | Level 6 in SAS Procedures
‎02-20-2013 05:19 AM
‎02-20-2013 05:19 AM
Hi All, Thanks in Advance, I want to display sum of all the min and max values for fee. that is the reason i used RBREAK statement. for below code i can get sum for only height. so i need to get sum for min and max also. proc report data = sasuser.admit out = want; columns actlevel (min max),fee height; define fee/analysis sum; define actlevel/group; rbreak after/summarize dol dUl; run; Thanks., Yaswanth ... View more

Re: MONNAME3.

by Fluorite | Level 6 in SAS Programming
‎02-01-2013 05:08 AM
‎02-01-2013 05:08 AM
You can use below code..this is very easy to use .. proc format; value mon  1 = JAN            2 = FEB     3 = MAR     4 = APR     5 = MAY     ;     run; data test; input month; format month mon.; datalines; 1 2 3 4 5 ; run; Proc print; run; Thanks, Yaswanth ... View more

Convert dataset to SAS V8 using SAS V9.2

by Fluorite | Level 6 in SAS Programming
‎01-04-2013 09:14 AM
‎01-04-2013 09:14 AM
Hi.. Can any one help me, there any ways to generate Dataset with SAS V8 using SAS V9.2  Client Requirement  is to generate the datasets  with SAS version V8.0. I am having the SAS software of V9.2 and trying to do in many ways with Version SAS V9.2, i can not able to convert dataset to V8 using SAS V9.2.. Can any one help, should be appreciated   With Best Regards, Yaswanth ... View more

Re: How to replace the value..

by Fluorite | Level 6 in SAS Programming
‎12-27-2012 06:40 AM
‎12-27-2012 06:40 AM
Hi Patrick.. your Mentioned code is working fine ..and also working for below post.. I tried with your code it is working..but it is taking long time when i execute for huge data in V9.1, the folk sanjeev mentioned in this post.. Could you please let me know, is there any other ways to do..with out using merge statement. Thanks & Regards, Yaswanth ... View more

Re: Find difference between two dates..

by Fluorite | Level 6 in SAS Programming
‎12-27-2012 06:25 AM
‎12-27-2012 06:25 AM
Hi Patrick, Thanks for your quick reply.. I am working on below mentioned code.. data test; input date anydtdte23.; format date date9.; cards; 2012-04-13 03:36:53.350 2012-04-21 15:27:59.003 2012-04-14 04:48:18.030 2012-04-18 22:17:29.357 ; run; proc print data = test; run; data test1; set test; date1 = intck('days',date,lag(date)); run; proc print data = test1; run; Output:   Obs         date    date1    1     13APR2012       .    2     21APR2012      -8    3     14APR2012       7    4     18APR2012      -4 Here i am getting the  difference between dates(date1) populating correctly..but the thing was i need the date1 difference should start from 1st row like below.. required output: Obs         date    date1    1     13APR2012       -8    2     21APR2012        7    3     14APR2012       -4    4     18APR2012      . Thanks Yaswanth ... View more

How to replace the value..

by Fluorite | Level 6 in SAS Programming
‎12-27-2012 05:04 AM
‎12-27-2012 05:04 AM
Hi All, I have a data like mentioned below.. data test; input name $ age; cards; aa . bb 1 cc 2 dd 3 ee . ff 5 run; I have to replace the values of age..that means second value should be in first place, 3rd should be in 2nd, 4th should be in  3rd..so on .. Please help me.. Output should be like below/.. Name age aa 1 bb 2 cc 3 dd . ee 5 ff . Thanks Yaswanth ... View more

Find difference between two dates..

by Fluorite | Level 6 in SAS Programming
‎12-27-2012 04:45 AM
‎12-27-2012 04:45 AM
Hi All, I have a data like below.. data test; input id name date anydtdte23.; format date date9.; cards; 10 bb 2012-04-13 03:36:53.350 11 cc 2012-04-21 15:27:59.003 12 dd 2012-04-14 04:48:18.030 13 ee 2012-04-18 22:17:29.357 ; run; I want to create a new flag, and  data should be like below(that means difference between 1st row minus second, second minus third so on.....).. and if  i want to know, diff b/w months  or years ...how could i do...please provide the code for this. flag -7 7 -4 . could any body help..that should be appreciated. Thanks & Regards, Yaswanth ... View more

Re: How to find the correct PAN #(ex: ABCDF1234J)in a given data.

by Fluorite | Level 6 in SAS Programming
‎12-26-2012 03:39 AM
‎12-26-2012 03:39 AM
Hi Ksharp, Thank you..it is working Regards, Yaswanth J. ... View more

Re: How to find the correct PAN #(ex: ABCDF1234J)in a given data.

by Fluorite | Level 6 in SAS Programming
‎12-25-2012 06:25 AM
‎12-25-2012 06:25 AM
Hi Ksharp, Thanks For your quick reply.. is there any other ways to do this.. i was pretty new to  "prxparse" expressions. i can not able to understand the expression.. Thanks, Yaswanth ... View more

How to find the correct PAN #(ex: ABCDF1234J)in a given data.

by Fluorite | Level 6 in SAS Programming
‎12-25-2012 04:56 AM
‎12-25-2012 04:56 AM
Hi, How to find the correct PAN # in a given data. data can be in any format..A PAN should be first 5 chars,fallowed by 4 digits and ends with char...need to create a flag where PAN is in correct FORMAT  on not. data test; input tt $10. cards; abcde1234f bcdef2345g bh4hg2351h 1235456797 ; run; In my above data 1st and 2nd records are in correct format, other records should be flogged with "incorrect".  My question is that, i want data in correct format i.e 1st and 2nd obs. can any one help, that should be  appreciated. Thanks, Yaswanth ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-28-2017 12:50 AM
Likes given to
View All
Likes from
Quick links