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: 
esjackso
‎06-30-2023
  • 337 Posts
  • 125 Likes Given
  • 1 Solutions
  • 118 Likes Received
About
BA in Economics MA in Applied Economics Over 10 years as a SAS professional in Healthcare research

Re: Replace Alt+Enter from Excel

by Quartz | Level 8 in SAS Programming
‎04-23-2013 03:56 PM
‎04-23-2013 03:56 PM
Gotcha -- didnt think of that. EJ ... View more

Re: Replace Alt+Enter from Excel

by Quartz | Level 8 in SAS Programming
‎04-23-2013 02:15 PM
‎04-23-2013 02:15 PM
Would compressing out control charters work? compress(var,'','C')? EJ ... View more

Re: Clustering people by location

by Quartz | Level 8 in Statistical Procedures
‎04-22-2013 12:22 PM
‎04-22-2013 12:22 PM
We are actually trying to come up with a minimization of between people distances right now, we just dont know yet how it is going to turn out. We are manually writing the code for it so it taking some time to tweak and get it to  work. ... View more

Clustering people by location

by Quartz | Level 8 in Statistical Procedures
‎04-22-2013 10:57 AM
‎04-22-2013 10:57 AM
We are trying to figure out a way to group people in our state by location (actually zipcode lat, long), to find out where reps should be to be efficiently close in order to visit these people. Does anyone have any hints or tricks that they can share? We know how many reps we need in each region but not necessarily where they should be located. We have tried clustering on lat and long but dont get equal sized clusters. Just interested if anyone has any insight they can share! Thanks! EJ ... View more

Re: Can we macronize the libnames?

by Quartz | Level 8 in SAS Procedures
‎04-19-2013 11:43 AM
‎04-19-2013 11:43 AM
You need it in two places that come to mind: file names and libname refereces both because they have period within the syntax, if memory serves e because the period and acts as a delimiter like a space when the macro is complied: &test..xls --> where &test. is the macro variable and .xls is the file extension syntax --> without the extra period the file name fails because improper filename (ie no extension). &libname..data --> where &libname. is the macro variable and .data is the dataset name syntax --> without it probably reads as the name of a temporary dataset. Hope that helps! EJ ... View more

Re: two level sort

by Quartz | Level 8 in SAS Programming
‎04-19-2013 09:02 AM
1 Like
‎04-19-2013 09:02 AM
1 Like
Perhaps Im missing something but a a standard proc sort data=your table; by exp measurementY; run; should do what you seek. EJ ... View more

Re: Can we macronize the libnames?

by Quartz | Level 8 in SAS Procedures
‎04-18-2013 03:15 PM
1 Like
‎04-18-2013 03:15 PM
1 Like
Did you have a double period after the libname macro var? data= &libname..&product.__&mth ; EJ ... View more

Re: Wow is it me or is the SAS community selling movies!

by Quartz | Level 8 in SAS Programming
‎04-18-2013 08:25 AM
‎04-18-2013 08:25 AM
I appreciate the work that SAS has put into the forum and a problem like this isnt usually easy to solve quickly. In some sense is a sign of growth of the forum that it has attracted attention. Thanks! EJ ... View more

Re: ODS

by Quartz | Level 8 in SAS Programming
‎04-17-2013 10:29 AM
‎04-17-2013 10:29 AM
If i am remebering correctly after your define statements place: rbreak after / summarize if you want lines to break up the table from the totals add ul ol after summarize (under line / over line). Hope that helps EJ ... View more

Re: I want to create a new variable and see if the entire row has 0 or...

by Quartz | Level 8 in SAS Programming
‎04-12-2013 07:15 AM
‎04-12-2013 07:15 AM
Here is a simple flagging in a dataset. If you just want a dataset of the ids you could just keep those variables. data out;      set in;      flag = 1 + sum(score, post, forum, quiz, assign, main, group);      if flag = 1 then output; run; If you want to just produce a report you could use sql; Proc sql;      select course,   class,  user                (1 +    score +  post  +   forum  +  quiz + assign  +   main + group ) as flag      from in      where calculated flag = 1      ; quit; Just some thoughts, hope it helps! EJ ... View more

Re: Libname error with excel engine

by Quartz | Level 8 in SAS Programming
‎04-08-2013 08:49 AM
‎04-08-2013 08:49 AM
Sounds like you need to submit a support ticket and let SAS Support answer. EJ ... View more

Re: Libname error with excel engine

by Quartz | Level 8 in SAS Programming
‎04-08-2013 08:31 AM
‎04-08-2013 08:31 AM
We didnt ask a lot of question since we had licenses for both versions of Office 2010 so we tried it and stopped our problems. EJ ... View more

Re: Libname error with excel engine

by Quartz | Level 8 in SAS Programming
‎04-08-2013 08:24 AM
‎04-08-2013 08:24 AM
I believe we had problems even with proc import and import wizard. ... View more

Re: Libname error with excel engine

by Quartz | Level 8 in SAS Programming
‎04-08-2013 08:23 AM
‎04-08-2013 08:23 AM
We have a complete 64 bit setup so we had to match that with office. This was a switch from local sas 9.3 to remote Server SAS 9.3 so I dont know if this was a 9.3 issue or not. ... View more

Re: Libname error with excel engine

by Quartz | Level 8 in SAS Programming
‎04-08-2013 08:08 AM
‎04-08-2013 08:08 AM
I believe we were directed by SAS support to install 64 bit office on our server before the libname would work. EJ ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-30-2023 02:16 PM
Likes given to
Likes from
Quick links