About yashpande

yashpande · ‎05-22-2016

Hi there, I need to extract part of string. Actually my proc SQL code is saved in string and I need to find source table from it. Below is my input Code Proc SQL; create table t1 as select a from b,c; quit; Proc SQL; create table t2 as select a from t3 inner join t4 on t3.id=t4.Id ; quit; Proc SQL; create table t5 as select a from t6 left join t7 on t6.id=t8.id; quit; Output needed as below: Source B,c T3,t4 T6,t8 Any help is really appreciated

yashpande · ‎07-23-2015

Hi all, I have a simple macro %macro m1(parm1,parm2,parm3); Process report data = have; Where id=&parm1 and phone=&parm2 and name="&parm3"; Run; %mend; Data have; Input Id 8. Phone 10. Name $30.; Cards; 1 1234567890 Rajesh 2 9876543210 Mohan ; Run; Now I want to pass values of these observations as parameters to macro.. So my macro calls go like this %m1(1,1234567890,"Rajesh"); %m1(2,9876543210,"Mohan"); But this is not efficient...Please help

yashpande · ‎07-14-2015

Hi All, I want to send an email with following content The Name , Status etc you see is actually a dataset ( proc print ) but somehow I am unable to get it right . Any help is really appreciated Logo ( Image File) Hi Admin, the report is as below Name Status ABC ok PQR not ok DEF ok This report was generated at 14jul2015

yashpande · ‎06-04-2015

Hi DKB and slchen, If the keyword "this" appears in between then the output is not getting generated correctly. Lets say below input , where this is replaced by " and this ". Its getting empty results. I have tried using contains but its not working data have; input column $30.; datalines; welcome to my system and this is new variable and its called delq_status in mortgage and we are assigning it to zero ; run;

yashpande · ‎06-03-2015

Hi All, I have a character variable in my dataset and i need to create the macro which will pass some value as parameter then in that variable, i need to lookback to find first occurance of keyword called "This" and then go and find the last occurance of keyword "mortgage" whatever is between these two key variables , i need to output in another dataset. Input data have; column $30.; datalines; welcome to my system this is new variable and its called delq_status in mortgage and we are assigning it to zero ; run; What I want in output is Want Output (column name) This is new variable and its called delq_status in mortgage Start point and end point (This and Mortgage ) is always common but we need to be case insensitive and there has to be exact match. I am trying really hard and think that regular expressions can be used for such scenarios but somehow not getting it right Please please please suggest ideas

yashpande · ‎05-16-2015

can we use the Findw ? But somehow i am not getting correct answer Lets say if my data is something like this data new; input number 8. str $200; cards; 1 phone is not present 2 Phone_id is not present 3 Phone_num is present 4 Phone_new is absent 5 Phone is present 6 PHONE is also there 7 pHone is there 8 phone_num and phone is not there 9 phone_num is present ; run; Output should be 1 phone is not present 5 Phone is present 6 PHONE is also there 7 pHone is there 8 phone_num and phone is not there I am really confused .. what to use and what not. Can we use PRXMATCH for same task

yashpande · ‎05-15-2015

Hi All, I am searching for keyword phone .. it could be case insensitive I have data like data new; input number 8. str $20; cards; 1 phone 2 Phone_id 3 Phone_num 4 Phone_new 5 Phone ; run; I want output as 1 phone 5 Phone I used Find function and Index function but its producing me all observations. I want exact and case insensitive match. How can it be done. Many Thanks

yashpande · ‎05-10-2015

Yes there was an issue with the earlier statement where I missed the semicolon. Thanks a lot Kurt, SAS Kiwi, Tom, Reeza for such valuable inputs

yashpande · ‎05-10-2015

Hi All, I am facing error as below ERROR: Macro keyword LET appears as text. The code i have is %let folder=/gpfs1/SP_Output/Lev1/users/l058017/search_engine_logs/; %let sub2_l=sitename; %let attch2="&folder.attach_brdm/attach_brdm_&sub2_l..zip" "&folder.attach_crce/attach_crce_&sub2_l..zip" "&folder.attach_crce/attach_ecps_&sub2_l..zip"; i am using this macro attch2 to send zipped files in email. This code works in base SAS and EG , However when I try to run this in batch it gives error as Macro Keyword LET appears as text. I want attch2 to be resolved as "/gpfs1/SP_Output/Lev1/users/l058017/search_engine_logs/attach_brdm_sitename.zip" "/gpfs1/SP_Output/Lev1/users/l058017/search_engine_logs/attach_crce_sitename.zip" "/gpfs1/SP_Output/Lev1/users/l058017/search_engine_logs/attach_ecps_sitename.zip" Where I am commiting the mistake ?? Need suggestion please

yashpande · ‎04-30-2015

This could probably be the really novice task but i am unable to get the answer easily. My EMP table looks like this Emp_Name Address Phone Dept abc 1234 abc park road abc Sales What I want in output is single observation like Emp_Name Address Phone Dept abc park road 1234 Sales Need direction please

yashpande · ‎04-30-2015

I have been asked to get the matched keyword from a text file and get 2 lines/observations before and 2 lines/observations after.My data looks like this data have; input var$25.; Description This is a format for the variable named Default it is changed in release 5 change was logged on 18 Jan 2015 ; run; What I want in output is variable named Default it is changed in release 5 Here , i tried using the Index function something like this Data want; set have; if index(var,"default") >1 then output; run; But it is producing just 1 line, however i want 2 lines above and 2 lines below. Please suggest some alternatives

yashpande · ‎04-24-2015

Hi, I am sending an HTML report of my dataset to all users in an email , however the html report is not getting company logo displayed at the beginning. When i see it on my screen , i get it but when it is opened by others they dont see it. What could be the reason i did use title j=c '^{style [preimage="/gpf1/output/imag004.gif"]}'; However it is still not displayed. Thanks in advance for the help

yashpande · ‎04-16-2015

Hi, I am very new to SAS EG. I have a AIX server and windows 7 environment. Windows scheduler is on and working fine. My SAS EG project consists of only one program libname output "/gpfs1/out_area"; libname source oracle user="" password=""; data output.mortg; set source.mortg_v; run; The code runs absolutely fine and I need to schedule it on dataset arrival condition in source. I scheduled it from SAS EG and it did create the .vbs file. I am unable to go to the next steps 1. If i double click on the .vbs file it gives error 2. How to add this file in windows scheduler Any help is really appreciated

yashpande · ‎04-15-2015

I have got several txt files on unix platform. Names are different but structure is same. I need to create only one dataset of all these files and that should have data from all. My below one datastep works fine but i am unable to somehow get all files together in one dataset. and I also want one column which says the name of the text file from which this data is coming Data new; infile "/gpfs1/ana_layer/file1.txt' ; input @1 id $3 @5 age; run; this works correctly for one file but i am unable to generalise it for the entire directory and also unable to get the filename as one more column in the resultant dataset Thanks a lot in advance

yashpande · ‎07-17-2014

No scdent, I want the obswervation number of duplicate record. If you look at my source. First observation is repeated at row number 4 thats what I need to put in variable Dup_row_num

Online Status	Offline
Date Last Visited	‎07-21-2024 02:49 PM

Re: Simplify proc sql multiple joins

Simplify proc sql multiple joins

multiple prxchange together

Values iteration for two datasets

Re: Generate Random values for encoding

Generate Random values for encoding

Need help in creating regular expression for prxchange feed

Modify taking lot of time

Re: Left Join or Merge of sas tables optimization

Left Join or Merge of sas tables optimization

Re: Proc Metadata to get Dependent Objects

Re: Proc Metadata to get Dependent Objects

Re: macro nested loop group by

Increment datetime by 6hours

Extract string from word

Dataset observations as macro parameters

Email report in HTML format

Re: Lookback and Look ahead in character variable

Lookback and Look ahead in character variable

Re: Find the exact match in string

Find the exact match in string

Re: ERROR: Macro keyword LET appears as text.

ERROR: Macro keyword LET appears as text.

Removing missing values in a group

Getting 2 observations before and after

ODS HTML report logo not displayed

SAS EG Project Scheduling help

Read all text files into one dataset

Re: Observation number of duplicate record