hello guys and ladies I have half solution I am sorry this is first time I am posting and I did not

[PU1]

data STOCK;

infile

'/folders/myfolders/exdata/annual_stock_price.txt';

input year $ stock1 stock2 stock3 stock4 stock5 stock6 stock7 stock8 stock9

stock10 stock11 stock12 stock13 stock14 stock15 stock16 stock17 stock18 stock19

stock20;

run;

PROC PRINT DATA = STOCK;

RUN;

data STOCK1;

set STOCK;

label stock1 ='Microsoft'

stock2 ='Apple Inc'

stock3 ='Walmart'

stock4 ='BJ'

stock5 ='Costco'

stock6 ='3M'

stock7 ='Eli Lilly'

stock8 ='Pfizer'

stock9 ='Exelon'

stock10='Toyota'

stock11='Ford'

stock12='GM'

stock13='American Airline'

stock14='Johnson & Johnson'

stock15='Exxon'

stock16='Georgia Pacific'

stock17='American Standard'

stock18='Northrop Gruman'

stock19='Sears'

stock20='Peco';

[Kurt_Bremser]

Don't try to put your whole question into the subject. Use the message body instead.

What is your issue/problem, anyway?

[Shmuel]

Any data step or sas procedure should end by  run;

It seems to me that you want:

data STOCK;
infile
'/folders/myfolders/exdata/annual_stock_price.txt';
input year $ stock1 stock2 stock3 stock4 stock5 stock6 stock7 stock8 stock9 stock10 
             stock11 stock12 stock13 stock14 stock15 stock16 stock17 stock18 stock19 stock20;

label 
stock1 ='Microsoft'
stock2 ='Apple Inc'
stock3 ='Walmart'
stock4 ='BJ'
stock5 ='Costco'
stock6 ='3M'
stock7 ='Eli Lilly'
stock8 ='Pfizer'
stock9 ='Exelon'
stock10='Toyota'
stock11='Ford'
stock12='GM'
stock13='American Airline'
stock14='Johnson & Johnson'
stock15='Exxon'
stock16='Georgia Pacific'
stock17='American Standard'
stock18='Northrop Gruman'
stock19='Sears'
stock20='Peco'
;

run;

PROC PRINT DATA = STOCK;
RUN;

[PU1]

Thank you so much I need coding for percentage

[Kurt_Bremser]

Please be more specific. Percentage describes a relationship between two values. Which values should be used for the calculation?

Also post the code you already have, and where the result diverges from your intended result.

We are here to help you achieve something, not to help you in being lazy.

[LinusH]

Sorry, still not clear about what want to do.
Perhaps you have a colleague or friend that can help you describe the issue a bit mor fully bodied?