SAS Support Communities

I am looking at a data set of Emergency Room visits. I only want to keep visits per ID that are 30 days apart. So as an example say I have this below. If I start with ID=1. In  Row 1 I can see that the lag between row 1 and 2 is 15 days so I will exclude, or for now flag, row 2. Then I will continue to use Row 1 to evaluate Row 3. Again this is only 17 days so I will exclude Row 3 and look at Row 4. Row 4 is 30 days away so I keep it and then use Row 4 to evaluate Row 5....and so on. I have been trying to do this with the lag function but I can't figure out how to utilize the lag when I have to continue to use the 'anchor' row to evaluate several rows. Top is what I have and bottom is what I want. Any ideas??? If anyone knows how to do this using Proc SQL that would be even better. Much appreciated.   HAVE     Row # ID   1 1 1/1/2020 2 1 1/15/2020 3 1 1/17/2020 4 1 2/4/2020 5 1 3/15/2020 6 2 1/15/2020 7 2 3/15/2020 8 2 3/18/2020 WANT     Row # ID   1 1 1/1/2020 4 1 2/4/2020 5 1 3/15/2020 6 2 1/15/2020 7 2 3/15/2020 ... View more

I have two different format catalogs which I need to use depending on how the client needs the output displayed.   %let fmt1=formats1 ; %let fmt2=formats2 ; libname fmts  "\\path\formats" ;   options fmtsearch=(fmts.formats2 fmts.formats2 work library) ;   Each catalog has about 100 different formats, some of them the same and some different.   proc print data =mydata ; var var1-var3 ; run ;   So I want the data file to look into formats2 to apply the formats. Formats1 was created first and I have applied these formats to 'mydata' in a previous program. Now I want SAS to apply formats2 instead of formats1. I did what SAS said and put the order into the fmtsearch option, but I still get results showing the formats1 formats. What am I doing wrong? I'm running this in Batch.   Thanks!   Lorena       ... View more

I have a macro do loop I am running and I want the flag to be applied as soon as the condition is met. Right now it is only applying it to the last variable in the loop. Diag1-Diag24 are diagnosis codes that I am looking through to find the value of the code I need to flag.   %let dxnum=24; %macro test(s); %do s=1 %to &dxnum. ; if  ("T36" <=substr(diag&s.,1,3)<="T50") then flag=1 ; %end; %mend test; %test   This works but it only picks up the values in diag24. I feel like I need to do a do until or a 'leave' but I've tried a dozen different ways with no luck. I need flag=1 whenever it meets that condition in any of the variables diag1-diag24. Once it flags it once it can leave the loop.   Any ideas???         ... View more

I know this question is asked a lot and I've read as much as I could to see if I can figure this out on my own. Here are my issues.   1. I don't have access to 32 bit SAS 2. I inherited the catalogs and I cannot go back and ask them for the code that creates the catalogs.   So I am stuck with trying to convert them. I tried using the cport method but I still get that error that says 'ERROR the catalog was created for a different operating system.' I am wondering if anyone has any ideas on how to get this done??!! This is causing me such a big headache!   Thanks! ... View more

I know this is an issue that comes up over and over and I've been reading posts about it all day trying to figure this out. I inherited a program that used to use an SQL pass through method to load data. This is no longer available to me and so now we are connecting to the SQL server more directly but it is causing a problem with the truncation of the column names. There are many tables and many variables and sometimes there will be several variables that all exceed 32 characters but that have the same 32 characters to begin with.   example: var1=abcdefghijklmnopqrstuvwxyzaaaaaabb var2=abcdefghijklmnopqrstuvwxyzaaaaaacc var3=abcdefghijklmnopqrstuvwxyzaaaaaadd   So what happens right now is that var1 gets truncated to abcdefghijklmnopqrstuvwxyzaaaaaa and var2 and var3 are dropped. What I want: var1=abcdefghijklmnopqrstuvwxyzaaaaa1 var2=abcdefghijklmnopqrstuvwxyzaaaaa2 var3=abcdefghijklmnopqrstuvwxyzaaaaa3   My simplified code looks something like this: Libname test odbc dsn=dataset schema=xx preserve_col_names=yes; Proc sql ; Create table xxx select x.* from yyy; quit;   Does anyone know of any option that tells SAS to go ahead and truncate but add numeric suffixes to variables with the same first 32 characters??   THANK YOU!! ... View more