About SASlearner97

SASlearner97 · ‎12-06-2021

Hello everyone, i hope you are doing well! i have the table bellow : data have; input sales $ client $ Monday Tuesday Wednesday Thursday Friday ; datalines; sale1 A 1 . . . . sale2 B . 0 . . . sale3 C . . 2 . . sale3 C . . . 1 . sale4 D 0 . . . . sale4 D . 2 . . . sale4 D . . 1 . . sale4 D . . . 0 . ; run; i have some records that get duplicated due to different day, like sale3 and sale4 ... i want a table that combine the same sale in one line where i can see each day's number of sales, it's something like : sales client Monday Tuesday Wednesday Thursday Friday sale1 A 1 . . . . sale2 B . 0 . . . sale3 C . . 2 1 . sale4 D 0 2 1 0 . i hope you could help ! Thank you

SASlearner97 · ‎12-11-2020

what is rejected i got : ERROR: File WORK.REJECTED.DATA does not exist.

SASlearner97 · ‎12-11-2020

i want a dataset like that

SASlearner97 · ‎12-11-2020

Hello everyone, I have an Excel file 'have' with data in different dates and i want to make a table of the current days of the week and select every observation from 'have' and put it in the corresponding day of the current week I joined an Excel file with two papers , the first one shows the table 'have' and the second paper shows the paper 'want' , Thanks for helping me

SASlearner97 · ‎12-09-2020

data _null_; call symputx('week_begins',put(intnx('week.2',today(),0,'b'),date9.)); run; this what works for me thank you everyone

SASlearner97 · ‎12-09-2020

i want the starting day of the week to be Monday

SASlearner97 · ‎12-09-2020

by that part of the code i want to get the first day of the week's date, but actually that's not a valid SAS syntax

SASlearner97 · ‎12-09-2020

when i try data _null_; call symput('week_begins',input((today()weekday(today())+2-(weekday(today())=0)),anydtdte10. )) ; run; it doesnt work either

SASlearner97 · ‎12-09-2020

Hello everyone, I hopeyou are doing great! i want to make a date throught this code: data _null_; call symput('week_begins',put(input((today()-weekday(today())+2-(weekday(today())=0)),anydtdte10. ),date9.)) ; run; %put week_begins; I want to get the first day of the current week the result of %put week_begins; would be 07/12/2020 please help, thank you

SASlearner97 · ‎11-26-2020

Thank you so much! it works !

SASlearner97 · ‎11-26-2020

i want only monday to friday the case variable is not important thank you

SASlearner97 · ‎11-26-2020

SASlearner97 · ‎10-28-2020

Thank you so much in my var column i have 4 kinds of observations like : var a1 a2 a3 a4 .... when i tried your code it went like : var date a1 31/01/2013 a1 a1 a1 ... the dates are correct but the column var is wrong ..

SASlearner97 · ‎10-28-2020

yes

SASlearner97 · ‎10-27-2020

yes it comes close my table got some months that ends in 27 or less .. like i have 29/12/2011 for some var how to find the ends of months of dates in my table please Thank you

same data occures multiple times in the same week

Re: Find two weeks interval's data

Re: Find two weeks interval's data

Find two weeks interval's data

Re: macro variable of a date

Re: macro variable of a date

Re: macro variable of a date

Re: macro variable of a date

macro variable of a date

Re: Find data of the current days of week

Re: INTCK to compute minutes between dates

Re: macro variable of a date

Re: macro variable of a date

Re: Find data of the current days of week

Re: Find data of the current days of week

same data occures multiple times in the same week

Re: Find two weeks interval's data

Re: Find two weeks interval's data

Find two weeks interval's data

Re: macro variable of a date

Re: macro variable of a date

Re: macro variable of a date

Re: macro variable of a date

macro variable of a date

Re: Find data of the current days of week

Re: Find data of the current days of week

current week

Re: Find the last day of the month

Re: Find the last day of the month

Re: Find the last day of the month