Choosing selected variables

[AbuChowdhury]

By the by, how can I change the data structure of "p2004_usa" to long-structured through proc sql and vice versa?

[Reeza]

Use Proc Transpose or a Data step.

Generally, PROC SQL isn't a good way to transpose data.

http://www.ats.ucla.edu/stat/sas/modules/wtol_transpose.htm

[Ksharp]

How do you map these ar1 ,ar2 .......  into US0010311035 US00163U1060 ..  ? they have the exactly same order ?

[AbuChowdhury]

I got ar1, ar2 from another calculations. Yes, they are in same order: ar1, ar2, ar3,........

[Ksharp]

Add this

options dkricond=nowarn  dkrocond=nowarn ;

before data step.

[AbuChowdhury]

Same as before. Now the output dataset has only 'Date' variable. Other variables are gone.

[PGStats]

Listen to 's sound advice. - PG

[Reeza]

To limit your data you can use a WHERE statement in a data step or proc, assuming you have a SAS date.

e.g.

where year(date)=2004;

How to use the data set decile? That depends on how you want to use it. I suspect you'll need to merge it in but you'll have to provide a sample input/output for more detailed help.