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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: mplee
  • Order by date
  1. mplee

    IMPORT FROM EXCEL WITH COLUMN RENAMING

    in my experience you can't rename the columns when importing from excel. that would be easy enough to do in a subsequent data, step, however, which is what i usually do. btw, the names you want are illegal since they have embedded spaces. you can use the label command, however, to change how...
  2. mplee

    SAS to Access

    the libname error you have is not a problem with the export function. it means that you have defined to SAS where it can find the file final. presumably this is in a directory somewhere on your hard disk (if you're using PC SAS). you need a statement like this... libname proto "directory...
  3. mplee

    PROC EXPORT: SAS-data-sets to Excel 2000

    whoops! i forgot a critical line in the above. %macro export(dsn,tab); PROC EXPORT DATA= &dsn OUTFILE= "C:\Path\filename.xls" DBMS=EXCEL2000 REPLACE; sheet="&tab"; RUN; %mend; i hope _this_ helps. ** mp **
  4. mplee

    PROC EXPORT: SAS-data-sets to Excel 2000

    assuming you have version 9 %macro export(dsn,tab); PROC EXPORT DATA= &dsn OUTFILE= "C:\Path\filename.xls" DBMS=EXCEL2000 REPLACE; RUN; %mend; then to execute %export(WORKUNIX.MonthlySum,MoSum_Tab); i hope this helps. ** mp **
  5. mplee

    Compress function

    in your example compress will create the text string "YearE/monthasked". Assuming that "YearE" and "monthasked" are numeric it convert them and suppress any space characters that might be included in the conversion. Without the compress function you might get something like " YearE"/"...
  6. mplee

    Excel, last entry in a column

    rather than look for the last total in column C (and off the top of my head i'm not sure how to do that, either) why not compute it separately? if i understand the question correctly you could compute the final total by taking the initial balance and add all the deposits and subtract all...
  7. mplee

    Calculating Mean on a character field count

    the request as written together with the sample data do not make sense. what does "average number of products sold by person" mean? with the sample data provided one can derive the count but an average is meaningless since there is no denominator to average with. otoh, if you had variables...

Part and Inventory Search

Back
Top