topic Re: Base sas in SAS Programming

Base sas

don21 — Tue, 27 Feb 2018 07:23:46 GMT

HI,

I have 4 data sets containing date variables:

Table1

date is in date format (21-Mar-2017)

table 2

date is in character (21 Mar 2017)

table3

date is in character (21 mar 2017)

table4

date is in date format (21-mar-2017)

am trying to change the char to date format but it displays nil values. Please help. I need to merge the 4 tables.

Re: Base sas

Kurt_Bremser — Tue, 27 Feb 2018 08:06:22 GMT

Please supply

- information about the date variables in all datasets with type, length and assigned format

- the code you already tried for those variables

- example values for numeric variables, raw without any format (use best.)

Re: Base sas

don21 — Tue, 27 Feb 2018 08:15:09 GMT

Tabl 1 Date (char)
17-Jun-2016

Table 2 Date (Date)
6-Sep-17

I need to merge table 1 and 2 but when I try to conver char to date or date to char the variable is not piking any values.

Re: Base sas

Kurt_Bremser — Tue, 27 Feb 2018 08:56:55 GMT

Please read my post again and assist me in helping you. Right now I don't know a jota more than before.

Re: Base sas

RW9 — Tue, 27 Feb 2018 10:02:46 GMT

Please refer to this post:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

On how to create test data which shows what your data looks like, both data wise, but also structurally. Its also a good idea to post code you have written.

Re: Base sas

don21 — Wed, 28 Feb 2018 04:56:22 GMT

data Magellan3;

set Magellan2;

PastDueSince=input(PastDueSince,mmddyy16.);

run;

DATA Past_Due_Actual_Days2;

/*format PastDueSince date9.;*/

SET Past_Due_Actual_Days;

/*PastDueSince = f20;*/

PastDueSince =inputput(F20,f8.0),yymmdd.);

/*PastDueSince = PastDueSince - 21916;*/

RUN;

Re: Base sas

don21 — Wed, 28 Feb 2018 04:58:09 GMT

Re: Base sas

Satish_Parida — Wed, 28 Feb 2018 08:48:48 GMT

You are using wrong formats everywhere.

mmddyy16 is not informat for 17-Jun-2016 nor is yymmdd. You need to use date11.

data mylasr.test1;
Date1=input("15-jul-2015", date11.);
output;
run;

Re: Base sas

Kurt_Bremser — Wed, 28 Feb 2018 08:59:40 GMT

This:

data Magellan3;
set Magellan2;
PastDueSince=input(PastDueSince,mmddyy16.);
run;

can never work. You cannot change the type of a variable.

Re: Base sas

don21 — Wed, 28 Feb 2018 09:32:50 GMT

Hi Have modified my previous query:

data test1(drop = PastDueSince);

set Past_Due_Actual_Days2;

format _PastDueSince date9.;

_PastDueSince = input(trim(PastDueSince),date9.);

PastDueSince = PastDueSince;

rename _PastDueSince=PastDueSince;

run;

Works like charm!!!

Re: Base sas

Kurt_Bremser — Wed, 28 Feb 2018 09:36:43 GMT

For clarity's sake, I'd write it a little differently:

data test1 (
  drop=_PastDueSince
);
set Past_Due_Actual_Days2 (
  rename=(PastDueSince=_PastDueSince)
);
format PastDueSince date9.;
PastDueSince = input(trim(_PastDueSince),date9.);
run;

This makes it more readable with regards to what is converted to what.