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: 
aman23
  • 13 Posts
  • 10 Likes Given
  • 0 Solutions
  • 0 Likes Received
This widget could not be displayed.

Re: How to calculate cumulative sum using Lag function?

by Obsidian | Level 7 in New SAS User
‎02-27-2019 04:27 AM
‎02-27-2019 04:27 AM
yes using retain can get the result, but can it be done using Lag function??? ... View more

How to calculate cumulative sum using Lag function?

by Obsidian | Level 7 in New SAS User
‎02-27-2019 04:22 AM
‎02-27-2019 04:22 AM
How to calculate cumulative sum of below data using Lag function?   Name Marks AA  50 BB 60 CC  70 DD 80 EE 90 FF 100   output should be: Name Marks  Cumulative marks AA    50   50 BB   60   110 CC   70  180 DD  80   260 EE  90  350 FF  100 450 ... View more

Re: How to calculate total deposit using base SAS & SQL?

by Obsidian | Level 7 in New SAS User
‎02-22-2019 02:14 PM
‎02-22-2019 02:14 PM
Got it thanks a lot 🙂 ... View more

Re: Meet your community managers

by Obsidian | Level 7 in Getting Started
‎02-22-2019 02:04 PM
‎02-22-2019 02:04 PM
Hello,   can you please change my username from "1235265" to "aman23".   thanks 🙂 ... View more

Re: How to calculate total deposit using base SAS & SQL?

by Obsidian | Level 7 in New SAS User
‎02-22-2019 01:54 PM
‎02-22-2019 01:54 PM
why below variables are multiplied?? can you show or explain with the help of any of the observation from data only?   (money>=0)*money; (money<0)*money;   ... View more

Re: Formats & Informats

by Obsidian | Level 7 in SAS Programming
‎02-22-2019 01:51 PM
‎02-22-2019 01:51 PM
Yeah thanks a lot (Y)  thats solves my problem 🙂 ... View more

Re: Formats & Informats

by Obsidian | Level 7 in SAS Programming
‎02-22-2019 01:42 PM
‎02-22-2019 01:42 PM
is there any format to print the both datetime & time in below format??   datetime:- 22Feb2019 11:44:00 PM time:- 11:44:00 PM         ... View more

Re: Formats & Informats

by Obsidian | Level 7 in SAS Programming
‎02-22-2019 01:36 PM
‎02-22-2019 01:36 PM
It is numeric, say you are fetching it using datetime() function for the current date & time. ... View more

Formats & Informats

by Obsidian | Level 7 in SAS Programming
‎02-22-2019 01:14 PM
‎02-22-2019 01:14 PM
How to print below date in SAS and then extract date & time part in different variables from the same date??   22Feb2019 11:44:00 PM ... View more

Whats is Percentile in SAS?

by Obsidian | Level 7 in SAS Programming
‎02-22-2019 01:13 PM
‎02-22-2019 01:13 PM
What is percentile in SAS??? what are the different ways to calculate the same??  ... View more

How to calculate total deposit using base SAS & SQL?

by Obsidian | Level 7 in New SAS User
‎02-22-2019 01:10 PM
‎02-22-2019 01:10 PM
I have a dataset with below data: i need sum of deposit & sum of withdrawals of each employee   name money Andrea -10000 Mark 149513 Kassidy -5016 Andrea 17500 Andrea 2500 Jim 100000 Jim -50 Jim -50 Jim -50 Kassidy -2013   Output should be like this: name sum of deposit sum of withdraws Andrea 20000 10000 Mark 100000 150 Kassidy 0 7029 Jim 149513 0 ... View more

Re: How to extract weekday from previous month in SAS

by Obsidian | Level 7 in SAS Programming
‎02-22-2019 11:38 AM
‎02-22-2019 11:38 AM
can you plz explain the code after d while, how it worked or logic that you have used i.e :   do while(weekday(last_month) ne 2); ( what ne 2 resolved here??) last_month=last_month+1; (why value of last_month incremented by 1??) ... View more

How to extract weekday from previous month in SAS

by Obsidian | Level 7 in SAS Programming
‎02-22-2019 08:13 AM
‎02-22-2019 08:13 AM
How to get the date of 1st monday from previous month of today's date in SAS. i.e: if today is 22ndFeb2019 then i need 7thJan2019 as output. ... View more
Contact Me
Likes given to
Quick links