I'm interested in know if I can invoke Proc Contents and input my dataset name and a short list of some of it's variable names (but not all) and have it return just the variable name and it's Type, Length, Format, and Informat?    Any suggestions would be much appreciated.  ... View more

Hi all. I've got a tough one here.  I have the following 3 columns of data.  Here's what I need to accomplish...   Whenever a person (PERS_ID) is assigned to a new provider (PROV_ID) I need to calculate how many days have pasted from the previous appointment date (APPT_DATE) for the previous provider to the current appointment date of the new provider.   For example, at record 2 the PROV_ID changes for PERS_ID 134841 from  1386065225 to 1235209446. So I need to calculate the days difference between 17-Aug-17 and 1-Aug-17.   For example, at record 6 the PROV_ID changes for PERS_ID 134841 from 1235209446  to 1144621806. So I need to calculate the days difference between 16-Oct-17 and 16-Nov-17. I need help accomplishing this if you know a solution?  Thanks so much. PERS_ID PROV_ID APPT_DATE Calc_days 134841 1386065225 1-Aug-17 134841 1235209446 17-Aug-17 16 134841 1235209446 17-Aug-17 134841 1235209446 16-Oct-17 134841 1235209446 16-Oct-17 134841 1144621806 16-Nov-17 31 134841 1144621806 16-Nov-17 134841 1144621806 15-Jan-18 134841 1144621806 15-Jan-18 134841 1235209446 30-May-18 ? 134841 1235209446 30-May-18 134841 1235209446 29-Jul-18 134841 1235209446 29-Jul-18 927789 1992766273 13-Aug-17 927789 1992766273 13-Aug-17 927789 1992766273 12-Oct-17 927789 1992766273 12-Oct-17 927789 1871889956 10-Nov-17 ? 927789 1871889956 10-Nov-17 927789 1447417639 29-Nov-17 ? 927789 1306858121 18-Jan-18 ? 927789 1306858121 19-Mar-18 927789 1306858121 18-May-18 1647935 1679803183 14-Sep-17 1647935 1679803183 14-Sep-17 1647935 1477695468 16-Mar-18 ? 1647935 1477695468 16-Mar-18 1647935 1295738037 21-Jun-18 ? 1647935 1114984275 27-Jul-18 ? 1647935 1114984275 27-Jul-18     ... View more

Hi.  I'm wondering what would be the best way to determine the number of days between two SAS date variables and return it as a number variable?   Any suggests would be very helpful.   ... View more

Hi all. I was passed along a program that contains the following data step. It recodes ALL missing numeric values to 0.    But I don't understand how it's doing it?  In particular I don't understand the keywords 'change', '_numeric_', and 'do over'.  Can anyone help me understand how this code works?  Any pointers would be most appreciated.   /* RECODE ALL NUMBERIC MISSING VALUES FROM . TO 0 */ DATA WANT; SET HAVE; ARRAY CHANGE _NUMERIC_; DO OVER CHANGE; IF CHANGE=. THEN CHANGE=0; END; RUN;   Also, do you feel this is a good way of doing this task or are there better alternatives?  ... View more

Would it be possible to reorder a list of comma separated values stored as a variable string?  The string could have any number of comma separated values or it could have just one value with no comma in some cases.   For example a character variable stored with the value of:   '12345, 54321, 23456, 65432'    Could it be reordered numerically (or alphabetically if it includes alphabetic characters) to appear as:   '12345, 23456, 54321, 65432'   Any suggestions would very helpful.  Thanks. ... View more

    Hi. I'm trying to figure out the importance/purpose of the Call Missing function being used in the code below. The code itself reshapes the data so that all unique From_Dt values appear in a comma delimited list. Any help would be greatly appreciated. data have; input BENE FROM_DT :date9.; format from_dt date9.; cards;12345 23OCT2010 12345 11NOV2015 12345 11NOV2015 12345 15DEC2011 12345 11NOV2015; data want; array t(999) $9 _temporary_; call missing(of t(*),n); do until(last.bene); set have; by bene; temp=put(from_dt,date9.); if temp not in t then do; n+1; t(n)=temp; end; end; want_list=catx(', ',of t(*)); keep bene want_list; run;   ... View more