topic Re: Calculation required in SAS Programming

FInding values

azee007 — Sun, 06 Nov 2016 02:32:48 GMT

I am trying create a character variable of length 15 called birthdead.

Should be calculated as birthyear-diedyear if both values are present and

birthyear - if the person is still present.

My data given is dates of birth and died in the form mm/dd/yyyy and some dates in yyyy.I need to handle both cases.

I also want that the not equal relation can be specified using ^= or ne in case it is needed.

I was reading different posted questions , but could find anything related to my query- Can anybody help - It would really make my concepts clear .

Re: FInding values

Shmuel — Sun, 06 Nov 2016 03:35:58 GMT

Let's create a test data:

data have;

length birth_x death_x $10;

infile datalines dlm=',' ;

input birth_x $ death_x $;

datalines;

1896,1965

1903,08/25/1999

12/15/1980,02/28/2015

03/21/1960,

08/06/2012,

; run;

%macro dt_convert (dtx , dt);

if length(&dtx) = 4

then &dt = mdy(01,01,input(&dtx,4.));

else &dt = input(&dtx , mmddyy10.);

%mend dt_convert;

data want;

set have;

length birthdead $10;

%dt_convert(birth_x , birth_date);

%dt_convert(death_x , death_date);

if death_date = . then birthdead = put(year(birth_date),4.);

else birthdead = catx('-' , year(birth_date), year(death_date));

format birth_date death_date mmddyy10.;

drop birth_x death_x;

run;

Re: FInding values

azee007 — Sun, 06 Nov 2016 04:33:55 GMT

There are following errors coming in log
if died = . then birthdead = put(year(birth_date),4.);
_
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +,
',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT,
MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

71 else birthdead = catx('-' , year(birth_dead), year(death_date));
72 drop birth_x death_x;

Calculation required

azee007 — Sun, 06 Nov 2016 05:53:32 GMT

I am trying to create a character variable of length 15 called birthdead.

Should be calculated as birthyear-deadyear if both values are present and

birthyear - if the person is still present.

My data given is dates of birth and died in the form mm/dd/yyyy and some dates in yyyy.I need to handle both cases.

I also want that the not equal relation can be specified using ^= or ne in case it is needed.

I was reading different posted questions , but could find anything related to my query- Can anybody help - It would really make my concepts clear .

datalines;

Obs born died

1 1/7/1850 7/04/1940

2 11/08/1928

3 5/27/1877 4/21/1936

4 1911 1970

5 1918 1950

6 4/1/1921 3/14/99

7 1944

8 1954

Re: FInding values

Shmuel — Sun, 06 Nov 2016 06:29:16 GMT

I havn't used a variable named DIED.

You have probably changed the code to addapt it to your needs.

You may missed an ';' at the end of a previous statemant or have a typo.

If you can't find the reason to the ERROR message, please post your full log.

Re: Calculation required

Reeza — Sun, 06 Nov 2016 06:41:15 GMT

Include what you expect as output please.

Also, are your variables character or numeric in your dataset?

Re: Calculation required

Shmuel — Sun, 06 Nov 2016 06:44:19 GMT

You posted your input but not your full log or at least your full code.

Re: Calculation required

Shmuel — Sun, 06 Nov 2016 06:45:32 GMT

and no need to repeat your first post.

Re: Calculation required

azee007 — Sun, 06 Nov 2016 14:52:37 GMT

These are characters with length 10 each...I have used the following code.But getting lot of errors in log

length birthdead $10;
%macro dt_convert (dtx , dt);
if length(&dtx) = 4
then &dt = mdy(01,01,input(&dtx,4.));
else &dt = input(&dtx , mmddyy10.);
%mend dt_convert;
data want;
set have;
%dt_convert(birth_x , birth);
%dt_convert(dead_x , dead);
if died = . then birthdead = put(year(born,4.);
else birthdead = catx('-' , year(birth), year(dead));
drop birth_x dead_x;

Re: Calculation required

Shmuel — Sun, 06 Nov 2016 15:20:50 GMT

##- Please type your reply above this line. Simple formatting, no
attachments. -##Sentfrom my smartphone.
The length statement should be inside the datastep. Probably all error
messages are the result of above error

Re: Calculation required

azee007 — Sun, 06 Nov 2016 20:10:26 GMT

Dear Shmuel,

I am using data want;
set have ;
then comes my code
and at the end run;
These are the basics of SAS ... I wanted to know if there is error in my code -If you find any ?

Re: Calculation required

Shmuel — Sun, 06 Nov 2016 20:24:01 GMT

The macro definition should be out of the datastep.

try next code:

%macro dt_convert (dtx , dt);
if length(&dtx) = 4
then &dt = mdy(01,01,input(&dtx,4.));
else &dt = input(&dtx , mmddyy10.);
%mend dt_convert;

data want;
set have;

length birthdead $10;
%dt_convert(birth_x , birth);
%dt_convert(dead_x , dead);
if died = . then birthdead = put(year(born,4.);
else birthdead = catx('-' , year(birth), year(dead));
drop birth_x dead_x;

run;

Re: Calculation required

azee007 — Sun, 06 Nov 2016 20:24:08 GMT

Dear Reeze ,
I have mention that i need the following as output
;
I am trying to create a character variable of length 15 called birthdead.

Should be calculated as birthyear-deadyear if both values are present and
birthyear - if the person is still present.

My data given is dates of birth and died in the form mm/dd/yyyy and some dates in yyyy.
I need to handle both cases.

I also want that the not equal relation can be specified using ^= or ne in case it is needed.

Re: Calculation required

azee007 — Sun, 06 Nov 2016 20:32:29 GMT

I am getting the same log errors as before- Error 22 and 76.

if dead = . then birthdead = put(year(birth,4.);
_
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +,
',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT,
MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

66 else birthdead = catx('-' , year(birth), year(dead));
67 drop birth_x dead_x;
68 run;

Re: Calculation required

Shmuel — Sun, 06 Nov 2016 20:32:42 GMT

If you compare my last post to some previous you will find exact code written before.

Re: Calculation required

Shmuel — Sun, 06 Nov 2016 20:35:48 GMT

This line should be:

if dead = . then birthdead = put(year(birth,4.),4.);

Re: Calculation required

azee007 — Sun, 06 Nov 2016 20:38:17 GMT

Dear Shmuel,

Can you please explain me in much simpler form , as i couldnt understand what you are trying to tell me . I have been working on this code now for a long time ...but the requirement that :

Should be calculated as birthyear-deadyear if both values are present and
birthyear - if the person is still present.

My data given is dates of birth and dead in the form mm/dd/yyyy and some dates in yyyy.
I need to handle both cases.

I also want that the not equal relation can be specified using ^= or ne in case it is needed.

Re: Calculation required

Shmuel — Sun, 06 Nov 2016 20:53:31 GMT

Here is just the last datastep with some remarks added:

I have just noticed a typo: you created variable DEAD but used variable DIED.

I have changed it into - in bold letters - died.

data want;
set have;

length birthdead $10; /* assigning length to the new variable to create which shoulb be

in a format of: YYYY-YYYY or just YYYY */
%dt_convert(birth_x , birth); /* converting birth date from character to SAS numeric date */
%dt_convert(dead_x , died); /* converting death date from character to SAS numeric date */
if died = . then birthdead = put(year(born,4.); /* assigning result value when no death date = just birth YYYY */
else birthdead = catx('-' , year(birth), year(died)); /* assignung result as BIRTH-DEATH years: YYYY-YYYY */

/* instead CATX function yo can write: */

/* left(year(birth)) || '-' || left(year(died)) */
drop birth_x dead_x; /* dropping that variables as not needed to keep on output */

run;

Re: Calculation required

azee007 — Sun, 06 Nov 2016 21:13:15 GMT

Do i have to use
%macro dt_convert (dtx , dt);
if length(&dtx) = 4
then &dt = mdy(01,01,input(&dtx,4.));
else &dt = input(&dtx , mmddyy10.);
%mend dt_convert;

as i am using above code before the new code and still getting the same log erros

if died = . then birthdead = put(year(birth,4.); /* assigning
_
22
3 The SAS System 16:08 Sunday, November 6, 2016

76
68 ! result value when no died date = just birth YYYY */
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +,
',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT,
MAX, MIN, NE, NG, NL, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.

ERROR 76-322: Syntax error, statement will be ignored.

Re: Calculation required

Shmuel — Sun, 06 Nov 2016 21:19:55 GMT

data want;
set have;

length birthdead $10;

%dt_convert(birth_x , birth);
%dt_convert(dead_x , died);
if died = . then birthdead = put(year(born,4.),4.); /* sorry, my typo: correct this line: all brackest should be even)
else birthdead = catx('-' , year(birth), year(died));
drop birth_x dead_x;