About sdixit

sdixit · ‎12-11-2017

Thanks! That works

sdixit · ‎12-11-2017

Hi , I want to substring the alphanumeric string example 00000031700ALLISON S00001 which are of different length. I just need to extract the substring starting with first character that is ALLISON S00001. so the result of substring from 00000031700ALLISON S00001 is below ALLISON S00001

sdixit · ‎11-28-2017

Hi All, I am looking for the logic to decrypt a field in SQL SERVER table using SAS EG. Thanks

sdixit · ‎07-13-2017

Hi All, Could someone assist me how I can read only the last day of the month data from my table . Example : I have a sql to pull the data from netezza table to SAS Based on the period dates which has daily data But i need to pull only the data of last day of each month. How can i accomlipsed that in the sql pass through? Period date 01jul 02jul 30jul==> need this data 01aug 02aug 03aug 31aug ==> need this data Thanks Shuchi

sdixit · ‎05-11-2017

Hi , I have to search the variable a in variable b Example variable a variable b "North Carolina" Wake Forest University Conference Center, 200 North College Street, Charlotte, North Carolina | Room 113 if yes then create a flag. Help?

sdixit · ‎10-27-2016

I am connecting to Netezza. I am getting a NOTE in log for few datetime columns. NOTE: The data value for column DATE_W (DATE_W) was truncated or was out of range 390 times when retrieving that data from the DBMS. What are the ways to pull date fields correctly which are out of range in SAS. Thank you

sdixit · ‎09-30-2016

Thanks for the response but the issue is that I have to run code manually.

sdixit · ‎09-28-2016

Hi All, Could someone tell me is there any way to save complete SAS project log automatically using SAS code or any setting in SAS EG 7.1? I used proc printto log to save individual sas codes in a SAS PROJECT. Thanks

sdixit · ‎08-19-2016

Hi, I am trying to find PrinBal variable belongs to which table in MTGAE libaray but It is taking long time to run. Can you help why? Proc sql; SELECT * FROM DICTIONARY.COLUMNS WHERE UPCASE(LIBNAME) in ("MTGAE") AND memtype ="DATA" And NAME in ("PrinBal") ; QUIT;

sdixit · ‎08-11-2016

Hi Chris, Thanks for sharing the paper. Indeed it was helpful for me. \

sdixit · ‎08-10-2016

Hi , How to Email Excel file with Multiple work sheets as attachment using SAS EMAIL ? I have a xlsx file to attach in my email Filename hmmail_1 email TO=&Email_to_Id. CC=&Email_cc_Id. Subject="abcth.." Attach="/xx/xx/xx/xx./xx..xlsx" ; 　 %Macro Send_Mthly_Email; Data _null_; file hmmail_1 lrecl=375; put "Hi All," //; put "The report is completed."/; put "Attached report is available ." //; put "Thanks," /; put "&Thanks_Name."; output; run; %Mend; %Send_Mthly_Email;

sdixit · ‎08-04-2016

Hi All, Is there any easy way to find where the list of variables present in the libarary. Example : I have list of variables ABC , BDC , XYZ...So on. I would like to know which table contains these fields in library, Thanks

sdixit · ‎07-20-2016

data want; set have; array lookup(5) $10 _temporary_ ('8' '9+' '9' '9-' '10'); n=countw(abc); flag='N'; do i=1 to n; part=strip(scan(abc, i, ",")); if whichc(part, of lookup(*))>0 then flag='Y'; end; keep abc flag ;run; This works. Thanks for you help.

sdixit · ‎07-20-2016

it is any number then flag ="y" . Varibale can have single digit or string of digits.

sdixit · ‎07-20-2016

Thanks The requirement has changed a bit. so now my motive is to create a flag when my variable matches with any number from ('8', '9+',' 9', '9-', '10') string. So if there is any number present in my variable ABC , it should set the flag = "Y". My data looks like : ABC Flag 5,7,8 Y 9,7,4 Y 8 Y 9 Y 9+ Y 9- Y 10 Y 5,6 N 3,2 N You suggestion works if we have 2 number or greater in the string.but if there is only 1 digit then it wont work. Pls suggest for that

Online Status	Offline
Date Last Visited	‎12-11-2017 12:38 PM

Re: Substring a alphanumeric string starting from first character in t...

Substring a alphanumeric string starting from first character in the s...

decrypt field in table

reading only last date of the month from the date variable

Search an address variable for a specific value/variable value

Netezza- accessing date out of range or truncated in SAS

Re: BASE SAS PROGRAMMING-sas log

BASE SAS PROGRAMMING-sas log

Re: BASE SAS

Re: How to Email Excel file with Multiple work sheets as attachment us...

BASE SAS