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: 
Sandeepkumar
‎09-01-2015
  • 16 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Need Date formatting code while exporting

by Calcite | Level 5 in SAS Programming
‎07-04-2015 07:52 AM
‎07-04-2015 07:52 AM
Hi Madam, Thanks for the reply.I did not understand your code.The date has the format of : 04/04/2014...but when I export ,date format is different. If I assign a=41235, then it's difficult to assign for all the values,right? Can you please elaborate your code? Thank you, Sandeep ... View more

Re: Need Date formatting code while exporting

by Calcite | Level 5 in SAS Programming
‎07-04-2015 07:50 AM
‎07-04-2015 07:50 AM
Hi friend, Thanks for the reply. Yes,the date has the format of : 04/04/2014...... I tried your code but it didn't work.I was exporting through the menu driven option(manually). Please let me know if i miss something. ... View more

Need Date formatting code while exporting

by Calcite | Level 5 in SAS Programming
‎07-04-2015 02:41 AM
‎07-04-2015 02:41 AM
Hi All, I am working on the number of ticket bookings of a flight.I have the different number of bookings  in one day at different time points and I have written the below code. proc sql; create table new as   select date,sum(TOTAL_BOOKINGS_IN_CABIN) as neww  from boo   group by date; quit; When I export this dataset called "new", then I am not getting the date column as in the date format (mm/dd/yyyy).It is giving as date 41235 41236 ......... and so on. I want the date as: date 04/04/2014 02/05/2014 ...... and so on. Can someone pls help me on this? Thanks in advance. Sandeep ... View more

Re: Can I get the datasets of Anti Money laundering from SAS.COM ?

by Calcite | Level 5 in Fraud, AML and Security Intelligence
‎04-11-2015 04:13 AM
‎04-11-2015 04:13 AM
Hi , Thank you very much for the reply. 1.I have the licensed SAS software in my system and I do not know how to access the datasets using this software.Please help me on this. 2.Yes,I would like to work on this area and get a job in Banking or finance industry.I have searched a lot for AML analysis in the internet and got some stuff(PDF's) but could not find any dataset.Please let me know if you know the link or the datasets where I can learn and implement AML methodology. Thank you. Regards, Sandeep ... View more

Can I get the datasets of Anti Money laundering from SAS.COM ?

by Calcite | Level 5 in Fraud, AML and Security Intelligence
‎04-11-2015 12:56 AM
‎04-11-2015 12:56 AM
Hi Team, Can anyone know how to download the dataset from SAS.COM of Anti Money laundering? I am interested to work on this domain. Please help me on this. Regards, Sandeep ... View more

Re: Using Proc tabulate or Proc report need the code for the following...

by Calcite | Level 5 in SAS Programming
‎03-24-2014 05:09 AM
‎03-24-2014 05:09 AM
Hi ballardw , Here is my dataset...... Sno Honda VW Maruti Gender 1 7 4 4 1 2 3 3 3 2 3 4 3 7 1 4 5 7 5 1 5 1 1 1 2 6 1 1 1 1 7 3 3 2 1 8 4 7 4 2 9 5 5 5 1 10 3 3 7 2 11 2 2 2 2 12 3 3 5 1 13 4 4 4 2 14 5 5 5 2 15 4 1 4 1 16 1 1 1 2 17 3 3 6 2 18 4 1 4 2 19 5 5 5 1 20 4 4 4 2 21 1 1 1 2 22 7 3 6 2 23 4 6 4 2 24 2 2 2 1 25 3 3 3 2 26 1 1 1 2 27 3 3 3 1 28 4 4 4 2 29 5 4 5 1 30 7 6 7 2 And the output that i what is in my first discussion  page..... Thanks, Sandeep.K ... View more

Re: Using Proc tabulate or Proc report need the code for the following...

by Calcite | Level 5 in SAS Programming
‎03-21-2014 02:56 AM
‎03-21-2014 02:56 AM
Thanks for the reply  ballardw. In your code, the variable "make" is used here as Column dimension.But I am looking for the 3 columns as side by side . Can u please  try out with some other code. Thanks, Sandeep.K ... View more

Using Proc tabulate or Proc report need the code for the following tab...

by Calcite | Level 5 in SAS Programming
‎03-20-2014 09:27 AM
‎03-20-2014 09:27 AM
Hi, In my dataset , there are 3 columns Q1, Q2, Q3 which contains 3 brands like Honda, VW, Maruti. For each column there is a rating scale question rated from 1 to 7. Now i am looking for the code as per the following output using Proc tabulate or Proc report:                                         Honda     VW     Maruti     Base:All Respondents         30          30          30 7                                         5          6             9    6                                       10           4            1   5                                        5            2            5     4                                        1            3            5   3                                        3            5            2 2                                        2            5            3 1                                        5            5            5 Top2 Box [7/6]                    15          10          10 Middle 3 Box [3/4/5]             9           10          12 Botttom 2 Box [1/2]             7            10          8 Mean                                  4.5          4.3          4.2 Please kindly help me out with the above table format code. Thanks in Advance. Sandeep.K ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links