What do you mean ? proc format; invalue $fmt 'Nov'=11 'Dec'=12 ......... ; run; num_date=mdy( input(scan(char_date,'-',2),$fmt.), input(scan(char_date,'-',1),best8.), input(scan(char_date,'-',-1),best8.);
... View more
proc sql;
create work.desired as
select work.a.iteration,work.a.draw, work.b.*
from work.a left join work.b on work.a.id=work.b.id
;
quit;
Might work for you. Sql joins often run quicker than MERGE on large data sets.
... View more
Answer: Yes and too many ways to describe here. The one with the least amount of coding is probably:
[pre]
data have1;
input Year;
cards;
2000
2001
2002
;
data have2;
input Party $;
cards;
Dem
Repub
Green
Other
;
proc sql noprint;
create table want as
select *
from have1, have2
;
quit;
[/pre]
HTH,
Art
--------
> Hey all, hoping you can help me out with this
> question, which has cooked my brain a bit. Lets say I
> have two data sets, "Year" and "Party"
>
> Year:
> 2000
> 2001
> 2002
>
> Party:
> Dem
> Repub
> Green
> Other
>
> What I'm trying to do is make a new data set,
> "Merge", that ends up with the following
> 2000 Dem
> 2000 Repub
> 2000 Green
> 2000 Other
> 2001 Dem
> 2001 Repub
> 2001 Green
> etc.
>
>
> Is this possible to do via SAS?
... View more
