About anushreebiotech

anushreebiotech · ‎06-22-2019

Hi, Try this: Proc SQL; Create table part3 as select * from part where part.id not in (Select * , B.Delivery From part a join sch b on a.id=b.id and a.day=b.day); quit; Regards, Anushree

anushreebiotech · ‎06-21-2019

Hello, Please check this: PROC SQL; create table work.sheet as select a, b, date from library where date>= '02-01-2018'd and date <= today(); quit; It worked for me. Regards, Anushree

anushreebiotech · ‎06-20-2019

Hi, data want; set have; where mem_id in ('A', 'B'); run; Regards, Anushree

anushreebiotech · ‎06-09-2019

Hi @dwhitney , Please remove the input statement, since you are using the set statement. Regards, Anushree

anushreebiotech · ‎06-09-2019

Hi, Can you please put headers in your text file. Its difficult to understand like this. Regards, Anushree

anushreebiotech · ‎06-08-2019

Hi, 1. There is a problem with your Title statement. It shouldn't have = sign. 2. Secondly, I think you need to check your path where you want the output. I used your code with these changes, and its working perfectly fine for me. 3. ODS statement is a global statement. That's why we don't have to use run after that. data construction; input Items $ Qty Rate instock sold; cards; Bricks 1 35 1485 2453 Paint 1 45 1487 2658 Lader 1 75 1224 2014 Hammer 1 50 1789 2369 Nail 1 5 1258 458 ; run; proc print data= construction; run; ods pdf file= "/home/anushreebiotech0/ECRB94/data/construction.pdf"; title "Purchase_list"; proc print data= construction; run; ods pdf close; Regards, Anushree

anushreebiotech · ‎06-07-2019

Hi, You can use Trim function. data have; re="all"; ro="hello"; ra=catx('',ro,re); texto='blablabla hello all, people'; if index(texto,(trim(ra)))>0 then do; bi="wee"; end; run; Regards, Anushree

anushreebiotech · ‎06-07-2019

Hi, data have; input Surgstart; datalines; 20140410 ; run; data want; set have; SurgDate=Input( Put( Surgstart, 8.), Yymmdd10.); format SurgDate Yymmdd10.; run;

anushreebiotech · ‎06-04-2019

Hi, data have; input path $50.; datalines; Manta/333/1*0.17 Manta/333/1*0.17 Manta/333/1*0.17 Manta/333/1*0.17 ; run; data want; set have; Nettype= scan(path,1,'/'); Mesh= scan(path,2,'/'); Dimension= scan(path,3,'/'); run; Regards, Anushree

anushreebiotech · ‎06-04-2019

Hi, data have; input path $50.; datalines; /c:/user/new/path1/path2/path3/path4/cjx.sas /c:/user/old/new/path1/path2/path3/path4/cjx.sas /c:/user/new/path5/path2/path3/path4/cjx.sas /c:/user/old/new/path5/path2/path3/path4/cjx.sas ; run; data want; set have; new_path= Tranwrd(path,'cjx.sas',""); run; Regards, Anushree

anushreebiotech · ‎06-01-2019

Hi, data miss_var; input slno $ course_name $; if missing(course_name) then do ; check= 'course_name is missing.' ; end; else if missing(slno) then do; check= 'slno is missing.'; end; datalines; 001 java 002 c++ 003 javascript . node js 005 . . pandas ; run;

anushreebiotech · ‎05-31-2019

Hi, Please find the code below: proc sql; Create table want as select distinct Card_Num , case when (count(Store_Name) = 1 and lower(Store_Name) like 'str%') then 'Store_Only' when (count(Store_Name) = 1 and lower(Store_name) ='online') then 'Online' when (count(Store_Name) >= 2) then 'Unclassified' end as Category from C group by Card_Num Order by Card_Num ; quit; Output would be : CARD_NUM Category 12345 Online 23456 Store_Only 43214 Store_Only 98765 Unclassified Regards, Anushree

anushreebiotech · ‎05-29-2019

Hi, proc sql; select * from test where lower(id) like 'p%'; quit; Regards, Anushree

anushreebiotech · ‎05-29-2019

Hi, proc sort data= sashelp.class out= class_check; by sex descending Weight ; run; data class_check2; set class_check; by sex descending Weight; if first.sex then counter=0; counter+1; if counter=3 then output; drop name age counter; run; Regards, Anushree

anushreebiotech · ‎05-28-2019

Hi, If you don't want to use these columns anywhere in your new data set, then you use drop= option in the set statement. DATA work1.AAA_import; SET work.AAA_import (drop= orgID org_name surveyID); run; Regards, Anushree

Online Status	Offline
Date Last Visited	‎07-21-2019 03:50 PM

Re: Unmatched query

Re: How to use today's date in where condition in proc sql?

Re: Extracting all records for only two unique variable values

Re: Adding days to a month format and changing format

Re: reading txt file with no delimiter

Re: SAS Beginer- Issue faced with ODS statement

Re: Index not finding string if there is a comma or dot etc after it

Re: Changing from numerical data to date using SAS ondemand

Re: Separate data from one column to multiple columns

Re: How to extract this string?

Re: Changing from numerical data to date using SAS ondemand

Re: Separate data from one column to multiple columns

Re: How to extract this string?

Re: Unmatched query

Re: How to use today's date in where condition in proc sql?

Re: Extracting all records for only two unique variable values

Re: Adding days to a month format and changing format

Re: reading txt file with no delimiter

Re: SAS Beginer- Issue faced with ODS statement

Re: Index not finding string if there is a comma or dot etc after it

Re: Changing from numerical data to date using SAS ondemand

Re: Separate data from one column to multiple columns

Re: How to extract this string?

Re: Missing Function

Re: PROC SQL Case when statement

Re: Finding a Specific letter in Specific position in text

Re: SAS

Re: How can I hide the column in using the DATA step