cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cy_th
‎06-26-2019
  • 11 Posts
  • 4 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Average

by Fluorite | Level 6 in New SAS User
‎06-25-2019 11:09 PM
‎06-25-2019 11:09 PM
I am trying to calculate the mean of only one variable. When you say 'you cannot change a variable type' does it mean i cannot replace "missing" with a blank input ? because it means the same. I am unable to calculate the mean because it is mentioned as "missing". ... View more

Re: Average

by Fluorite | Level 6 in New SAS User
‎06-25-2019 10:54 PM
‎06-25-2019 10:54 PM
Some of the values are listed as 'missing'. So the proc means step shows it as an error. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc means data=newdata; 74 var score_raw; ERROR: Variable score_raw in list does not match type prescribed for this list. 75 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE MEANS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 76 77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 89 proc import filename="/folders/myfolders/excel_data" dbms = xlsx out= newdata replace; run; proc means data=newdata; var score_raw; run; ... View more

Average

by Fluorite | Level 6 in New SAS User
‎06-25-2019 09:26 PM
‎06-25-2019 09:26 PM
I want to calculate the mean of 'score raw'. How can i do it? I tried to save it as an array and do it but since some values are missing I think it wont work.Also since the array should have elements of the same data type I think what I have done is incorrect. I have attached the excel file here. proc import filename="/folders/myfolders/excel_data" dbms = xlsx out= newdata replace; run; data newdata1; set newdata; array sc(2) score_raw score_num; do i=1; if sc(i) = 'missing' or '' then do; sc(i)=0; end; end; run; proc means data=newdata1; var sc run;   ... View more

Re: SAS base certification

by Fluorite | Level 6 in New SAS User
‎06-24-2019 05:57 PM
‎06-24-2019 05:57 PM
My main aim is to learn it. I would also like to get certified. I have some business analytics courses at my university and I wanted to learn SAS and use it for predictive modelling. But since I am completely new I thought it would be better to start from the basics first. Would'nt you need to know the concepts thoroughly to get certified? ... View more

SAS base certification

by Fluorite | Level 6 in New SAS User
‎06-24-2019 05:42 PM
‎06-24-2019 05:42 PM
I am complete beginner to SAS. I am preparing to give the base certification exam. What would be the best way to proceed? I have 2 months time. At present I am going through 'Learning SAS by example' and a udemy course. Also, I am finding some topics like creating formats and labels confusing. What kind of questions can we expect from such portions?   ... View more

Logic behind programs

by Fluorite | Level 6 in New SAS User
‎06-23-2019 08:00 PM
‎06-23-2019 08:00 PM
I am trying to figure out the logic behind some simple programs. Can someone explain the logic behind the output. How is it generated? How is the use of '@' affecting the output in the second program? data want; input a b ; input c d ; datalines; 1 2 3 4 5 6 7 8 run; proc print data=want; run; data want; input a b @; input c d ; datalines; 1 2 3 4 5 6 7 8 run; proc print data=want; run;   ... View more

Re: Basic SAS program

by Fluorite | Level 6 in New SAS User
‎06-22-2019 11:35 PM
‎06-22-2019 11:35 PM
Yes!! It's working now. Thanks 🙂 ... View more

Re: Basic SAS program

by Fluorite | Level 6 in New SAS User
‎06-22-2019 10:50 PM
‎06-22-2019 10:50 PM
... View more

Re: Basic SAS program

by Fluorite | Level 6 in New SAS User
‎06-22-2019 10:42 PM
‎06-22-2019 10:42 PM
Thanks for your reply. I ran the code and I got this output. Why is it going wrong? ... View more

Basic SAS program

by Fluorite | Level 6 in New SAS User
‎06-22-2019 08:07 PM
‎06-22-2019 08:07 PM
I am trying to print the following data using formatted input.  I am unable to print the purchase price and selling price. Where am i going wrong? I have attached a screenshot of the data and also my output. data Cache; infile "/folders/myfolders/71442_example/stockprices.txt" dsd; input @1 Stock_symbol $4. @5 Purchase_date mmddyy10. @15 Purchase_price 6. @21 Number_of_shares 4. @25 selling_date mmddyy10. @35 selling_price 6. ; format Purchase_date date9.; format selling_date date9.; format Purchase_price dollar11.2; format selling_price dollar11.2; run; proc print data=Cache; run;   ... View more

Basic SAS program

by Fluorite | Level 6 in New SAS User
‎06-22-2019 05:07 PM
‎06-22-2019 05:07 PM
I am trying some very basic SAS programs. It calculates the average of scores obtained in 4 subjects. One of the scores is missing in an observation and hence the average is not getting calculated. How do I overcome this? I have attached a screenshot of my code and output. It is extremely simple. Kindly help. data scores; infile "/folders/myfolders/71442_example/scores.txt"; input gender $ english math history science; avg = (english + math + history +science)/4; run; proc print data=scores; run; This is the data: M 80 82 85 88 F 94 92 88 96 M 96 88 89 92 F 95 . 92 92 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-26-2019 01:09 AM
Likes given to
Quick links