If you do not specify the fourth argument 'same' or 's' in intnx('month',Date,-1,'same'), the date will always be the first day of the month requested.  As you indicated, you can type 'e' for end, 'm' for middle, 's' for same, or 'b' for begin which is the default.   ... View more

Hi.   Trying to draft an example per your notes.  Please try the following and if this is not what you are looking for, shed more light on your goal.  Thanks.   Data Test; Date='20NOV2022'd; Day=day(date); DateNext=intnx('month',Date,-1,'same')+ Day-1; format date datenext date9.; run; proc print data=test; title "Values for Date, Day and DateNext"; run; ... View more

Hi.  I am not sure if this is what you are looking for, but consider the following: /* Create sample table*/ Data Example; infile datalines dlm=','; Input Cat1:$1. Cat2 :$1. AdmDt :mmddyy10.; format admdt mmddyy10.; datalines; A,1,01/01/2022 A,1,01/02/2022 A,1,01/03/2022 A,1,01/10/2022 A,1,01/11/2022 A,1,01/12/2022 A,2,01/01/2022 A,2,01/02/2022 A,2,01/07/2022 ; run; /*Sort table*/ proc sort data=example; by Cat1 Cat2 AdmDt; /* Use first., last. and lag to check values and assign a value to SubCat*/ Data Categorize; set example; by Cat1 Cat2 AdmDt; Retain SubCat 0; if first.cat2 then SubCat+1; If not first.cat2 and admDt >sum(lag(Admdt)+1) then SubCat+1; run; ... View more

Hi. Are you trying to download the autocall macros (which are SAS programs)?  If yes, have you considered the following: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/connref/n0da63bm99moq3n1ht2dmxliwydb.htm ... View more

.   After the SET statement, define the length of ARI_Guest_Group_Category  to hold the longest value.  For example: Length ARI_Guest_Group_Category  $  7; ... View more

Can you show sample records of what you have and what you want? ... View more

Hi. I just realized my answer is similar to Jose's excellent response. Best. ... View more

Hi.   Try the following.   Please let me know if this works for you. Thanks, John McCall (SAS Instructor)   /* Create a sample table*/ Data Example_Table; Input Date; datalines; 8062023 12052023 26052023 26052023 6022020 10042023 3102017 ; run; /* Change numbers to SAS dates*/ Data Convert_to_SASDate; set example_table(rename=(date=Original_Date)); Date=Input(put(original_Date,10.),ddmmyy10.); format date mmddyy10.; run; proc print data=Convert_to_SASDate; title "Does this conversion work for you?"; run;       Does this conversion work for you?   Obs Original_Date Date 1 8062023 06/08/2023 2 12052023 05/12/2023 3 26052023 05/26/2023 4 26052023 05/26/2023 5 6022020 02/06/2020 6 10042023 04/10/2023 7 3102017 10/03/2017 ... View more

Consider this example using INTNX.   Data Original; infile datalines ; Input ID :4. Date :date9.; format date date9.; datalines; 1001 22FEB2021 8997 05APR2021 5654 30SEP2022 3000 07MAR2022 1002 31OCT2021 7984 28FEB2021 ; run; Data Weeks; Retain Date1 0; set original ; if _n_=1 then Date1='21FEB2021'd; /* Use INTNX to count weeks between 21FEB2021 and dates in the table*/ Weeks=intck('week', date1,Date, 'continuous'); format date1 date9.; run; ... View more

If you are referring to the SAS Windowing environment (Display Manager), you can build SAS programs in either interface.   One of the key differences is that SAS Studio also offers point and click tasks (with prewritten code) for data manipulation, analysis and reporting.   My preference is to use Studio for  development of SAS programs but some folks use what they are more comfortable with in SAS.  ... View more

You can also run the following to see the tables referenced in the view. Proc SQL feedback; select * from sasuser.all; quit; ... View more

Here are the options: SORTSIZE=n | nK | nM | nG | nT | hexX | MIN | MAX Note: You can also use the KB, MB, GB, and TB syntax notations. Specifies the amount of memory that is available to the SORT procedure. There is also sortcutp SORTCUTP=n | nK | nM | nG | MIN | MAX | hexX Note: You can also use the KB, MB, and GB syntax notation. Specifies the size of the data in bytes above which the host sort is likely to perform more efficiently than the internal sort. SORTCUTP is used only when SORTCUT=0. ... View more

Hi.   Consider trying Bufsize= and Bufno = options for the output table.  Plese see online documentation: https://go.documentation.sas.com/doc/en/vdmmlcdc/8.1/lesysoptsref/p1d8hx95jb53wqn0zzvawxw94nvi.htm ... View more