DATA Step, Macro, Functions and more

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

Reply
Occasional Contributor PU1
Occasional Contributor
Posts: 14

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

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';
Super User
Posts: 7,771

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

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

 

What is your issue/problem, anyway?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Trusted Advisor
Posts: 1,556

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

Posted in reply to KurtBremser

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;
Occasional Contributor PU1
Occasional Contributor
Posts: 14

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

Thank you so much I need coding for percentage
Super User
Posts: 7,771

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor PU1
Occasional Contributor
Posts: 14

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

Posted in reply to KurtBremser
Super User
Posts: 5,426

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

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?
Data never sleeps
Ask a Question
Discussion stats
  • 6 replies
  • 175 views
  • 0 likes
  • 4 in conversation