topic Re: How to pick up dates with ID-based data? in New SAS User

How to pick up dates with ID-based data?

lsw2920 — Thu, 15 Nov 2018 23:29:35 GMT

I'm new to SAS and trying to program a simple code.

Original data:
TableA

ID | Date | Type

1 20111111 A

2 20081014 C

3 20051126 A

...

100 20160421 B

From this original data, I want to pick up dates by Type.

Like following

Result (only picking up A & B)

ID | DateofA | DateofB

1 | 20111111 |

2 | |

3 | 20051126 |

...

100 | | 20160421

Are there anyone know how to program this?

Thank you for advance.

Re: How to pick up dates with ID-based data?

RW9 — Thu, 15 Nov 2018 11:26:09 GMT

Thats called transposing data:

proc sort data=have;
  by id type;
run;
proc transpose data=have out=want prefix=dateof;
  var date;
  id type;
  idlabel type;
run;

Re: How to pick up dates with ID-based data?

ballardw — Thu, 15 Nov 2018 16:04:58 GMT

If the function Year(date) for your example value of 20111111 does not return 2011 then you don't actually have "dates" you only have numeric (or possibly character) values and you might want consider creating actual date values so that you can manipulate them with the proper SAS functions and formats.

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 has a PDF with much information about dates.