About Sharath_naik

Sharath_naik · ‎03-02-2024

Hi Sir, I have noted you instruction and in future I will not share any data via excel here is the dataset . data _1; infile datalines dsd truncover; INPUT Level:8. F_there:$1. Blank_90:8.; DATALINES ; 1,x,20 2,x,20 3,F,29 3,F, 4,F, 4,s,90 5,s, 5,s,91 3,F,90 3,s,3 4,s,30 3,S,30 1,X,20 2,X,20 3,X,20 3,S,20 4,F,91 4,F,90 5,,90 6,F, 7,F, 4,,10 3,S,20 1,,20 ;; RUN;

Sharath_naik · ‎03-02-2024

Here is the dataset : data _1; infile datalines dsd truncover; INPUT Level:8. F_there:$1. Blank_90:8.; DATALINES ; 1,x,20 2,x,20 3,F,29 3,F, 4,F, 4,s,90 5,s, 5,s,91 3,F,90 3,s,3 4,s,30 3,S,30 1,X,20 2,X,20 3,X,20 3,S,20 4,F,91 4,F,90 5,,90 6,F, 7,F, 4,,10 3,S,20 1,,20 ;; RUN;

Sharath_naik · ‎03-01-2024

Conditions Leve 1 & Level 2 are Indicator for next segment So conditions won't Apply for these two level. Whenever F_there column has "F" value and Blank_90 column has (" " / 90) value then those line need to be highlighted and if these things appear in a any level apart from I and 2 level then below need to be highlighted until Same level appear again. In below example I have 2 segments and I need green things need to be marked has NA , Because in yellow line you can see level 3 which has (F and blank) value satisfy the condition so we need lines from 3 to Next appearing 3 I have attached excel , PLease help me to sort it out . For any querry please post here

Sharath_naik · ‎06-20-2023

Hi Team, Is there any SAS viya Hands-on project for learning

Sharath_naik · ‎06-17-2023

Hello Brothers/ Sisters, Hope you guys are doing well, I'm interesting in learning SAS viya. Can anyone educate me on how to start learning it .

Sharath_naik · ‎02-03-2022

Hi Team, Please help me to get year based on month ...... In Below example ...... How to get Excepting output Column Group Month Expecting output Abc 11 2021 Abc 12 2021 Abc 1 2022 Abc 2 2022 Abc 3 2022 Abc 4 2022 Abc 5 2022 Abc 6 2022 Abc 7 2022 Abc 8 2022 Abc 9 2022 Abc 10 2022 Abc 11 2022 Abc 12 2022 Abc 1 2023 Abc 2 2023 BVC 12 2021 BVC 1 2022 BVC 2 2022 BVC 3 2022 BVC 4 2022 BVC 5 2022 BVC 6 2022 BVC 7 2022 BVC 8 2022 BVC 9 2022 BVC 10 2022 BVC 11 2022 BVC 12 2022 BVC 1 2023 BVC 2 2023

Sharath_naik · ‎12-22-2020

proc sql noprint; select count(file)into :cnt from new_file; select email_id into :email_id from ack; select cat into :cat from want; quit; %put &cat.; %macro Mail_S; %if &cnt %gt 0 %then %do; OPTIONS EMAILSYS=SMTP EMAILHOST=intramail.cis.cat.com EMAILID="abc@com"; FILENAME BLAT EMAIL FROM = ( "Abc@com" ) TO = ( "Abc@com" ) cc = ("Abc@com") SUBJECT = ( "New Order Acknowledgement -(&sysdate9.)") ATTACH = ( &cat. ct='application/octet-stream' ) TYPE = "TEXT/HTML" ; DATA _NULL_; FILE BLAT; PUT '<HTML><BODY>'; put "Hi Team, "; put "&emsp; recieved on &sysdate9.. "; put 'If you have any questions, '; put "Thank You, "; put "Team "; put '</BODY></HTML>'; run; %end; %mend Mail_s; %mail_s; When ever i send using above code, only one pdf file is able to open , remaining file will not be opened , please help me to figure out thisissue

Sharath_naik · ‎10-27-2020

Hi Team , Please help to send bulk PDF file . below code I'm using %macro Mail_S; %if &cnt %gt 0 %then %do; OPTIONS EMAILSYS=SMTP EMAILHOST=XXXXXXXXXXX EMAILID="Analytics@cat.com"; FILENAME BLAT EMAIL FROM = ( "Analytics@cat.com" ) TO = ( "Analytics@cat.com" ) SUBJECT = ( "New Order (&sysdate9.)") ATTACH = ( &cat. ct='application/octet-stream' ) TYPE = "TEXT/HTML" ; DATA _NULL_; FILE BLAT; PUT '<HTML><BODY>'; put "Analytics "; put '</BODY></HTML>'; run; %end; %mend Mail_s; %mail_s;

Sharath_naik · ‎10-12-2020

Thanks Bro, It worked

Sharath_naik · ‎10-09-2020

It's more than 7 lines... could you please share the combined logic.... I'm worried because some group has 2 lines, some group as 3 lines

Sharath_naik · ‎10-09-2020

Thanks for replying Reeza,,,,, Yes its a pattern.. could you please share the solution

Sharath_naik · ‎10-09-2020

Thanks for Replying @Reeza . 🙂 #A### is a partern ...#A or #B or #C will be generated going forward.... It's not .txt, IT;s a mainframe data,... But in Sorted order

Sharath_naik · ‎10-09-2020

SL_no Column End result 1 A078 B D BLEDSOE 2 DRAWINGS NOT CHANGED A078 B D BLEDSOE DRAWINGS NOT CHANGED 3 A050 D A MATHISON 4 OWNERSHIP OF 5 APPLICABLE A050 D A MATHISON OWNERSHIP OF APPLICABLE 6 A070 B D BLEDSOE 7 DRAWINGS NOT A070 B D BLEDSOE DRAWINGS NOT 1 and 2 row is one group 3,4,5, are another group 6 and 7 are another group Please help me

Sharath_naik · ‎02-15-2020

Thank you Sir for Showing interest in answering my question.. I'm Fetching data from Teradata and storing into SAS dataset, later from SAS dataset I'm loading data into SQL . Fetching 35 crore observation will take approximately 90 min but loading 35 crore observations from SAS to SQL is taking more than 10hr.

Sharath_naik · ‎02-14-2020

Hi Team, I'm not able to load 35 crore observations into SQL in one shot, instead I'm splitting the observation into 4 part and loading, is there anyway to load huge amount of observation(35 crore) into SQL in one shot..... I'm using below code to load data libname sql_test odbc dsn=xxx_test user="xx" pass="xx" schema=xx; proc sql; connect to odbc (dsn=xxx_test user=xx pwd=xx); execute(truncate table TeradataDemand) by odbc; insert into sql_test.TeradataDemand select * from First_ETL; disconnect from odbc; quit ;

Online Status	Offline
Date Last Visited	‎03-14-2024 05:13 PM

Re: How to get observation from between the segment

Re: How to get observation from between the segment

How to get observation from between the segment

Re: How to learn SAS VIYA

How to learn SAS VIYA

How to provide the year based on month

How to attach multiple .pdf in SAS mail through SAS macro

While sending BULK PDF file, file are not able to open

Re: How to get uneven row to single row

Re: How to get uneven row to single row

Re: How to get observation from between the segment

Re: How to get observation from between the segment

Re: How to learn SAS VIYA

Re: How to get uneven row to single row

Re: How to fetch data faster from Mainframe and load data faster into ...

Re: How to get observation from between the segment

Re: How to get observation from between the segment

How to get observation from between the segment

Re: How to learn SAS VIYA

How to learn SAS VIYA

How to provide the year based on month

How to attach multiple .pdf in SAS mail through SAS macro

While sending BULK PDF file, file are not able to open

Re: How to get uneven row to single row

Re: How to get uneven row to single row

Re: How to get uneven row to single row

Re: How to get uneven row to single row

How to get uneven row to single row

Re: How to load huge amount of data into Oracle

How to load huge amount of data into Oracle