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: 
emkotnik
‎05-23-2018
  • 9 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Check and Verify for numeric data

by Calcite | Level 5 in SAS Programming
‎03-22-2018 01:00 PM
‎03-22-2018 01:00 PM
I was wondering if there is a way to use the verify function with my check as a numeric interval. For example,   data want; set have; check= '1-10'; if verify(Age, check) ne 0 then put 'not allowed'; run;   Thank you!  ... View more

Re: Character values into date values

by Calcite | Level 5 in SAS Programming
‎03-02-2018 09:46 PM
‎03-02-2018 09:46 PM
What was the error you recieved? ... View more

Summing Months by year

by Calcite | Level 5 in Statistical Procedures
‎03-02-2018 09:35 PM
‎03-02-2018 09:35 PM
I have a dataset with Year in the rows, and  the months Sep-May as the columns. I am trying to sum the months by year, in this case Sep-May is considered one year. I am unsure of how to go about this as I cannot figure out how to sum all 9 months together for about 200 years.  Here is what I've been working with though I have been unsuccessful.    proc means data=schoolyear sum maxdec=0; class year; var Sep Oct Nov Dec Jan Feb Mar Apr May; run;   Thank you in advance! ... View more

Re: Ordering Months

by Calcite | Level 5 in SAS Programming
‎03-02-2018 09:12 PM
‎03-02-2018 09:12 PM
Great, that makes sense. I recognized the 6.0 as a format but the *f was unfamiliar to me. Thank you very much, I appreciate it! ... View more

Re: Ordering Months

by Calcite | Level 5 in SAS Programming
‎03-02-2018 09:00 PM
‎03-02-2018 09:00 PM
Thank you! I really appreciate that you took the time to explain the functions and steps you took, I'm still learning SAS and the explanations really help clarify everything. I did have one quick question though. What is the purpose of the *f=6.0 option in the table statement? Thank you again! ... View more

Re: Ordering Months Starting with September

by Calcite | Level 5 in SAS Programming
‎03-02-2018 08:46 PM
‎03-02-2018 08:46 PM
Thank you very much! I had tried this as a simple solution but was wondering if there was a more elegant solution. I'm still learning SAS and can find a solution but know that its likely not the most efficient or elegant way. ... View more

Re: Ordering Months Starting with September

by Calcite | Level 5 in SAS Programming
‎03-02-2018 12:47 PM
‎03-02-2018 12:47 PM
Thank you so much! Everything looks great! I am just learning SAS so I either forget about or am unaware of a lot of the options available for each procedure. The help with renaming the columns was a nice added bonus! Thank you again, I really appreciate it. ... View more

Re: Ordering Months Starting with September

by Calcite | Level 5 in SAS Programming
‎03-02-2018 12:19 PM
‎03-02-2018 12:19 PM
No, Month wasn't a SAS date, it was a character variable in the original dataset.  ... View more

Ordering Months

by Calcite | Level 5 in SAS Programming
‎03-02-2018 12:06 PM
‎03-02-2018 12:06 PM
I am currently trying to order the months in my dataset  Sep-May and have been unable to find a solution that works. I have sorted the data by month to transpose it into the format I needed but this ordered it alphabetically. I have submitted my code below and included the resulting table. Thank you!   proc sort data=perm.snow1a out=perm.snowy2; by month; where Year >=1992 and Year<=2001; run; proc Transpose data=perm.snowy2 name= Month out=perm.snowyy2 (rename=(col1=Year1992 col2=Year1993 col3=Year1994 col4=Year1995 col5=Year1996 col6=Year1997 col7=Year1998 col8=Year1999 col9=Year2000 col10=Year2001)); var Snowfall; by Month; run; proc print data=perm.snowyy2 noobs; title "Monthly Snowfall by Year"; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-23-2018 12:01 PM
Likes given to
View All
Quick links