topic Re: datalines with dates in SAS Programming

datalines with dates

Myurathan — Thu, 25 Apr 2019 09:04:17 GMT

Hi Experts,

I have never worked with datalines before. For testing purposes, I have to create the following table.

How should I write the code get this table?

Thanks in advance

Kurt_Bremser — Thu, 25 Apr 2019 09:15:24 GMT

Please post code as TEXT in a "little running man" subwindow.

Post logs or other textual data, where the formatting is relevant, into a {i} subwindow.

Post screenshots (only when necessary, and text can't be copied with copy/paste) using the "Photos" button.

DO NOT USE THIRD-PARTY REPOSITORIES for images. These are usually broken by firewalls that prevent access to cloud services.

The latter means I can't open your picture.

See this example for reading dates from datalines:

data want;
input mydate :yymmdd10.;
format mydate yymmddd10.;
datalines;
2019-04-25
;
run;

PS after reloading your post, I could see the picture.

See this code:

data want;
input cust_id Name $ date :ddmmyy10. minutes circle $;
format date ddmmyy10.;
datalines;
2 Henry 01/04/2014 1780 roaming
;
run;

Myurathan — Thu, 25 Apr 2019 09:17:07 GMT

Sorry for the screenshot. The table should look like below.

Cust_ID | Name | Date | Minues | Circle

2 | Henry | 01/04/2014 | 1780 | roaming

Myurathan — Thu, 25 Apr 2019 09:18:22 GMT

Thank you so so much.