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 Mike Lewis 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. sap1958

    Pivot SAS dataset Ideas

    proc sql; create table test as select ln_no,thismonth,lastmonth from mytest; quit; sample output ln_no thismonth lastmonth 1123 current 30 day 1344 30 day current 24333 current 60 day 2445 current 60 day I need to pivot the...
  2. sap1958

    Suppress leading zero in a date in sas

    I am using sas 9.3. I have a date called pbd_date that displays mmddyy10. Lets say the date is 03/14/2013, how can I get sas to drop the leading zero and display it as 3/14/2013.
  3. sap1958

    Frontpage 2003 Not Compatible with Windows 7

    If I purchase Microsoft Expressions (which is the successor) it should work on w7 home edition I think. There is also a free sharepoint designer 2007. I heard it might work with that.
  4. sap1958

    Frontpage 2003 Not Compatible with Windows 7

    I think 64 bit but not sure. What are the possible outcomes here
  5. sap1958

    Frontpage 2003 Not Compatible with Windows 7

    When I do a save as in frontpage 2003 I get an eror message: unexpected error occured, not enough memory, try closing other programs and try again. I researched this further and read where windows 7 home edition may not be compatible with frontpage 2003. Is there a workaround? It worked fine...
  6. sap1958

    Cannot access webshare in My Network Places

    I set up a webshare in my network places a few days ago and it worked fine. Yesterday I attempted to access the webshare and got the message; Docments in this folder not available. FOlder may have been moved or deleted or network problems may be prevnting connection to the server. Why would I...
  7. sap1958

    Importing problem in SAS infile statement

    Here is a snapshot of the data I am importing: james smith" <james_smith@hotmail.com> "a allen" <weshae@aol.com>, "aaron jones" <meismjones@gmail.com>,adam smith ii <adam@gmail.com> Program I wrote: data DCAreaMembers; length FName $10 LName $20 email $40 ; infile 'v:\orion\mymembers.txt' dlm =...
  8. sap1958

    Infile and showing data in correct columns

    data news; length Company $20; infile 'v:\topNews.txt'; input rank Company $ City $ Circulation; run; present output example; 1. USA Today (Arlington, Va.) 2,528,437 2. Wall Street Journal (New York, N.Y.) 2,058,342 desired output example; rank Company City...
  9. sap1958

    Tables vs Frames for segmenting text and pictures

    I used a table to segment pictures and text on microsoft frontpage 2003. On a 15 inch screen the page looks fine. On a larger screen the table stretches and the pictures and text look different. My understanding is that frontpage does not allow you to create your own frames. Is there a way...
  10. sap1958

    Import Workbook with multiple worksheets

    Option Compare Database Function TransferMultiples() Dim strDir As String, strFile As String strDir = "C:\pcsas_export_files\Test\" strFile = Dir(strDir & "*.xls") While strFile <> "" DoCmd.TransferSpreadsheet acImport, 10, "invoiceg", strDir & strFile, True, "" strFile = Dir Wend End...
  11. sap1958

    Importing multiple files into SAS

    Here is my code to import one file. data many; infile 'v:\pcsas_export_files\many\file_1.txt'; input Code $2. / Acct $9. / AcctName $30. // ID $3. / Reg $10. / City $15.//; run; In the pcsas_export_files\many I have several text files (ie file_1, file_2...
  12. sap1958

    Only one record is reading from text file

    I have a text file that has the following data C 991699740 SOUTHWEST Data Example 088 9557427387 ROANOKE A 546651740 NORTHWEST Data Example 065 6557427387 RICHMOND Here is the code I use in SAS data multi1; infile...
  13. sap1958

    VBA Module Program will not work

    I have the following program in a module. It is designed to pull excel data from a folder named Test into access. I click the F8 button to analyze it line by line. The yellow line advances line by line but nothing happens. I get not error message but the program is not running either Option...
  14. sap1958

    Reading dataline items and eliminating items to create dataset

    I am trying to use an absolute positioning to create a dataset. My problem is I want to eliminate the (#) Notice #5 and #6 entries. I chose absolute positioning because when I establish a length for the Drug and Company, the program did not produce desired results. Here is the code: data...
  15. sap1958

    Looping Problem with Macro in SAS

    I am using a macro to combine 3 different datasets in SAS (MyList1,MyList2,MyList3). /*Here is the Macro*/ option mprint symbolgen; %macro MyList; data MyListFinal; %let Status = '1'; if Status = &Status then set %do i=1 %to 3; MyList&i %end; ; run; %mend; %MyList; The output is...
  16. sap1958

    Concatenate numbers and maintain the zeroes

    I concatenated the following: 0149 0783 02 using =concatenate(A1,A2,A3) I get the following number 1497832 All zeroes are removed. I need the zeroes even if it means converting to a text field. I need 0149078302. Concatenations of numbers removed the zeroes. How can I resolve this? I...
  17. sap1958

    Importing txt file to access with column (vertical data)

    Im looking for a function or sub routine to import a column oriented text file into MS Access. Here is some sample data I want to import: c 12334 Albany d 11245 Central New York The fields are to be Category ID Region City In some cases there may be some blanks between the columnar data in...
  18. sap1958

    Server Error in '/' Application The resource cannot be found

    Server Error in '/' Application The resource cannot be found This is the message I get when attempting to access a secure page with a php extension. I cannot seem to get a good workaround. Any ideas.
  19. sap1958

    Skip over data in reading raw data

    1 Johnson & Johnson United States 63,747.0[20] 12,949.0 118,700 2 Pfizer United States 48,296.0[21] 8,104.0 81,800 The above sample is actually the raw data file not the output. My mistake in my last email for telling you that. When I bring in the data to SAS I want to not bring in the [20]...
  20. sap1958

    Function and/or Macro to transfer multiple excel to access2007

    worked like a charm. One more question. Lets say we use this same function and the spreadsheets are set up as follows row a1 has blank space a2 Production Reporting a3 ID NAME ProdID a4 has a blank space a5 122 John 123a and so on..... essentially I need to delete rows a1, a2 and a4 and...

Part and Inventory Search

Back
Top