Recent content by sap1958

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