About stew90210

stew90210 · ‎02-14-2023

Hi all, I have spent a good couple of days on google trying to work this one out, to no avail, so your insight is greatly appreciated. I am currently the business SME for an on prem SAS9.4 to cloud based VIYA migration and am trying to make sure we get the most out of the new platform. I was excited to learn about snippets for the 50+ users I represent I thought it would be a great idea to have a common snippet library where tasks that relate specifically to our data could be placed... as far as I can tell the concept of common snippet libraries is now obsolete: https://documentation.sas.com/doc/en/webeditorcdc/v_027/webeditorag/n1qixwnypmqnwnn14ok1t4hgvxjd.htm but I cannot find a reason why or a suitable alternative. does anyone know if they are still possible and if so how you set up and use them? thanks in advance

stew90210 · ‎07-27-2022

Hi All, I was hoping you could help me out, we are currently looking at SAS VIYA and considering how we can make best use of it. One of the key features we want to use is model manager, I have watched hours of training and spent more searching for what I would have thought would have been a very simple procedure but it almost seems like it is either impossible or just "not done". I have several super simple models that are imbedded in larger pieces of code and used to give a probability percentage using a straightforward formula with imbedded correlation and slope numbers i.e. WantVar = -1.49746+(HaveVar1*(-0.021799)+(HaveVar2*(0.7232)) my question is this: how on earth do i take that simple formula and get it into SAS model manager so we can start tracking it

stew90210 · ‎07-21-2022

Ok well hopefully you have enough to get your started in my code! Come back if you get stuck

stew90210 · ‎07-21-2022

with regards to user ID 1; why is march 22 a 2 instead of a 0? if dec 21 is a 0 then shouldn't it follow that it is the same? if you are trying to show how long its been since the last time they watched TV then surely whenever they are actually watching TV it should be a 0 to say its been no months since the last instance?

stew90210 · ‎07-21-2022

sorry but that doesnt match what i get as an output and also your "coloumn I want" dosent make logical sense to me? in jan, feb and march of 22 user ID 1's results dont make any sense

stew90210 · ‎07-21-2022

stew90210 · ‎07-21-2022

data input; input USERID $1 Year Month Flag 4.; datalines; A 2021 12 0 A 2022 1 1 A 2022 2 1 A 2022 3 0 A 2022 4 0 A 2022 5 0 B 2021 8 0 B 2022 9 1 B 2022 10 1 B 2021 11 0 B 2021 12 0 B 2022 1 0 ; run; data step1; retain flag date_cat months_since_last_event; set input; by userID ; prev_flag =lag(flag); if first.userID then do; months_since_last_event = .; end; else if flag =0 and prev_flag =1 then do; months_since_last_event=1; end; else if flag =1 then do; months_since_last_event=0; end; else do; months_since_last_event+1; end; drop prev_flag; run; data input; input USERID $1 Year Month Flag 4.; datalines; A 2021 12 0 A 2022 1 1 A 2022 2 1 A 2022 3 0 A 2022 4 0 A 2022 5 0 B 2021 8 0 B 2022 9 1 B 2022 10 1 B 2021 11 0 B 2021 12 0 B 2022 1 0 ; run; data step1; retain flag date_cat months_since_last_event; set input; by userID ; prev_flag =lag(flag); if first.userID then do; months_since_last_event = .; end; else if flag =0 and prev_flag =1 then do; months_since_last_event=1; end; else if flag =1 then do; months_since_last_event=0; end; else do; months_since_last_event+1; end; drop prev_flag; run;

stew90210 · ‎07-21-2022

I have the code you want but every time I post it, it gets marked as SPAM for some reason!

stew90210 · ‎07-21-2022

hey! the syntax for proc SQL is not identical to SQL so you need to spend a little time looking into it and correct your syntax, as you can see from the examples below they are not the same and this would not run in MYSQL: proc sql; SELECT state, sum(sales) as TOTSALES FROM ussales WHERE state in (’WI’,’MI’,’IL’) GROUP BY state HAVING sum(sales) > 40000 ORDER BY state desc; quit;

stew90210 · ‎07-21-2022

hey buddy, not the tidiest code but I think this does what you want: data input; input USERID $1 Year Month Flag 4.; datalines; A 2021 12 0 A 2022 1 1 A 2022 2 1 A 2022 3 0 A 2022 4 0 A 2022 5 0 B 2021 8 0 B 2022 9 1 B 2022 10 1 B 2021 11 0 B 2021 12 0 B 2022 1 0 ; run; data step1; retain flag date_cat months_since_last_event; set input; by userID ; prev_flag =lag(flag); if first.userID then do; months_since_last_event = .; end; else if flag =0 and prev_flag =1 then do; months_since_last_event=1; end; else if flag =1 then do; months_since_last_event=0; end; else do; months_since_last_event+1; end; drop prev_flag; run;

stew90210 · ‎07-21-2022

Hi all, this might be a really stupid question but I am currently getting to grips with SAS VIYA with a view to move our company over later in the year from EG and as far as I know I have searched all relevant documentation without a satisfactory answer (probably missed it). After you define a Target variable in model studio and then run a pipeline should you be able to change the target variable? as I cant, and one of my modules failed as I selected the wrong target. I would prefer to change the target variable rather than start a fresh but either way would like to know if its possible so I can share that knowledge with my colleagues. many thanks in advance Stewart Jardine

Online Status	Offline
Date Last Visited	‎02-16-2023 07:59 AM

SAS common Snippet Libraries

convert a very basic linear regression model into a package for model ...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: PROC SQL errors although same code works fine in SQL Server Manage...

Re: How can I create a column that returns the number of months that h...

Re: convert a very basic linear regression model into a package for mo...

Re: PROC SQL errors although same code works fine in SQL Server Manage...

Re: proc Sql generating tables in a new WC000001 library/schema

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

SAS common Snippet Libraries

convert a very basic linear regression model into a package for model ...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: How can I create a column that returns the number of months that h...

Re: PROC SQL errors although same code works fine in SQL Server Manage...

Re: How can I create a column that returns the number of months that h...

SAS Model Studio - Locked Target Variable