About bharathkumar

bharathkumar · ‎01-08-2016

Hi Chris, I don't know much about "proc nlin" process, But I will give you suggestion It may work. If the proc nlin procedure fails then "Final_&dataset" having "0" obesrvations, so based on final dataset we can trap TRAP the error. If the dataset have more than one observation your program is successful else fail... Let me know if you have any questions or Correct If I am wrong. Regards, Bharath

bharathkumar · ‎01-02-2016

Hi, Your every thing perfect except "Missover" option missed in your Infile statement. Try It... I got the results as you expected. First Question: data myv9lib.class1(keep=name major credits) myv9lib.problems1(keep=code date) / view=myv9lib.class1; infile student missover; input name $ 1-10 major $ 12-14 credits 16-18; select; when (name=' ' or major=' ' or credits=.) do code=01; date=datetime(); output myv9lib.problems1; end; when (0<credits<90) do code=02; date=datetime(); output myv9lib.problems1; end; otherwise output myv9lib.class1; end; run; proc print data=myv9lib.class1; run; proc print data=myv9lib.problems1; format date datetime18.; run; Second Question: data class(keep=name major credits); infile student missover; input name $ 1-10 major $ 12-14 credits 16-18; run; Thanks & Regards, Bharath

bharathkumar · ‎12-22-2015

Hi, Try this way... input(put(LVRTEDAT,10.),yymmdd10.)) as LVRTEDAT format ddmmyy10. , input(put(LVPURDAT,10.),yymmdd10.)) as LVPURDAT format ddmmyy10. Thanks, Bharath

bharathkumar · ‎12-03-2015

Hello, You want to remove only special character. But before solution was it removes only "/" and also it compress all the "/". please check this below solution. data t; infile cards; input a $; datalines; /ag a/g ag/ /gh ; run; data t1; set t; if anyalpha(a) ne 1 then do; a1=compress(a,substr(a,1,1)); end; else a1=a; run;

bharathkumar · ‎12-03-2015

Hello, In sql we can delete the observations haivng missing values. this solution works for the Numeric variables are numeric only.. data temp; input a b c; datalines; 2 7 100 . 6 150 3 9 170 6 2 . ; run; proc sql; create table test(drop=d) as select *,a+b+c as d from temp having d is not missing; quit;

bharathkumar · ‎12-03-2015

Hello, Cmiss() option works from sas 9.2 onwards. Missing options works in earlier versions also data temp; input clicks activity impression; datalines; 2 7 100 . 6 150 3 9 170 6 2 . ; run; proc contents data=temp out=t(keep=name) noprint; run; proc sql noprint; select name into :var_list separated by ' ' from t; select count(1) into :do_end from t; drop table t; quit; %macro t; data out; set temp; %do i=1 %to &do_end.; if missing(%scan(&var_list.,&i.,' '))=1 then delete; %end; run; %mend; %t;

Online Status	Offline
Date Last Visited	‎11-29-2016 09:28 AM

Re: End Program After Floating Point Overflow Error

Re: How to - Separate .Txt File While Import to EG

Re: Changing the Date format

Re: removing first unwanted/non alphabet characters in a column

Re: How to delete rows with missing numbers

Re: How to delete rows with missing numbers

Re: Compare two columns first alphabetically?

Compare two columns first alphabetically?

How to delete rows with missing numbers

Re: End Program After Floating Point Overflow Error

Re: How to - Separate .Txt File While Import to EG

Re: End Program After Floating Point Overflow Error

Re: How to - Separate .Txt File While Import to EG

Re: Changing the Date format

Re: removing first unwanted/non alphabet characters in a column

Re: How to delete rows with missing numbers

Re: How to delete rows with missing numbers