topic Re: pull specific year in SAS Procedures

pull specific year

tjonas — Tue, 17 May 2011 13:12:13 GMT

I have a table with the same field names but some of the data is from 2010 and some from 2009. How do I pull just the 2010 data into a new table?

Re: pull specific year

DanielKaiser — Tue, 17 May 2011 13:15:02 GMT

Have you tried the PROC SQL with a WHERE Statement?

Re: pull specific year

tjonas — Tue, 17 May 2011 13:18:39 GMT

I'm a new sas user. Not sure how to use the sql.

Re: pull specific year

DanielKaiser — Tue, 17 May 2011 13:22:29 GMT

Ok. Have a look at this.

http://www2.sas.com/proceedings/sugi27/p191-27.pdf

If it doesnt help come back and we will go on 🙂

Re: pull specific year

DanielKaiser — Tue, 17 May 2011 13:27:18 GMT

PROC SQL;
CREATE TABLE DESTINATION.TABLE AS
SELECT * /* Take all Variables from your source table otherwise you can list all var. you want to take */
FROM SOURCE.TABLE
WHERE YEARVARIABLE = 2010;
QUIT;

Hope this works. Haven't worked with SQL so much.

Re: pull specific year

tjonas — Tue, 17 May 2011 13:56:59 GMT

Has this error:
ERROR: Expression using equals (=) has components that are of different data types

Re: pull specific year

DanielKaiser — Tue, 17 May 2011 14:09:44 GMT

Hm. write 2010 like this '2010' ?

Sry. Not really good english 😄

Re: pull specific year

SPR — Tue, 17 May 2011 14:15:44 GMT

Hello Hjonas,

Try this:
[pre]
data r;
set i;
where YEAR(date)=2010;
run;
[/pre]
If it will not help give us and example of your data.
Sincerely,
SPR

Re: pull specific year

tjonas — Tue, 17 May 2011 15:50:40 GMT

Work. thanks.