Posts Tagged ‘ informat ’

Data Steps 2010-07-19 22:25:00

July 19, 2010
By

I have a data set of sales data by day. Unfortunately the names of the columns represent the dates. In order to work with the data, I need to transform the data set so each day represents an observation.The data set looks something like this:store _0...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

an mmddyyyy hhmmss informat. kinda.

October 20, 2009
By

a while ago, i took the hack shortcut of reading character datetime stamps into datetime values. i even went so far as suggesting a regex would be a better solution. well, here’s that better solution: data mmddyyyy_hhmmss_xm; if _n_=1 then do; ...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

an mmddyyyy hhmmss informat. kinda.

October 20, 2009
By

a while ago, i took the hack shortcut of reading character datetime stamps into datetime values. i even went so far as suggesting a regex would be a better solution. well, here’s that better solution: data mmddyyyy_hhmmss_xm; if _n_=1 then do; re...
Read more »

Tags: , , , , ,
Posted in SAS | Comments Off

reading iso dates and datetimes

May 7, 2009
By

a while ago, i posted a method of converting YYYYMMDD-style integers to sas date values. today, i needed to convert an YYYYMMDDHHMMSS-style integer to a sas date time value. i could have used the same method of conversion, but i though there had to be ...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

reading iso dates and datetimes

May 7, 2009
By

a while ago, i posted a method of converting YYYYMMDD-style integers to sas date values. today, i needed to convert an YYYYMMDDHHMMSS-style integer to a sas date time value. i could have used the same method of conversion, but i though there had to be ...
Read more »

Tags: , ,
Posted in SAS | Comments Off

converting YYYYMMDD-type integer to corresponding sas date value

December 21, 2007
By

if you've got date keys (e.g., 20071221) that you need to convert to sas date values (21DEC2007), you may run into some troubles.you might be tempted to simply use an informat to read in the integer value as a date value. for example, input(int_val, yy...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.