About azee007

azee007 · ‎11-12-2016

Thanks...I understood ... Very detailed explanation. You are truly a gem of a person.

azee007 · ‎11-12-2016

Thanks it worked with some changes as per my data...You really explained well. thanks again ...

azee007 · ‎11-11-2016

data test; input obs name $ number; 1 fish 1 2 bear 2 3 panther 2 4 toad 3 5 fox 4 6 eagle .test; ;run; data work..test; set work.test; if number = . then number = 'Unknown'; else if number =1 then number = 'Low'; else if number=2 or 3 then number = 'Medium'; else number ='High'; run; I have the choice b correct, but i need to know why other choices are not correct. Why not unknown, Low , Medium and High should be result. Need to known the reason why other 3 options are worn. which of the following values does the variable number contain? a. Low, Medium, and High only b. Low, Medium, and Unknown only c. Low, Medium, High and Unknown only d. Low, Medium, High, Unknown and ‘ ‘ (missing character value)

azee007 · ‎11-11-2016

Thanks... I clearly understood your detailed answer. It's really a great help.... I will request another question , if you have time to explain ... I will post soon.

azee007 · ‎11-11-2016

Thanks for the details. Let me work on my data again and see your inputs.

azee007 · ‎11-11-2016

Dear Tom, the bold statement is the one i want to check mistakes, and it is showing exactly what i wrote... Just to pin point my mistakes in that statement.

azee007 · ‎11-11-2016

if Dept=’Worker’ then input/; if Dept=’Worker’ then delete; Input Firstname:$20. Lastname :20. / @cell: ' Cell $@’email:’ Email :$60. Major $; Run; I want to know as per SAS standards does my Input statement has some errors.

azee007 · ‎11-11-2016

I used a really simple solution-It worked ...But need input if any length birthdied $15; if died ='' then birthdied =scan(birth,-1,'/,')||'-'; else birthdied = scan(birth,-1,'/,')||'-'||scan(died,-1,'/,');

azee007 · ‎11-06-2016

Dear Shmuel , Now i understand. I have ran teh code with changes you have suggested buy now teh log is as below with error 72 - year has many arguments if dead= . then birthdead = put(year(born,4.),4.); /* ____ 72 67 ! assigning result value when no death date = just birth YYYY */ 3 The SAS System 18:58 Sunday, November 6, 2016 ERROR 72-185: The YEAR function call has too many arguments.

azee007 · ‎11-06-2016

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.

azee007 · ‎11-06-2016

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.

azee007 · ‎11-06-2016

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;

azee007 · ‎11-06-2016

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.

azee007 · ‎11-06-2016

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 ?

azee007 · ‎11-06-2016

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;

Online Status	Offline
Date Last Visited	‎11-12-2016 10:05 PM

Re: ERROR in Input

Re: Merge

Re: ERROR in Input

Re: ERROR in Input

Re: ERROR in Input

Re: ERROR in Input

ERROR in Input

Re: Calculation required

Re: Calculation required

Re: Calculation required

Re: ERROR in Input

Re: ERROR in Input

Re: Merge

Re: ERROR in Input

Re: ERROR in Input

Re: ERROR in Input

Re: ERROR in Input

ERROR in Input

Re: Calculation required

Re: Calculation required

Re: Calculation required

Re: Calculation required

Re: Calculation required

Re: Calculation required

Re: Calculation required

Re: Calculation required