About azee007

azee007 · ‎11-06-2016

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 .

azee007 · ‎11-06-2016

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;

azee007 · ‎11-05-2016

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 .

azee007 · ‎11-05-2016

I am trying to find a word with .Character string 'with' in the title and is zero if there is no first occurrence of 'with' in the text.Moreover, I dont want WITH or WitH type of words. I am using the following code. I am not getting proper output. It is not giving me the numeric value of with in the title or text. Hope to hear suggestions. data want; set have; length firstwith 4; firstwith = (findw(lowcase(string),'with')>0); run;

azee007 · ‎10-31-2016

Noted with thanks.

azee007 · ‎10-31-2016

Thank you - now the code is exactly i was working on..I just wanted to know f=f8.3 - 8.3 i understood used for 3 decimal places.. But f=f is for format=flavour8.3?

azee007 · ‎10-30-2016

Dear Ksharp, The table i wanted to create was cross-tabulation of the flavor and culture - so I wanted to have the flavors in the rows of the table and separate columns for the two cultures. This would create both the mean and row headers. The table created by the code below have only the statistic header for means. Moreover, want also to control of the header labels -want to remove the summary statistic (mean) and row variable headers from the table. plus the answers to 3 decimal places. CAN YOU PLEASE GUIDE-- proc tabulate data=yogurt; class flavor culture; var time; table flavor*culture, time*mean ; run;

azee007 · ‎10-29-2016

Thank you - I was not using the var statement... I thought table statement wld be enough -

azee007 · ‎10-29-2016

i want to use the tabulate procedure to display the average time for each flavor and culture combination. I am not able to get the average time for each. I have tried few steps... plz suggest how to tabulate to get desired results Available data; Obs flavor culture time 1 blueberry L.acidophilus 1.25381 2 blueberry L.acidophilus 1.19350 3 plain L.acidophilus 1.08703 4 plain L.acidophilus 1.40896 5 plain L.acidophilus 2.63547 6 plain L.acidophilus 2.69992 7 strawberry L.acidophilus 3.01486 8 strawberry L.acidophilus 3.35383 9 strawberry L.acidophilus 3.71758 10 strawberry L.acidophilus 3.38742 11 vanilla L.acidophilus 4.15288 12 vanilla L.acidophilus 4.34319 13 vanilla L.acidophilus 4.12448 14 blueberry B.bifidum 1.02099 15 blueberry B.bifidum 1.46241 16 blueberry B.bifidum 0.78172 17 plain B.bifidum 1.59875 18 plain B.bifidum 1.72159 19 cherry B.bifidum 2.38972 20 cherry B.bifidum 2.27279 21 vanilla B.bifidum 3.17874 22 vanilla B.bifidum 3.06254 23 vanilla B.bifidum 3.20867 proc tabulate data=combination; class flavor culture; table flavor culture; run;

azee007 · ‎10-10-2016

Thankyou very much. Your example really helped my code . Its long code and i was sharing a small part of it , so was not able to get right answers . But your example helped me to get results error free.

azee007 · ‎10-10-2016

Dear Reeze , I have already read all the material . But nothing is particular related to my problem. I have written code as below . But facing issues. Data formate3; set format; length Group $8; by RoomType; if type in ('Basic no view','Basic w/view') then Group='Basic'; else if type in ('Suite','Deluxe suite') then Group='Suite'; else Group='Luxury'; run;

azee007 · ‎10-10-2016

I just wanna know if there is a column RoomType having observations of few types of views and want to group them into 3 variables basic , suit and luxury. The below group is the requirement from the dataset. Group= Basic for Basic room with view or no view; Group = Suite for Suites and Luxury suites; Group = Luxury for Luxury rooms ;

azee007 · ‎10-10-2016

I am trying to group data of one variable RoomType have 4 types of views , and have to group them in my result . But am not getting required result. Please guide. Data formate3; set format; length Group $8; by RoomType; Group= Basic $20 for Basic room with view or no view; Group = Suite $30 for Suites and Luxury suites; Group = Luxury $30 for Luxury rooms ; run; proc print data=format3; run;

azee007 · ‎10-09-2016

Dear Reeze, if Internet= 'Yes' then INTERNET_COST = (InternetDays*4.95)+9.95; THIS IS COMING EMPTY COLUMN. there are days in InternetDays but it is not * with 4.95 and adding to 9.95 . Secondly where i should use dollar12.2 , like where i am using Internet_cost dollar12.2 in if statement or i have use it separately for SAS to read .

azee007 · ‎10-09-2016

dear reeza, I want to use both internet = No and Internet=Yes and if No then consider internet_cost=0 and if yes then consider if Internet= 'Yes' then INTERNET_COST = (InternetDays*4.95)+9.95; but if internet =NO then Internet_cost=0 . so the code would be below , plz advise , and also how to add $ sign in the column result? Data Format2; SET FORMAT; if Internet=No then Internet_Cost = 0 if Internet= 'Yes' then INTERNET_COST = (InternetDays*4.95)+9.95; * STORE RESULTS IN VARIABLE; run; *PRINT RESULTS TO WINDOW FOR DISPLAY; proc print data=format2; run;

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

Calculation required

Re: FInding values

FInding values

how do I find words in text using find()

Re: Tabulate

Re: Tabulate

Re: Tabulate

Re: Tabulate

Tabulate

Re: In SAS IF is No then process

Re: Grouping

Re: Grouping

Grouping

Re: In SAS IF is No then process

Re: In SAS IF is No then process