Glad to have you all back for Week 4! Rachel will lead tomorrow’s session with a focus on Lesson 4: Preparing Data. We’ll get practice with the DATA step and learn how to use it wisely for our data processing. To best prepare for class, please review the following from Programming 1: Essentials:      Lesson 3 | all | practices, activities  Lesson 4 | all | e-learning   Please post any questions that come up as you're going through the content. See you all tomorrow!  ... View more

Ever wanted to know which SAS Viya tool is the best to use for your particular predictive analytics problem? Join Jackie tomorrow to compare use of SAS Visual Analytics, SAS Model Studio, SAS Studio programming, and SAS Studio tasks in fitting different machine learning models. Come learn the advantages of different SAS Viya tools in performing machine learning analyses! ... View more

Welcome back to class today! To ensure you’re ready for this week’s discussion, please complete the following from Programming 1: Essentials:    Lesson 1.3 | practices, activities  Lesson 2 | practices, activities  Lesson 3 | e-learning (lectures only, no practices/activities)  We're happy to answer any question you might have as you're going through the content. See you all in class!  ... View more

Hi @sasser27, there's a few ways to proceed here. You could provide a sample customers dataset (just a few observations) for us to test your macro or you could test out the SQL query by itself to see if the result is as expected before encapsulating it in a macro.    I've tested out the macro with a simple customers table that I created:   data customers; input userid; format userid z3.; datalines; 001 002 003 ; run; and the macro worked and &salescount returned the number 3 in the log, as expected.    80 %put &salescount; 3 Global system options MPRINT and SYMBOLGEN are also useful when working with macros to be able to trace what a macro is doing:    options mprint symbolgen; ... View more

Hahaha, ok that makes more sense. In that case, you just want to add an IF statement after your merge, specifying the condition:   if variable=0 and variable_=1 then new_var=1; ... View more

Unfortunately your example output dataset (DB2) does not follow this requirement. Would you mind running through this requirement for IDs 166 and 170 to confirm. I'm getting different answers. ... View more

I think it would be clearer if we used a new variable name, say New_Var. Is your requirement as follows:    Update DB by adding new variable New_Var New_Var should be set to 1 if Variable_=1 in DB1 for the same ID, admission and discharge date?   ... View more

Hi @NewUsrStat, it isn't immediately clear what your desired outcome should be. From your initial description, of wanting to compare values in different datasets, it seems like you're trying to do a merge by ID, admission and discharge date. So far so good, you can achieve that with a DATA step merge (of course, making sure data is pre-sorted):   data want; merge db db1; by id admission discharge; format admission discharge date9.; run;     However, you also mention that the output dataset should contain a new variable (which you don't provide an example for). In your last dataset DB2, you have examples that don't quite align with your previous observations in DB and DB1. For example, how did we get this observation in DB2?   166 16FEB2019 26FEB2019 1 0   This observation doesn't meet the requirement specified: only the case in which  Variable_ =1 and  Variable =0. ... View more

Tom will lead today’s session on Data Wrangling and Descriptive Statistics. We’ll learn how to utilize SAS Studio Tasks to create graphics, produce summary statistics, and perform statistical analysis – all with no programming required!  ... View more

In SAS Data Explorer, you would search and find the dataset, load it into memory and from the top right corner, select Action -> Explore and Visualize. This will add the dataset to a Visual Analytics report which you can then use to explore the data and look at summary statistics.      ... View more

In VFL, you might need admin access to get full functionality from Information Catalog. Have you tried searching for it in SAS Data Explorer (Manage Data from the Applications menu)? ... View more

Hi @NS11 are you using SAS Information Catalog in Viya for Learners? I was able to search and find an ACME Bank dataset.   ... View more