About Tommer

Tommer · ‎03-23-2023

Hi, Is it possible to get N=0 when there are zero observations in a dataset? Ex: data cls; set sashelp.class; age=0; if age ne 0; run; In the below, the output dataset is empty. Instead if I want to see N=0 indicating there are no records in a dataset, how can I do? proc means data=cls stackodsoutput; var age; output out=cl_m; run;

Tommer · ‎11-11-2022

For the sashelp.class, it did not seem to do the same thing---cl is populated as 1 not 2 although the second condition is true as well.

Tommer · ‎11-11-2022

Hello, I am working on a few else if conditions to understand how else if works on different variables: In the below example 'cl' doesn't get overwritten to 2 which means once the if condition is successful on a record it is not evaluating that record again. data cls; set sashelp.class; if sex="M" then cl=1; else if age=14 then cl=2; run; However, in the below example where I am working on same record and running else if on two different variables, it is getting overwritten. I don't understand why it is reading the same record again in else if (it did not in the above example). data chk; set cm1; if (trtsdtm <= aendtm) then cmfl= 'Y'; else if (trtsdt <= aendt) then cmfl= 'Y'; run;

Tommer · ‎05-26-2022

Hi, Here I want time 1.5 hours before date, but intnx is calculating 2 hours instead. What am I missing? data chkl; date="2021-02-01T09:30"; date2= intnx("hour",input(date,is8601dt.),-1.5,"s"); format date2 is8601dt.; run;

Tommer · ‎04-20-2022

Hi, New to macro programming - I am confused when to use macro functions as the code seems to work well without macro function when used with a macro variable. The code below as an example works without using %upcase as well. %let mod=mdx; data cars; set sashelp.cars; if strip(model)=upcase("&mod"); keep model ; run; Similarly, %let greet = Hello my name is Sam; %let hel= %scan(&greet,1, " "); ----> works %put &hel; data hello; greet = %scan("&greet",1, " "); --->but this doesn't. Rather it works with scan and not %scan run;

Tommer · ‎04-12-2022

This worked!! I used proc append. I think I need to work on my macro logic better but what i was looking for from this query worked! Thank you so so much!

Tommer · ‎04-12-2022

Hi, I am running a do until condition and I want the output at the end of each iteration to be added to the same dataset ie. %macro ..; %do %until (); more processing.... data x y; if ...output x; else output y; end; %mend. What I am looking to do is at the end of each do until iteration, one dataset that meets the condition is generated and I want to keep adding records to it as I go through the do loop in each iteration. How is this possible?

Tommer · ‎03-31-2022

My thought process for how 'output' works was way off. Played around a bit to understand better, thanks Tom.

Tommer · ‎03-31-2022

My logic was after the first two output statements in my code, there are still rows with missing sex and not missing age (the second do block converted missing to "M" but from the first Do block we have missing sex) which will be the input for the third Do block.

Tommer · ‎03-31-2022

Thank you so much Tom! Any idea what I was doing incorrectly? My understanding is using 'end' just closes the do block. When I have the next Do block, I thought it would run normally as a separate Do block and output, which was not. If you have a minute would you mind helping me understand?

Tommer · ‎03-31-2022

Hello, The dataset I have is : data subj0; input subj $4. sex $2. age; datalines; 101 M 23 102 F 25 103 F 28 104 23 105 F 24 106 M . 107 F 28 108 22 109 F 25 110 F . 111 . ; run; Some subjects have missing sex but age is available, for those subjects I am trying to populate them as both 'M' and 'F' as separate records. I have tried using the below output statement but unsure where I am going wrong as it stops at second output statement. For the third output statement to work, the condition is still met (ie. missing sex and age is present) but it is not running. data exp; set subj0; output; if sex=" " and age ne . then do; sex="M"; output; end; if sex=" " and age ne . then do; sex="F"; output; end; run;

Tommer · ‎03-29-2022

data case1; input id date test_no testname $10. result$; informat date mmddyy10.; datalines; 1 3/29/22 1 ComponentA Yes 1 3/29/22 2 ComponentB No 2 3/29/22 1 ComponentA No 2 3/29/22 2 ComponentB No ; run; /*add a logic to know if overall shd be yes or no by assigning numeric equivalents which can be added up.*/ data case2; set case1; if result = "Yes" then res1 = 1; if result = "No" then res1 = 0; run; proc sql; create table case3 as select id, date format=mmddyy10., 3 as test_no, "Overall" as testname, sum(res1) as res2 from case2 group by id,date; quit; data case4; set case1 case3; by id date test_no; if res2 =>1 then result = "Yes"; else if res2=0 then result = "No"; drop res2; run;

Tommer · ‎03-29-2022

/*First sort the have_contract and create a lag variable:*/ proc sort data=have_Contract; by descending version_begin_date; run; data have_contract2; set have_contract; version_lag = lag(version_begin_date); format version_lag ddmmyy10.; run; /*Then create a Cartesian product followed by filtering for what you need:*/ proc sql; create table all1 as select a.*, b.event_date from have_contract2 a, have_event b where a.contract_number=b.contract_number order by version_begin_date; quit; data all2; set all1; if version_lag ne . and version_begin_date=<event_date<version_lag then inc = 1; else if version_lag eq . and version_begin_date=<event_date then inc =1; if inc=1; drop version_lag inc; run; proc sort data=all2; by contract_number contract_version version_begin_date event_date;

Tommer · ‎02-22-2022

Please ignore this, I was reading the code incorrectly.

Tommer · ‎02-22-2022

Ah!! Writing it this way in the above post helped! I kept ready it incorrectly, my bad! Apologies. Just spent a lot of time reading it as--- select "||dataset||" . Thank you!!

Online Status	Offline
Date Last Visited	‎06-07-2024 05:01 PM

How to get n=0 in proc means

Re: Else if - override

Else if - override

INTNX for hours

Confused about when to use macro functions

Re: do until: struggling to add observation to the same dataset

do until: struggling to add observation to the same dataset

Re: Using output to statement to output different values

Re: Using output to statement to output different values

Re: Using output to statement to output different values

Re: capitalize first letter of first word

Re: capitalize first letter of first word

Re: INTNX for hours

Re: Passing a comma delimited variable to a Macro

Re: Confused about when to use macro functions

Re: Adding A Row Based on Existing Variables

Re: Proc copy of a few datasets, here the list of datasets is mentione...

Re: Proc copy of a few datasets, here the list of datasets is mentione...

Re: Proc copy of a few datasets, here the list of datasets is mentione...

How to get n=0 in proc means

Re: Else if - override

Else if - override

INTNX for hours

Confused about when to use macro functions

Re: do until: struggling to add observation to the same dataset

do until: struggling to add observation to the same dataset

Re: Using output to statement to output different values

Re: Using output to statement to output different values

Re: Using output to statement to output different values

Using output to statement to output different values

Re: Adding A Row Based on Existing Variables

Re: join two tables by comparing date in range dates

Re: Proc copy of a few datasets, here the list of datasets is mentione...

Re: Proc copy of a few datasets, here the list of datasets is mentione...