What is in your dataset PD? Do you have any observations in PD where default=. or default=0 If there are no observations (#2) then adj will be empty 89 data adj(keep=region product sub_product); 90 set pd; 91 put ; 92 put "1 - " region= product= sub_product= nondefault= active= default= ; 93 nondefault=sum(active,-default); 94 put "2 - " region= product= sub_product= nondefault= active= default= ; 95 if default=. then default=0; 96 put "3 - " region= product= sub_product= nondefault= active= default= ; 97 if nondefault=. then nondefault=0; 98 put "4 - " region= product= sub_product= nondefault= active= default= ; 99 if default=0; 100 put "5 - " region= product= sub_product= nondefault= active= default= ; 101 run; 1 - region=RegionA product=Missing sub_product=SP1 nondefault=64 active=32 default=. 2 - region=RegionA product=Missing sub_product=SP1 nondefault=32 active=32 default=. 3 - region=RegionA product=Missing sub_product=SP1 nondefault=32 active=32 default=0 4 - region=RegionA product=Missing sub_product=SP1 nondefault=32 active=32 default=0 5 - region=RegionA product=Missing sub_product=SP1 nondefault=32 active=32 default=0 1 - region=RegionB product=Zero sub_product=SP1 nondefault=32 active=8 default=0 2 - region=RegionB product=Zero sub_product=SP1 nondefault=8 active=8 default=0 3 - region=RegionB product=Zero sub_product=SP1 nondefault=8 active=8 default=0 4 - region=RegionB product=Zero sub_product=SP1 nondefault=8 active=8 default=0 5 - region=RegionB product=Zero sub_product=SP1 nondefault=8 active=8 default=0 1 - region=RegionA product=Product1 sub_product=SP1 nondefault=8 active=4 default=2 2 - region=RegionA product=Product1 sub_product=SP1 nondefault=2 active=4 default=2 3 - region=RegionA product=Product1 sub_product=SP1 nondefault=2 active=4 default=2 4 - region=RegionA product=Product1 sub_product=SP1 nondefault=2 active=4 default=2   Above log generated from following code: data pd ; infile cards ; input region $ product $ sub_product $ nondefault active default ; cards ; RegionA Missing SP1 64 32 . RegionB Zero SP1 32 8 0 RegionA Product1 SP1 8 4 2 ; run ; data adj(keep=region product sub_product); set pd; put ; put "1 - " region= product= sub_product= nondefault= active= default= ; nondefault=sum(active,-default); put "2 - " region= product= sub_product= nondefault= active= default= ; if default=. then default=0; put "3 - " region= product= sub_product= nondefault= active= default= ; if nondefault=. then nondefault=0; put "4 - " region= product= sub_product= nondefault= active= default= ; if default=0; put "5 - " region= product= sub_product= nondefault= active= default= ; run;     ... View more

Assuming there is not a work.vg_sales_cookd, dataset then you are correct the PROC GLM will error   It has nothing to do with the data step that creates work.vg_sales_basic.   ... View more

How are the values keyed in manually? Look at any Web page these days, you need to enter a date, it forces you to use a specific format. This is the way to go, much easier to enforce the correct value at the time of entry than attempt to fix/catch it later.    There's a saying "Rubbish|Trash In = Rubbish|Trash out" ... View more

Here's the documentation links with good examples   PUT Function  Working with Dates in the SAS System   ... View more

Can you provide a simple example of what you have and what you want, as this doesn't make sense to me. Why would you want to create macro variables, when I assume you will have multiple observations in work.json_text file Are the macro variables just flags or counters (ie number of observations with empty date How are you defining empty date vs wrong date? As far as SAS is concerned when you create your DOB variable it's either a valid SAS data value or missing BTW When you create your DOB variable why are you using UPCASE and the informat YYMMDD10.? The informat suggests you will always have numeric symbols in the value returned from the prxposn function, so it doesn't make sense to use UPACASE on those prxposn(regex02, 2, json_text) Sorry just confused on what you are attempting to do, and guessing others will be to ... View more

I'm not sure your definition of DISTINCT is the same as my definition, based on your example   Here's the link to the documentation  Select Clause, DISTINCT Argument  ... View more

Here's a simple example: %let Global_1 = I am Global 1 ; %macro example ; %global global_2 ; %let local_1 = I am Local 1 ; %let global_2 = I am global 2 ; %put local_1 : &local_1 ; %put global_1 : &global_1 ; %put global_2 : &global_2 ; %mend ; %put Running Macro example ; %example ;   Which generates this log (not I have the option SYMBOLGEN turned on) 62 %let Global_1 = I am Global 1 ; 263 %macro example ; 264 %global global_2 ; 265 %let local_1 = I am Local 1 ; 266 %let global_2 = I am global 2 ; 267 %put local_1 : &local_1 ; 268 %put global_1 : &global_1 ; 269 %put global_2 : &global_2 ; 270 271 %mend ; 272 273 %put Running Macro example ; Running Macro example 274 %example ; SYMBOLGEN: Macro variable LOCAL_1 resolves to I am Local 1 local_1 : I am Local 1 SYMBOLGEN: Macro variable GLOBAL_1 resolves to I am Global 1 global_1 : I am Global 1 SYMBOLGEN: Macro variable GLOBAL_2 resolves to I am global 2 global_2 : I am global 2 275 276 %put Printing all macro variables ; Printing all macro variables 277 %put local_1 : &local_1 ; WARNING: Apparent symbolic reference LOCAL_1 not resolved. local_1 : &local_1 278 %put global_1 : &global_1 ; SYMBOLGEN: Macro variable GLOBAL_1 resolves to I am Global 1 global_1 : I am Global 1 279 %put global_2 : &global_2 ; SYMBOLGEN: Macro variable GLOBAL_2 resolves to I am global 2 global_2 : I am global 2 Notice how local_1 prints a value when the %put is inside the example macro, but fails to resolve where outside.   ... View more

Here's the documentation on Scopes of Macro Variables There are several unknowns in your questions, it's not as simple as a macro variable being created in init.sas   The short answer is a macro variable exists until you end the SAS session it was created in, assuming it was defined as global. If it was defined as local then it will only exist within the macro it was created in.     ... View more

You might also want to look at FIRST. and LAST. DATA Step Variables ... View more