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: 
mojerry
‎09-01-2015
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Clinical Trial: Macro to read all Datasets in a library in order ...

by Calcite | Level 5 in SAS Programming
‎04-29-2009 08:56 AM
‎04-29-2009 08:56 AM
your proc contents stores in a dataset (dset1) the different existing datasets. now you have to know the dataset names. In the proc sql you'll put the dataset names into dset macrovariable. For each observation sas will add in dset the dataset name found seperated by a space. proc sql; select into:dset seperated by " " from dset1; quit; Now you have everything; data all; set &dset; run; ... View more

Re: Can anyone confirm these statements?

by Calcite | Level 5 in SAS Programming
‎04-29-2009 05:41 AM
‎04-29-2009 05:41 AM
yeah, golden rules 😉 1. Select only the data you really need. So select the needed columns and create a where close who gives you only the relevant data. 2. If working on huge data, indexes can be usefull. Too complicated indexes will kill your performance. 3. Use the right formats on datasets. $200. isn't usefull to store yes or no. Same idea on numbers, don't store them as text 😉 4. data is stored on other disk than your sas work. 5. go on... ... View more

integration services

by Calcite | Level 5 in Microsoft Integration with SAS
‎04-29-2009 05:11 AM
‎04-29-2009 05:11 AM
Hi, I'm working on a new project trying to test the connectivity between sql server 2008 and SAS. I'm trying to have a job created in visual studio (VS) to import SAS data to a sql server database. But I have a lot of trouble to configure the odbc connector. Different drivers are visible in the connection manager : iom data provider, olap data provider 9.1, ole dp for olap provider for sas, local data provider, ... The problem is when VS asks me to choose a table he gives a really nice error. the requested collection (tables) is not defined. (system.data) Could not retrieve the table information. can someone tell me how to retrieve data? This is not a solution : upload the data from sas to sql server... 😉 thanks a lot ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links