Recent content by JM3482

I run the same SAS tables every day to process daily reports. This morning I am receiving an error that I have never seen before: ERROR: Read Access Violation in Task (EXPORT) Exception occurred at (1B00593E) Task Traceback. Can anyone tell me why I received this and how to fix it? I...

Thanks so much for the information. Yes I would assume it was as SQL database. It is housed in California on a server. In answer to your question about the most recent update, I am looking for the most recent address for the 01 member, but we need to make sure that I pull the most recent...

I am trying to code to pull the most updated address for our members in a member address table, which consist of over 2 million records. Each member will have multiple records in this table. I need the most updated address. The fields available are of course street, city, state, zip but there...

Thanks, I think I will try the update statement. Sounds interesting.

I take data from SAS to an excel spreadsheet. The data goes to the excel spreadsheet with single quotes. I need to remove the single quotes but I am missing something in my dequote statement. I get an error message that states "not enough arguments". My statement appears as...

I need to add date criteria to a where clause and I am having no luck. Below is what I have created so far. DATA FILE; FORMAT DTE mmddyy8.; DTE=TODAY(); Date1= put(Today()-4, date9.); Date2= put(Today()-7, date9.); RUN; DATA _NULL_; SET FILE; CALL SYMPUT('Newdate'...

thanks, I will give that a try also.

Thanks I will try this.

I need to take three tables that I am creating in a SAS program and append them to one table. I am creating three separate tables from one main table. How do I put the three tables together?

Thanks, that is a bunch of code. I will see what I can do with it.

This sounds very interesting. Please do supply me with code. I will try it. Possibly this will work for my new problem. I have now had to create a template and place the data from my SAS table on this template. That works, but they want me to replace the excel spreadsheet each time I run...

Thanks. I have tried it both ways and I can't get it to replace the file. I will try again.

What am i missing in the following statement if I am trying to export a SAS table in excel format and then replace it the next time the program is run. It keeps stopping the replace process. PROC EXPORT DATA=OPR9100.discharged OUTFILE="C:\Data\OPR9100\Discharged Stage Pended...

I need to take a table that I have created in SAS and have it automatically output in excel format. I have already tried this with the ods html file = filename..... and changing it to an .xls file extension, but I need more than just the "Results Viewer". I need for the file to...

I need a formula that pulls duplicate records based on a patient number field that I use in a table. Below is what I currently pull in Access but need to have it converted over to crystal. In (SELECT [PATIENT_NO] FROM [find duplicates STD STD LOC] As Tmp GROUP BY [PATIENT_NO],[Admit Date]...