topic Re: hello guys and ladies I have half solution I am sorry this is first time I am posting and I did in SAS Programming

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

PU1 — Sat, 14 Jan 2017 05:56:11 GMT

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';

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

Kurt_Bremser — Sat, 14 Jan 2017 08:04:04 GMT

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

What is your issue/problem, anyway?

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

Shmuel — Sat, 14 Jan 2017 11:16:33 GMT

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;

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

PU1 — Fri, 20 Jan 2017 06:35:25 GMT

Thank you so much I need coding for percentage

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

PU1 — Fri, 20 Jan 2017 06:46:17 GMT

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

Kurt_Bremser — Fri, 20 Jan 2017 07:11:29 GMT

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.

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

LinusH — Fri, 20 Jan 2017 07:26:21 GMT

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?