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: 
aakash93
‎10-15-2018
  • 10 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Today's date/time

by Calcite | Level 5 in SAS Programming
‎10-15-2018 09:37 AM
‎10-15-2018 09:37 AM
Thanks! ... View more

Today's date/time

by Calcite | Level 5 in SAS Programming
‎10-15-2018 09:20 AM
‎10-15-2018 09:20 AM
How can I generate today's date/time as date variable in the format below? Thanks!   15OCT2018:13:30:00 ... View more

Convert 10.75% to 10.75. Both values are numeric.

by Calcite | Level 5 in SAS Programming
‎09-27-2018 03:15 PM
‎09-27-2018 03:15 PM
Hi,   I need help converting a percentage to a number. For example, 10.75% to 10.75 as opposed to 0.1075. The conversion has to be done for 10+ columns.   Thank you, A ... View more

Re: Transform multiple observations to a single observation

by Calcite | Level 5 in SAS Procedures
‎07-20-2018 02:05 PM
‎07-20-2018 02:05 PM
Also forgot to mention this is after I converted INCM ASTS and LIAB to numeric. ... View more

Re: Transform multiple observations to a single observation

by Calcite | Level 5 in SAS Procedures
‎07-20-2018 02:03 PM
‎07-20-2018 02:03 PM
LNDR_FMLY_ID QTR_ID INCM ASTS LIAB BANK_IND (character) ARBRT 2015Q1       Y ARBRT 2015Q1 130,967       ARBRT 2015Q1   2,742,733     ARBRT 2015Q1     1,892,937   JPMOR 2015Q2 100,267                                                       LNDR_FMLY_ID QTR_ID INCM ASTS LIAB BANK_IND (character) ARBRT 2015Q1 130,967 2,742,733 1,892,937 Y JPMOR 2015Q2 100,267                   ... View more

Re: Transform multiple observations to a single observation

by Calcite | Level 5 in SAS Procedures
‎07-20-2018 01:56 PM
‎07-20-2018 01:56 PM
Similar to my question to Ballardw, what if I add an additional variable such as Y/N indicator variable that is character type? Adding a character type variable results in a null value. ... View more

Re: Transform multiple observations to a single observation

by Calcite | Level 5 in SAS Procedures
‎07-20-2018 01:33 PM
‎07-20-2018 01:33 PM
This solution works as well. What if I add an additional variable such as Y/N indicator that is character type? ... View more

Transform multiple observations to a single observation

by Calcite | Level 5 in SAS Procedures
‎07-20-2018 12:20 PM
‎07-20-2018 12:20 PM
Hi,   I'm looking for a solution to transform multiple observations into a single observation. I've included the current state and future state images below. (Note: all values are in character format)   LNDR_FMLY_ID QTR_ID INCM ASTS LIAB ARBRT 2015Q1 130,967     ARBRT 2015Q1   2,742,733   ARBRT 2015Q1     1,892,937 JPMOR 2015Q2 100,267       LNDR_FMLY_ID QTR_ID INCM ASTS LIAB ARBRT 2015Q1 130,967 2,742,733 1,892,937 JPMOR 2015Q2 100,267     ... View more

Re: Char Date to SAS Date

by Calcite | Level 5 in SAS Enterprise Guide
‎07-20-2018 10:41 AM
‎07-20-2018 10:41 AM
It worked, I appreciate it! ... View more

Char Date to SAS Date

by Calcite | Level 5 in SAS Enterprise Guide
‎07-19-2018 07:04 PM
‎07-19-2018 07:04 PM
Hi I'm quite new to SAS. With that said, I'm trying to convert a character date in the format of "Q12018" to SAS date. Preferably in the same format or similar format. Any help would be appreciated! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-15-2018 10:08 AM
Quick links