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: 
vkorsz
‎08-14-2018
  • 4 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Export SAS 9.4 file to Access .mdb

by Calcite | Level 5 in SAS Programming
‎08-28-2017 12:43 PM
‎08-28-2017 12:43 PM
ACCESSCS is used for 64-bit systems, so try different DBMS options, like ACCESS, ACCESS97, ACCESS2003, etc. Also, unless you have an old version of Access (2003 or older), then you should be able to use .accdb instead of .mdb.   If you try these and still can't get the export to work then you could be a missing driver or other Access file. ... View more

Re: Randomization

by Calcite | Level 5 in SAS Procedures
‎12-04-2014 01:03 PM
‎12-04-2014 01:03 PM
Ranuni returns a random number from the uniform distribution between 0 and 1.  So it looks like here, the phrase ceil(ranuni(1832577)*2) will return 0 when the random number generated is 0, 1 when the random number generated is greater than 0 and less than or equal to .5, and 2 when the random number generated is greater than .5 and less than or equal to 1. The seed is specified here just to give a reproducible result.  If you do not specify a seed, the results will change each time the code is run.  The seed can be any number less than 2^31-1, including a date or time value as those are stored as numeric values in SAS. ... View more

Re: Using Proc Explode in SAS 9.3

by Calcite | Level 5 in SAS Procedures
‎10-16-2014 01:03 AM
‎10-16-2014 01:03 AM
Thank you! The 1 in front of the text made it work, none of the examples from previous versions of SAS contained that detail.  Appreciate your help! ... View more

Using Proc Explode in SAS 9.3

by Calcite | Level 5 in SAS Procedures
‎10-15-2014 08:05 PM
‎10-15-2014 08:05 PM
I am interested in using PROC EXPLODE for a school project, but when the only examples I can find are from older versions of SAS.  I have read about people using it in SAS 9, but for me it does not run.  I have tried a few examples, such as this one: filename ft15f001 temp; options nodate pageno=1 linesize=80 pagesize=60; proc explode; parmcards; HELLO WORLD ; The error I get is from the line with "HELLO WORLD."  I tried changing up the syntax in different ways, but it gives the error: "ERROR: Column 1 of a parameter line can contain only a number, or the        characters D, L, P, S, or U." I do not understand the parmcards statement, so any information on that could help me out as well. Thank you in advance for any light that can be shed on this topic. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-14-2018 03:49 PM
Likes given to
View All
Quick links