If you go to lexjansen.com index of user group papers, there are lots of papers about mapping by zipcode: https://www.lexjansen.com/search/searchresults.php?q=map+zipcode   This isn't something I do, so can't recommend a specific approach. ... View more

Well if one computer works and the other doesn't then there must be a difference in settings or software causing it. You could try backing out the change to see if it fixes the problem. When was it last working OK? ... View more

@Kaushansky wrote: Not exactly. The SQL is good to compare when the columns of dates are aligned, but....The dataset by design, has one set of dates (columns) in a separate column from another and does not align by row. Is there a way, perhaps using the LAG() function or a new function HASH() to store column (trans_event_dt) and (display_imps_event_dt) then compare the ensure that column (display_imps_event_dt) occurs 30-days prior to (trans_event_dt).     You can brute force it with a temporary array that uses the DATE as the index. Just make the array large enough for the range of dates you expect (or pre calculate the range you have). data have; input id :$12. trans :yymmdd. imps :yymmdd.; format trans imps yymmdd10.; cards; 1019715261 2023-01-20 . 1019715261 2023-01-24 . 1019715261 2023-02-03 . 1019715261 2023-03-01 . 1019715261 2023-03-25 . 1019715261 2023-03-25 . 1019715261 2023-03-25 . 1019715261 2023-03-25 . 1019715261 2023-03-29 . 1019715261 . 2022-04-04 1019715261 . 2022-08-13 1019715261 . 2022-09-01 1019715261 . 2022-09-27 1019715261 . 2022-09-27 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-02-13 1019715261 . 2023-03-03 1019715261 . 2023-03-11 1019715261 . 2023-03-11 1019715261 . 2023-03-11 1019715261 . 2023-03-11 1019715261 . 2023-03-11 1019715261 . 2023-03-13 1019715261 . 2023-03-17 1019715261 . 2023-03-17 1019715261 . 2023-03-18 1019715261 . 2023-03-18 1019715261 . 2023-03-18 1019715261 . 2023-03-18 1019715261 . 2023-03-18 1019715261 . 2023-03-18 1019715261 . 2023-03-21 1019715261 . 2023-03-25 1019715261 . 2023-03-25 1019715261 . 2023-03-25 1019715261 . 2023-03-25 1019715261 . 2023-03-25 1019715261 . . 1019715261 . . ; %let minday=%sysfunc(mdy(1,1,2022)); %let maxday=%sysfunc(mdy(12,31,2023)); data want; array tranday [&minday:&maxday] _temporary_; array impday [&minday:&maxday] _temporary_; call missing(of tranday[*] impday[*]); do until(last.id); set have ; by id; min_trans=min(min_trans,trans); max_trans=max(max_trans,trans); if trans then tranday[trans]+1; if imps then impday[imps]+1; end; do date=min_trans to max_trans ; n_trans=tranday[date]; n_imps=0; n_impdays=0; if n_trans then do date2=date-30 to date; n_imps + impday[date2]; n_impdays + (impday[date2]>0); end; if n_trans then output; end; format date yymmdd10.; keep id date n_: ; run; Result Obs id date n_trans n_imps n_impdays 1 1019715261 2023-01-20 1 0 0 2 1019715261 2023-01-24 1 0 0 3 1019715261 2023-02-03 1 0 0 4 1019715261 2023-03-01 1 15 1 5 1019715261 2023-03-25 4 21 7 6 1019715261 2023-03-29 1 21 7 ... View more

@Kaushansky wrote: Thank you that works. Now what is I only wanted to count if a value is unique ONCE. Meaning, instead of how many unique, I only want to count 1 across all unique value.  Would prev(var1)=var1 work? So you no longer want to COUNT?  Instead you just want to FLAG the first occurrence of a value?   Just change how to assign values to the new variables.   Let's make some test data with more distinct values of the variables and try it. data have ; input luid :$10. var1 :$10. var2 :$8. var3 :$8. ; cards; 1027774874 6261781089 3g6gzrq 1744739 1027774874 6261781089 3g6gzrq 8888888 1027774874 6261781089 56vcsen 9999999 1027774874 9999999999 56vcsen 1744739 1027774874 6261781089 b9rq6w4 1744739 ; data want; set have ; array orig [3] $20 var1 var2 var3; array new [3] n_var1 n_var2 n_var3; retain n_var1 0 n_var2 0 n_var3 0; length value $20; if _n_=1 then do; declare hash h(); h.definekey('index','value'); h.definedata('index'); h.definedone(); end; do index=1 to dim(orig); value=orig[index]; if h.add() then new[index]=0; else new[index]=1; end; drop index value; run; Results Obs luid var1 var2 var3 n_var1 n_var2 n_var3 1 1027774874 6261781089 3g6gzrq 1744739 1 1 1 2 1027774874 6261781089 3g6gzrq 8888888 0 0 1 3 1027774874 6261781089 56vcsen 9999999 0 1 1 4 1027774874 9999999999 56vcsen 1744739 1 0 0 5 1027774874 6261781089 b9rq6w4 1744739 0 1 0 ... View more

Hello,   Have you started from here? Creating Synthetic Data with SAS/OR By Jared Erickson on Operations Research with SAS May 17, 2017 https://blogs.sas.com/content/operations/2017/05/17/creating-synthetic-data-sasor/   There's a difference between synthetic data (starting from an original set of data and producing a synthetic twin) and simulation of data (starting from statistical properties and uni- + multivariate statistics and creating data from scratch that obey these properties and statistics).   For both of these exercises, SAS/OR (SAS Optimization) might not be the best option. Synthetic data are best made with generative adversarial network (GAN) or transformer architecture. Simulated data are best made with data steps and / or IML (matrix language) code. Koen ... View more

Did you add any login details to your DSN like this?     ... View more

If you upgrade to SAS 9.4M8 you will have full support up to Jan 2028. I suggest you talk to your SAS account manager regarding Viya options. Viya architecture is very different so you can expect to have to do a lot of conversion. For example, Viya 4 only runs on linux inside containerised processes so there is no equivalent to desktop SAS 9.4. ... View more

It looks like you are trying to read a file from Microsoft Teams (Microsoft 365). There are special steps to accomplish this using the Microsoft Graph API -- it's a bit involved to set it up.   How to use SAS to access Microsoft 365    Basically, SAS cannot use your link to authenticate and get the file. You have to authenticate your SAS session and use an access token.  ... View more

You have parentheses where you should instead use curly braces.  Here is correct syntax: con Mycon9: sum {i in OBS: Campaign_Line_Item[i] in {'Walmart DSP|Display|Cross Device|Standard Audience|In Market Christmas|47490|7974163' ,'Walmart DSP|Display|Cross Device|Custom Audience|Heavy Spenders Home Decor|47490|8003807' ,'Walmart DSP|Display|Cross Device|Propensity Audience|Holiday Decor|47490|8005360' ,'Walmart DSP|Display|Cross Device|Propensity Audience|Ornaments|47490|7974160' ,'Walmart DSP|Display|Cross Device|Custom Audience|Nov&DecShoppers|47490|7974178' ,'Walmart|Display|Cross Device|Contextual Targeting|Holiday Decor|CY23|47490|7974064'}} Optimized_Budget[i] <= 140000; I recommend instead defining the set separately to make the code easier for human consumption: set CAMPAIGNS = {'Walmart DSP|Display|Cross Device|Standard Audience|In Market Christmas|47490|7974163' ,'Walmart DSP|Display|Cross Device|Custom Audience|Heavy Spenders Home Decor|47490|8003807' ,'Walmart DSP|Display|Cross Device|Propensity Audience|Holiday Decor|47490|8005360' ,'Walmart DSP|Display|Cross Device|Propensity Audience|Ornaments|47490|7974160' ,'Walmart DSP|Display|Cross Device|Custom Audience|Nov&DecShoppers|47490|7974178' ,'Walmart|Display|Cross Device|Contextual Targeting|Holiday Decor|CY23|47490|7974064'}; con Mycon9: sum {i in OBS: Campaign_Line_Item[i] in CAMPAIGNS} Optimized_Budget[i] <= 140000;   ... View more

Bayesian Analysis Using the GENMOD Procedure https://support.sas.com/rnd/app/Bayesian/GENMOD.html SAS/STAT User's Guide The GENMOD Procedure https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/statug/statug_genmod_details57.htm PhUSE 2013 Paper SP02 Bayesian statistics: concept and Bayesian capabilities in SAS Mark Janssens, I-BioStat, Hasselt University, Belgium https://www.lexjansen.com/phuse/2013/sp/SP02.pdf https://www.lexjansen.com/phuse/2013/sp/SP02_ppt.pdf Koen   ... View more