About sivastat08

sivastat08 · ‎11-26-2019

Hello sir, user might have miss spelled instead of ( 101 1 1.1)=(101 1 3.9) data have; input subject visitnum results; cards; 101 1 1.1 101 2 2.2 101 3 2.2 101 4 2.0 101 5 0.9 101 6 2.0 run;

sivastat08 · ‎11-26-2019

Hi, data have; input subject visitnum results; cards; 101 1 3.9 101 2 2.2 101 3 2.2 101 4 2.0 101 5 0.9 101 6 2.0 run; Data want; set have; required=lag(results); run;

sivastat08 · ‎08-20-2019

Thank a lot Sir

sivastat08 · ‎08-20-2019

yes sir , i want (Report) should be removed from the text i want output like this column1_want ="Quality Dashboard V1" Thanks!

sivastat08 · ‎08-20-2019

Hi Team i want a new column output from below mentioned text dynamically.Kindly help on this. Sample Data: DATA TEST; NEW='SBIP://METASERVER/BI SAS VA REPORTS/AR Testing [Should always be in sync with Production]/Quality Dashboard V1(Report)'; TEST1 =(TRANSLATE(scan(NEW, -1,'/'),' ','_')); FORMAT NEW $150. TEST1 $75.; RUN; Out put want: column1_want ="Quality Dashboard"; colunm2_want = "SBIP://METASERVER/BI SAS VA REPORTS/AR Testing [Should always be in sync with Production]"

sivastat08 · ‎07-17-2019

Hi I want to create "July 2nd Week" in new column,Below is the sample code i tried but i stuck in adding ('th' 'st') dynamically or is there any alternative way to create please help me on this . data want; format Today date9. month $3. Week $3. Cat $10.; Today=today(); month=put(month(Today),monname3.); Week=put(WEEKDAY(Today),weekday.); Cat= put(catx(' ',month,Week,'Week'),$10.); run; Thanks, Siva

sivastat08 · ‎07-17-2019

Thanks for the replay Reeza. if My data exceeds 1000 then it shout not print otherwise it should print . your code is working fine.Thanks for the answer Reeza

sivastat08 · ‎07-17-2019

Thanks for answer Tom.

sivastat08 · ‎07-17-2019

Hi All, I want to use no print option when data size is large .Please help me on the below. Below is my sample code, if my data output exceeds 1000 observation then it should not print the output. data xyz; set sashelp.class; run; proc print data=xyz; run; proc report data=xyz (option=noprint); run; proc sql ; select * from sashelp.class; run; Thanks, Siva

sivastat08 · ‎07-17-2019

Thank you very much Tom!

sivastat08 · ‎07-16-2019

Hi I want after the last Last delimiter text should be extract and replaced _ with Space delimiter in sas data ddd; format Have $50. Want$50.; Have="\core\event\user_login_failed"; Want=(substr(Have,1,index(Have,"\")+(lengthn("\")-1))); run; Have="\core\event\user_login_failed"; Want=user_login_failed replaced instead of user login failed Thanks, Siva

sivastat08 · ‎07-12-2019

Sure Tom.Thank you for such a detailed answer!

sivastat08 · ‎07-12-2019

here is the sample code %LET TODAY=%SYSFUNC(TODAY(),DATE9.); %PUT &TODAY; %LET Monday = %SYSFUNC(INTNX(WEEK.2,%SYSFUNC(TODAY()),0), 'b'); %PUT &Monday DOWNAME.; %LET Friday = %SYSFUNC(INTNX(WEEK.6,%SYSFUNC(TODAY()),0), 'b'); %PUT &Friday; filename outbox email to= ('XXX.YYY@abchealth.com') cc= ('sivakumar.siva@abchealth.com') type='text/html' subject="Weekly Status"; data _null_; file outbox; put "Hi all"; put "<P>"; Put "Please find the Weekly Status Report of 08July2019 - 12jul2019 "; put "<P>"; put "Thank you,"; run;

sivastat08 · ‎07-12-2019

Yes sir.This code will run on every friday it should display Current Week Monday to Friday date Dynamically.

sivastat08 · ‎07-12-2019

I want to send automated email using email body mentioning monday date and friday date as "08Mon19 - 16Fri19"

Online Status	Offline
Date Last Visited	‎12-28-2021 04:12 PM

Re: How to get minimum value for the below data?

Re: How to get minimum value for the below data?

Re: Get the text before the last special character presence in SAS

Re: Get the text before the last special character presence in SAS

Get the text before the last special character presence in SAS

Month of week and week of month in sas

Re: NO Print option in sas EG

Re: NO Print option in sas EG

NO Print option in sas EG

Re: remove Delimiter in sas

Re: Data set with if statement

Re: Filtering data by two variables

Re: Filtering data by two variables

Re: Remove similarities

Re: PROC SQL - Grouping

Get Complete Month list

Re: After missing new column should start with sequence

Re: send Email thru SAS EG

Re: send Email thru SAS EG

Re: Last.Transsection Date

Re: How to get minimum value for the below data?

Re: How to get minimum value for the below data?

Re: Get the text before the last special character presence in SAS

Re: Get the text before the last special character presence in SAS

Get the text before the last special character presence in SAS

Month of week and week of month in sas

Re: NO Print option in sas EG

Re: NO Print option in sas EG

NO Print option in sas EG

Re: remove Delimiter in sas

remove Delimiter in sas

Re: INTNX for week day in %SYSFUNC

Re: INTNX for week day in %SYSFUNC

Re: INTNX for week day in %SYSFUNC

Re: INTNX for week day in %SYSFUNC

SAS Community Nordic