Search results for query: *

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...

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.

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.

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

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...

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...

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 =...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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]...

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...