Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Biguidance

    Avoiding data set merging problems when by-variable has different leng

    When merging 2 tables on a common by-variable you run the risk of having a different length on this (or these) by variable(s). If this is the case, SAS will casually inform you with the following warning: WARNING: Multiple lengths were specified for the BY variable mergevar by input data...
  2. Biguidance

    Reduce hard coding by using the VCOLUMN table in SASHELP

    Reduce hard coding by using the VCOLUMN table in SASHELP to get a list of your variables into a macro variable array. Very often it is useful to have a list of all the variables you have in a certain table. You don’t always want to type them out yourself (hard coding) but instead want an...
  3. Biguidance

    create several variables in do loop by concatenating already existing

    You can try this: data basetabel_imputed (drop=varname val row n) varnames (keep= varname val row); set basetabel (obs=50 ) end=last; array wit{*} _numeric_; n + 1; do i=1 to dim(wit); if wit(i)=. then do; varname = 'mv'||vname(wit(i)); val = 1; row = n; output varnames...
  4. Biguidance

    Using PROC SQL to simplify lookups which combine different tables

    Imagine you want to have a list of products bought by customers, for instance the ones who live in the US. If your database has a somewhat reasonable structure, the transaction data and the customer’s country will be kept separately. So there are 2 different tables in your SAS data warehouse...
  5. Biguidance

    Quotes!

    How about you don't use the quotes in your macro but in the macro-call, like so: %Import_I_E('Path=\\F\Forms\I&E forms\2011\06 June\', Doc="888745 -O'Shane.XLS", Dmod=18782, Tmod=46380, Team=Team 1) and then leave them out in the macro itself...

Part and Inventory Search

Back
Top