Hi ive tried to use this solution. For now im not worried about the ordering. But im getting this error message: ERROR: The SUM summary function requires a numeric argument ive checked everyithing and all is okay. Is there another code i can use to get round this problem? Thanks.
... View more
Hi ive tried to use this solution. For now im not worried about the ordering. But im getting this error message:
ERROR: The SUM summary function requires a numeric argument
ive checked everyithing and all is okay. Is there another code i can use to get round this problem?
Thanks.
... View more
proc sql;
create table want(drop=minid) as
select year, month, colour, age, sex, sum(total) as total, min(id) as minid
from have
group by year, month, colour, age, sex
order by minid;
quit;
What does the min after id mean?
Thanks.
... View more
I have table A that looks like this, each lline has a unique id, but I havent included it here:
year
month
colour
age
sex
total
2014
Jan
red
10
m
1
2014
Jan
red
10
m
1
2014
Jan
yellow
14
F
1
2014
Jan
yellow
14
m
1
2014
Jan
yellow
14
F
1
2014
Jan
Blue
16
F
1
2014
Jan
brown
14
F
1
I want to summarise this data by summing up each unique combination of colour, age and sex like this:
Table b:
year
month
colour
age
sex
total
2014
Jan
red
10
m
2
2014
Jan
yellow
14
f
2
2014
Jan
yellow
14
m
1
2014
Jan
Blue
16
F
1
2014
Jan
brown
14
F
1
Thanks.
... View more
RW9, The code does not work for reasons that are not syntax based. The problem with left join is that the programme adds extra lines on table a in case of duplicates on table b. All I want is something equivalent to excel vlookup, as table b has more lines and duplicates that i dont need. Thanks.
... View more
HI, RW9 Your coalesce code is showing an error are you sure the syntax is correct? I have tried to use the left join function but this seems to insert additinal linae on my orginal tablea, don't know why.I'm trying your coalesce code but it is giving an error, to avoid confusion my first table is called car and the second is called car1. can you help Thanks.
... View more
How do I proc tabulate from multiple tables but report results on a single table? I have got 3 tables like this: Table A Id item opinionscore 11 car 1 12 car 3 Table B Id item opinionscore 11 plate 1 12 plate 1 Table c Id item opinionscore 11 cup 1 12 cup 4 I want to create a combined by proc tabulate and report on excel as follows. Item Total Score car 4 plate 2 cup 5 total 11
... View more
How can this EXCEL statement be written in SAS Excel version: =IF(OR(AND(A<=X,ISBLANK(B)),(AND(A<=X,B<A))),1,0) in Other words, if A<=X and B is blank then then variable value =1 OR if A<=X and B<1 then variable value =1 else variable value=c I've used a SAS statement like this: data want let value $10: iF A is le X and B ='' then value= ‘1’: if A is le X and B lt A then values='1': else value=0 these statements do not bring up correct results. How do use the OR statement correctly here? I think the error is in the implementation of OR.
... View more
I'm having problems reading the date on my sas table id date 111 01sept10 000000 the date is september 1 2010 ive tried to read this date and produce results like this: id date expiry 111 01sept10 000000 yes by using a code like this length expiry $ 10 if date < '21Apr2014' d then expiry ='yes'; , the problem is the code does not appear to recognize this date format and give incorrect results. I was thinking that the solution may be to change the format of the date to something like 01/09/2010 as this format has worked for me in the past. How do i change the code or which is the quickest way? Thanks.
... View more
I have got the following table. id Name date 11 john 12/04/2014 22 Matt 26 miac 22/01/2013 I want to create a variable, ‘indicator’, that tells me that if a date is before 01/12/2014, 0 is returned and if the date is after this date, 1 is returned and if the date is blank 0 is returned The problem is when SAS sees a blank in my dataset it assumes it as a date and returns results as if the date is before my cut-off date, how do i tell sas to correctly read a blank and return 0? MY data shows a blank. The programme I used is like this: Length indicator $15 if date =' ' then indicator ='0'; if date < '15May2014'd then indicator ='1'; else date ='0'; So I want my results to look like this. Id Name date indicator 11 john 12/04/2014 1 22 Matt 0 26 miac 22/01/2013 0
... View more
RW9 Ok specifically, this is how my imported data, lets call it work. tablea looks like id date 111 12/04/2014 123 26/04/2014 I want to return a table that looks like this, i.e if date is after 20/04/2014 the item has expired if the date is before that then the item has not expired. Results should be shown as follows: id date Expired? 111 12/04/2014 no 123 24/04/2014 yes Thanks
... View more
