About Marilyn

Marilyn · ‎04-23-2014

I have the following fields and want a report at the end with a lot of counts and sums: station, ssn, invoice number, line items, amounts. I want a report with individual stations and count of unique ssn, count of unique invoice numbers, count of line items and total dollar amounts. How can I do this???

Marilyn · ‎04-23-2014

What would be the easiest way to do it if you have more fields? I have station, ssn, invoice number, line number and amount I want to end up with each unique station number with a count of ssn's, a count of their invoices, a count of line items, and a total cost? I'm not having much luck with it

Marilyn · ‎07-16-2013

I just use these on the mainframe. It seems they aren't required as much with PC SAS, etc and I try to stay away from the mainframe when I can

Marilyn · ‎06-08-2012

I am using a pass thru SQL query. The one file has 5 different identifying fields for individual, spouse, children, etc. The payment file I am trying to match to has only the one identifying field but it can match to any of the 5 identifying fields in the other table. I don't have the luxury of trying to get any of the data tables changed. The payment file has at least 20 million records and the other file has about 500k records...

Marilyn · ‎11-15-2011

Does anyone have a good idea on how to match an identifying field from one table to another table where the number may match any of 3 - 5 different identifying fields? I tried using Proc SQL with several OR filters, but it is running forever. I am already having to filter on a location field and date field as well and the table is very large They may also have multiple payments from that second table

Marilyn · ‎12-17-2009

Why does SAS pull in a numeric or general formatted column as character when it is formatted as something else in Excel? I am just using the general proc import: PROC IMPORT OUT= WORK.EMPLIST DATAFILE= "S:\emplist.xls" DBMS=EXCEL REPLACE; RANGE="EMP$"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN;

Marilyn · ‎11-19-2009

I used this code to connect to an outside SQL server and it seems to have worked: libname odbclib odbc noprompt="Driver={SQL Server}; 369 Server=10.100.100.100 ; 370 Database=XXXwork; 371 Uid=; 372 Pwd=;" 373 ; NOTE: Libref ODBCLIB was successfully assigned as follows: Engine: ODBC Physical Name: Can someone tell me how to get table and column names from the server now?

Marilyn · ‎05-14-2009

Thanks I am trying to make the code as efficient as possible too, which is why I thought it might be better to loop through the years and accumulate everything at the end. I am hoping that I can create a model that we can use repetitvely as well.

Marilyn · ‎05-13-2009

Can someone help me build a complex query? I want to go thru all inpatient(ABC files) and outpatient (DEF files) files that we have. They are stored with same name and then FYNN. I need 10 years worth. So I need it to go thrru each inpatient file by year and see if the ssn matches one in a file of 200k numbers. If it matches, then I want it to look thru a group of 10 diagnoses and exclude any records with dx 345, 346, or 347. I want to end up with all the records that match the ssn's I was looking for that do NOt have the excluded diagnoses. So how to do the looping for the years and possibly an array of the diagnoses...?

Marilyn · ‎04-28-2009

2. Use as much criteria as possible in the selection of rows. Every addition to the where clause will shrink the resultant rows. 3. Use correlated queries to combine mulitple years. I am trying to make my code as efficient as possible since I deal with huge datasets, but I'm new and don't really know what works best.

Marilyn · ‎04-16-2009

yes...this works quite well. Now I am working on trying to make an array of the diagnosis codes...

Marilyn · ‎04-16-2009

There's just generic information like name, ssn, diag1 - diag10, DOV, etc...

Marilyn · ‎04-15-2009

ok...at what point in the procedure do I do this? proc sql; CREATE TABLE x.out04 AS SELECT B.kssn FORMAT=$9. AS kSSN, A.ISSN FORMAT=$9., A.DIAG1 FORMAT=$7. FROM N.YR2004 AS A , x.ketssn AS B where B.kssn = A.ISSN; QUIT;

Marilyn · ‎04-15-2009

Does someone already have some generic code that will pull patients with several ranges of diagnoses from a file that records up to 10 diagnoses at a time? i.e. I want to pull any patient that had dx 345.00-345.99, or 346.0-346.9, or 296.0-296.9 from multiple years...

Marilyn · ‎04-15-2009

How can I get this where statement in proc sql to work when one ssn is a char and the other is numberic? where B.pat_ssn = A.SSN;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Getting lots of totals/statistics at once

Re: sums and counts by group

Re: RECFM LRECL

Re: Matching payments to people

Matching payments to people

import from Excel

Connect to remote SQL server

Re: complex query

complex query

Can anyone confirm these statements?