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: 
nevennett
‎06-18-2019
  • 4 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

How do I change from a character to a numerical variable?

by Fluorite | Level 6 in New SAS User
‎06-18-2019 05:55 AM
‎06-18-2019 05:55 AM
I've tried the following code for SAS ondemand and I'm getting an error.    data ab2; set ab1; lead_num = input(lead, 4.); run;   and if comes up with an error saying that the input statement is incorrect.      What do I need to do? ... View more

Re: Changing from numerical data to date using SAS ondemand

by Fluorite | Level 6 in SAS Programming
‎06-12-2019 04:54 AM
‎06-12-2019 04:54 AM
Thanks everyone for answering my question. A combination of the responses seems to have done the trick:   data ab1; set ab; SurgDate=input(put(SurgStart, 8.),yymmdd8.); format SurgDate yymmdd8.; run; Thank you so much! ... View more

Changing from numerical data to date using SAS ondemand

by Fluorite | Level 6 in SAS Programming
‎06-07-2019 05:02 AM
‎06-07-2019 05:02 AM
Hi,  I'm using SAS on demand and I'm struggling to change a numeric variable to a SAS date.    My numeric variable is SurgStart which has format best12. and informat best32. It contains 8 digits that represents YYYYMMDD  What I want to do is changed SurgStart e.g.20140410 to become the date 2014 04 10 so I can then do time series analysis.  My code is: data ab1; set ab; SurgDate=input(put(SurgStart, best12.), yyyymmdd.); format SurgDate date8.; run;   This doesn't work.    Please help! ... View more

Re: Change variable from numeric to SAS date

by Fluorite | Level 6 in SAS Programming
‎06-07-2019 03:10 AM
‎06-07-2019 03:10 AM
Hi,  I'm using SAS on demand and I'm struggling to change a numeric to a SAS date.    My numeric variable is SurgStart which as format best12. and informat best32.    My code is: data ab1; set ab; date_var=input(put(SurgStart, best12.),yyyymmdd.); format date_var date9.; run;   This doesn't work. What I want to happen is for SurgStart e.g.20140410 to become the date 2014-04-10 so I can then do time series analysis.    Please help! Why is this ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-18-2019 09:16 AM
Quick links