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: 
cpowell13
‎07-15-2018
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Macros

by Calcite | Level 5 in SAS Programming
‎07-15-2018 07:46 PM
‎07-15-2018 07:46 PM
Hello,    I am having difficultly achieving the following objective when given an excel data file. I have started the code below, but cannot produce an output.    Objective using Macros:  From each of the 5 clinics (inst_num) randomly select 5 AML patients, 10 CML patients, 20 ALL patients, and 5 CLL patients (leu_type). If there are less than 5 AML patients then select all of them, if there are less than 10 CML patients then select all of them, if there are less than 20 ALL patients then select all of them, and if there are 5 CLL patients then select all of them.  Then find cross-tabulation of Leu_type and inst_num. Additionally, print final dataset.    ... View more

Re: Proc Means

by Calcite | Level 5 in SAS Procedures
‎06-25-2018 10:42 AM
‎06-25-2018 10:42 AM
I now have this after your suggestion:    The log is still saying there are no observations for both the proc print and proc means statement... ... View more

Re: Proc Means

by Calcite | Level 5 in SAS Procedures
‎06-25-2018 10:01 AM
‎06-25-2018 10:01 AM
I apologize for the improper protocol. I thought attaching the code was the way to go! Here is my code:      ... View more

Re: Proc Means

by Calcite | Level 5 in SAS Procedures
‎06-25-2018 09:53 AM
‎06-25-2018 09:53 AM
Thank you for your suggestion, but it looks like now there is output in the results viewer for that procedure when I add in the statement. Whenever I add the where statement (I tried that solution earlier) in the log says "No observations were selected from dataset Work.Project2a". As soon as I remove the where statement the code runs, but gives me all four of the districts.    Any thoughts on another "fix"?  ... View more

Proc Means

by Calcite | Level 5 in SAS Procedures
‎06-25-2018 09:37 AM
‎06-25-2018 09:37 AM
Hello,    I am having trouble getting the last statement in my project to work. I am trying to look at the variable absences for all three schooltypes (elementary, middle, and high) but only for specific county. I have gotten it to the point where I used the by statement to see all four counties separately, but I only want the print out to have specific county. Would anyone have any insight on the correct statement to add to narrow down the categories? I attached the code I have created so far.    Thank you ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-15-2018 08:34 PM
Quick links