About sivastat08

sivastat08 · ‎09-25-2017

i want to create new column whereever missing is after that it should start give number like sequence123.123.123. below is my data ihave tried but i not getting the exact one.please help me, data new; input have ; datalines; 2 1 9 . 1 2 . 5 1 2 . 9 7 5 ; PROC SQL; CREATE TABLE WORK.QUERY_FOR_NEW AS SELECT t1.have, /* getting*/ (case when t1.have = . then . else monotonic() end) AS getting FROM WORK.NEW t1; QUIT; have getting Want . . 2 1 1 1 2 2 9 3 3 . . 1 4 1 2 5 2 . . 5 6 1 1 7 2 2 8 3 . . 9 9 1 7 10 2 5 11 3

sivastat08 · ‎06-29-2017

Hi , i was trying to importing excel file from server, after running the below code - i got an Error message 'ERROR: Failed to connect to the Server: \\11.12.10.122 code: PROC IMPORT DBMS=EXCELCS OUT=WORK.demo DATAFILE="mydrive:\\11.12.10.122\BM SAS Excel \Client_2017_06_29_040011.xlsx"; server= '\\11.12.10.122\BM SAS Excel \'; PORT= 7156; SHEET='ClientAccountnotComplete'; RUN; Error Message: ERROR: Failed to connect to the Server: \\11.12.10.122\BM SAS Excel \. please help me to fix this error. Thanks and Regards, Siva

sivastat08 · ‎04-20-2017

Thanks for your motivation LinusH..going forward i will try to do.

sivastat08 · ‎04-20-2017

Thanks for the answer RW9.

sivastat08 · ‎04-20-2017

sorrry for the miscommunication, kind ignore the previous table. Hi i have (Project) start_date and End_Date and Worked_Date and i want to create indicateor for Worked_Date weather correctly falling between Start_Date and End_Date . Project StartDate EndDate Worked_Date 1 5/25/2016 4/9/2017 1/1/2017 2 4/10/2017 12/31/2199 2/7/2017 3 5/25/2016 12/31/2199 3/9/2017 4 5/25/2016 12/31/2199 4/11/2017 5 5/25/2016 12/15/2016 12/10/2016 6 12/16/2016 12/31/2199 3/13/2017 7 5/25/2016 2/19/2017 1/12/2017 8 5/25/2016 12/31/2199 4/7/2017

sivastat08 · ‎04-20-2017

Hi ,I want Worked_Date should fall Between Start_date and End_Dae in new column Worked_Date Start_Date End_Date 27/04/2016 5/25/2016 5/25/2016 1/6/2016 5/26/2016 5/27/2016 1/7/2016 5/28/2016 5/29/2016 1/8/2016 5/30/2016 5/31/2016 1/9/2016 5/31/2016 6/1/2016 1/10/2016 6/1/2016 6/5/2016 1/11/2016 6/2/2016 6/6/2016 1/12/2016 6/6/2016 6/7/2016 2/5/2016 6/7/2016 6/8/2016 2/6/2016 6/8/2016 6/9/2016

sivastat08 · ‎04-19-2017

somebody please help me to fix this issue

sivastat08 · ‎04-18-2017

I am really apologies for double posting the same question:smileysad. Thanks for the answer sir.

sivastat08 · ‎04-18-2017

how to compress (Compress = yes) output data set in SAS Enterprise guide using Query Builder(GUI) Thanks, Siva

sivastat08 · ‎04-18-2017

how to compress (Compress = yes) output data set in SAS Enterprise guide using Query Builder(GUI) Thanks, Siva

sivastat08 · ‎04-17-2017

Thanks for the replay Varsha.Please find the Data. Fields Used in Graph Fields Used in Graph Filters applied for the graph Filters applied for the graph Filters applied for the graph Time Calls Freq Top Calls(Call Number) Client Month 13 to 14 1 1231 XYZ 17-Apr 16 to 17 1 1231 XYZ 17-Apr 17 to 18 1 1231 XYZ 17-Apr

sivastat08 · ‎04-17-2017

Hi,this is todays most priority task for me.Can anybody help me to fix this isssue?

sivastat08 · ‎04-12-2017

Kindly help me to fix this issue.

sivastat08 · ‎04-12-2017

We have created a speedometer guage with display rule which looks as below. It is from report designer. This same can be view in classic report viewer theme. But when we see this in modern report viewer theme it looks completely different as seen below. .. Please guide what is the issue here?

sivastat08 · ‎04-06-2017

Why this issue is coming? Other friend is facing the same issue but with different data.

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

After missing new column should start with sequence

Failed to connect to server

Re: How to create new column should fall between Start_Date and End_Da...

Re: How to create new column should fall between Start_Date and End_Da...

Re: How to create new column should fall between Start_Date and End_Da...

How to create new column should fall between Start_Date and End_Date

Re: Overly filled graph is coming differently

Re: compress output data set in SAS EG Query Builder

compress output data set in SAS EG Query Builder

compress output data set in SAS EG Query Builder

Re: Overly filled graph is coming differently

Re: Display rules for gauges not working in Report Viewer Modern Theme

Re: Overly filled graph is coming differently

Display rules for gauges not working in Report Viewer Modern Theme

Re: Overly filled graph is coming differently

SAS Community Nordic