About john_mccall

john_mccall · ‎05-14-2025

Do you use programs containing ampersands and percent signs? If so, you are using SAS macros. The macro facility allows you to perform text substitution using macro variables and macro programs. Macros make life easier for the programmer by automating and customizing the generation of SAS code. In this SAS tutorial, John will demonstrate a basic understanding of the macro facility by starting with a review of the %LET statement, CALL SYMPUTX routine, INTO clause, macro conditional and iterative processing statements and macro program syntax. He will also discuss double periods, multiple ampersands, macro quoting and the macro IN operator. He’ll wrap up with examples of I/O functions, dictionary tables, the DOSUBL function and branching within a macro program. Note: First shared online during the virtual SAS Global Forum 2020 conference, this tutorial is extremely popular among those who need to learn or refresh their SAS macro skills!

john_mccall · ‎07-20-2023

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.

john_mccall · ‎07-20-2023

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;

john_mccall · ‎07-18-2023

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;

john_mccall · ‎07-16-2023

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

john_mccall · ‎07-16-2023

Hi. Consider this sample program. /* Create a sample table that is ordered By descending X*/ Data Sample; infile datalines; input X ; datalines; 99 90 83 83 72 71 71 65 52 43 31 20 20 19 18 ; run; /* Count 1 for a single BY value and for count 1 for duplicate BY values*/ data Top10; set sample; by descending x; If last.x then count+1; if count<=10 then do; Top10='Yes'; output; end; else do; Top10='No'; output; end; run; proc print data=top10; title "Counting duplicates as 1 in Tp 10 table"; run;

john_mccall · ‎07-11-2023

You can consider changing wihtthe data step following Proc iMport: proc import out=GSM datafile='V:\3613_DEPT_CONTROLE_DE_GESTION\Transverse\ANAPLAN\PALLIATIFS_DIRECT_PBI\commissions\GSM.csv' DBMS=csv replace; delimiter = ";"; run; Data GSM; set GSM(rename=(ComaxCode=CC)); ComaxCode=put(CC,z7.); drop cc; run;

john_mccall · ‎07-05-2023

. 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;

john_mccall · ‎07-05-2023

Can you show sample records of what you have and what you want?

john_mccall · ‎07-05-2023

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

john_mccall · ‎07-05-2023

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

john_mccall · ‎03-20-2023

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;

john_mccall · ‎03-20-2023

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.

john_mccall · ‎03-20-2023

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

john_mccall · ‎02-21-2023

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.

Online Status	Offline
Date Last Visited	‎05-14-2025 08:49 AM

SAS Tutorial: Beyond the Basics with SAS Macro

Re: INTNX CALCULATION

Re: INTNX CALCULATION

Re: categorize dates with gaps.

Re: Auto call macros deliverd with SAS

Re: Identifying top 10 scoring observations in a way that permits tied...

Re: PROC IMPORT CSV character value instead of numeric value

Re: SAS HELP! IF THEN STATEMENTS

Re: How to split a dataset into n number of tables based on variable n...

Re: How to turn numeric variable to date format

Ask the Expert: SAS Studio Flows and Steps

Re: categorize dates with gaps.

Re: Identifying top 10 scoring observations in a way that permits tied...

Re: How to read a sas7bvew file?

Re: Fast proc sort

Re: Importing xlsx datasets

SAS Tutorial: Beyond the Basics with SAS Macro

SAS Tutorial: Beyond the Basics with SAS Macro

Re: INTNX CALCULATION

Re: INTNX CALCULATION

Re: categorize dates with gaps.

Re: Auto call macros deliverd with SAS

Re: Identifying top 10 scoring observations in a way that permits tied...

Re: PROC IMPORT CSV character value instead of numeric value

Re: SAS HELP! IF THEN STATEMENTS

Re: How to split a dataset into n number of tables based on variable n...

Re: How to turn numeric variable to date format

Re: How to turn numeric variable to date format

Re: Week Assignment to Dates

Re: SAS studio vs base SAS

Re: How to read a sas7bvew file?

Re: Fast proc sort

SAS Analytics Explorers