i have used the first option proc means data= < donate table> NWAY noprint missing; class ID; var AmtPaid; ID LName FName; /* assuming unique per ID, ready for the report */ output out=totals_paid sum=amt_paid; run; proc sort data=totals_paid; by ID /* or by LName FName */; run; But if i have data with some missing values that they have same IDs lets suppose 25 and have paid 4 times but the name of ID 25 is mentioned in the obs where the person have not paid any things so it is missing. When i run teh code , the SAS is not reading teh name from the missing Amt_paid. Can I get the names read from missing Amt Paid observations , so that no name is missed .
... View more
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,'/,');
... View more
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,'/,');
... View more
You're close.
Your function appears correct, but you don't need the > 0 portion. That turns it into a true/false calculation rather than returning the index.
You also shouldn't apply lowcase if your test is case sensitive. And since you're searching for a word, use FINDW()
Index_with = findw(string, 'with');
... View more
I tend to think of F8.3 as Fixed, 8 columns and 3 decimal places. I think that way because I've been involved with enough projects reading data with the F8.3 format where the decimals are IMPLIED and inserted at read. I also use the F habitually to make sure that I am using the intended format not z8.3 or something else.
... View more
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.
... View more
@azee007 wrote: 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.
We're not psychic. What does 'facing issues' mean?
1. Are there errors in your log?
2. Are results not what you expect? In not, how are they different? Show what you have, what you get, and what you want.
3. From your last question recall string comparisons are case sensitive.
4. Note that you're referencing FORMAT dataset. In your last questions you had progressed to. FORMAT2. If you want your code to build upon each other make sure to reference correct dataset. Also, since FORMAT has a specific meaning in SAS I would recommend avoiding that word as a dataset name to avoid any confusion.
... View more
Make sure your days are correct with hotel definition.
You're doing stragiht subtraction there, which is number of nights booked. The number of days is often +1 in travel speak, or 6 night/7-day trip.
... View more
