About sunilzood

sunilzood · ‎09-06-2013

TRY THIS : Data Math; input Name $ Sirname $ Marks; cards; Sunil K 24 Sanjeev Z 19 Rahul c 13 ;run; Data ENG; input Name $ Sirname $ Marks; cards; Vishal K 24 Vicky Z 19 Meenu c 13 ;run; libname sample excel 'C:\SAS_DUMP\myexcel.xls'; data sample.math; set Math; data sample.eng; set Eng; run; libname sample;

sunilzood · ‎07-05-2013

Good one Shap, I was expecting for a best Solution... Thanks.!!

sunilzood · ‎07-05-2013

Hi Helann, Please try .... data have ; input test_date $20. ; cards; Jun 01 2013 6.40pm Feb 14 2012 7.25am Mar 28 2011 3.40pm ;run; data want (drop = a b c d) ; set have; a = compress(upcase(substr(test_date,1,3))); b = substr(test_date,5,2); c = substr(test_date,8,4); if a = 'JAN' then d = 1; else if a = 'FEB' then d = 2; else if a = 'MAR' then d = 3; else if a = 'APR' then d = 4; else if a = 'MAY' then d = 5; else if a = 'JUN' then d = 6; else if a = 'JUL' then d = 7; else if a = 'AUG' then d = 8; else if a = 'SEP' then d = 9; else if a = 'OCT' then d = 10; else if a = 'NOV' then d = 11; else if a = 'DEC' then d = 12; Final_date = mdy(d,b,c); format Final_date ddmmyy10.; Run;

sunilzood · ‎07-04-2013

Uma, Please help to understand the difference in Clinical line vs SAS Advance Line, What is good to go as carrier ...?

sunilzood · ‎07-04-2013

Thanks I Got it!!!

sunilzood · ‎07-03-2013

Understood!!! Thanks Dude.

sunilzood · ‎07-02-2013

Anand, to use merge & append, you need to sort the observation & while sorting Nodup key take cares of dup records!!!

sunilzood · ‎07-02-2013

Anca, Good try!!! u were close. thanks!!!

sunilzood · ‎07-02-2013

Hi Linlin, Thanks its working fine. But request to please elaborate the below highlights- what is happening with p1,l1p2,l2,-n, call scan(keepit,-1,p1,l1,' '); call scan(keepit,3,p2,l2,' '); n=max(find(keepit,'Mr'),find(keepit,'Ms'),find(keepit,'Mrs')); name=substr(keepit,n,p1-n); plan=substr(keepit,p2,n-p2); sunil

sunilzood · ‎07-02-2013

Please help, since want to call this data in a table using cards/dataline option. There are Total 5 variable and please note name starts with Mr/mrs. Header are: Ref_no Mode Plan Name Amount Sharing third row as ex : Ref_no Mode Plan Name Amount Y10800539 YEARLY MARS Family REVENUE Builder Mrs. sina Manahattan 970 Observations are : Y10800542 YEARLY MARS PLAN Vriddhi Mr. Surendra gita Kumar 100.4 Y10800543 YEARLY MARS PLAN Vriddhi Mr. Rahul kapu Man 969.83 Y10800539 YEARLY MARS Family REVENUE Builder Mrs. sina Manahattan 970 Y10800539 YEARLY MARS LifeLONG BEST Mr Virag Bashmukh 86 Y10800539 YEARLY MARS LifeLONG BEST Mr. Tricky behoshi H 94.5 Y10800539 YEARLY MARS Young Scholar Secure Mr. Joyton Flavian sequence 500 Y10800543 YEARLY MARS Family REVENUE Builder Mr. Suraj putraJoban 5000 Y10800543 YEARLY MARS PLAN Varsha Ms. Mahalakshmi krishnanram 504 Y10800543 YEARLY MARS PLAN Vriddhi Mr. Himanshu Pahwa 3003.75 Y10800543 YEARLY MARS PLAN Vriddhi Mr. Sanjay Vaarma 213.54 Y10800543 YEARLY MARS PLAN Vriddhi Mrs. Jane Saggarwal 3327 Y10800543 YEARLY MARS LIVE SMART Mr Syed husain Jasmeet 800 Y10800543 YEARLY MARS PLAN Vriddhi Mr Rajesh babr 1000.69 Y10800543 YEARLY MARS PLAN Vriddhi Mr. Rajan visal 241.53 rgds sunil

sunilzood · ‎07-01-2013

Hi Uma, I will be glad if you can share the same with me also. my email id is : sunil.zood@gmail.com rgds sunil

sunilzood · ‎07-01-2013

Ksharp solution is Perfect , But when I tried it skipped alternate rows. A little modification just by adding " : " will work perfect. Please try: data _null_; input x : $ 100.; y=scan(x,4,'./'); put x= y=; cards; client/data/20/0000893220-98-000530.txt client/data/810084/0001193125-08-059176.txt client/data/914208/0000950129-07-000703.txt client/data/1036213/0001036213-98-000015.txt client/data/1103345/0001103345-05-000031.txt client/data/1161175/0000950123-10-012321.txt ; run;

sunilzood · ‎06-21-2013

Dear Sharp, Please Expalin the logic for id+1....

sunilzood · ‎06-18-2013

Dear Jen, Looking your output in table 3 seems that table2 is not created well. It tried it with a formateed way & results is good. Hope it helps if i understood your request well. All d best.. data table1; input EVAL_PRITY_CD EVAL_RL_ID eval_description :$15. Total_Applications ; cards; 2100 4703 Description1 31 1152 4709 Description2 22 3600 5102 Description3 20 ; run; data table2; input queue dcsn_by $ priority_cd rule_id1 rule_id2 rule_id3 rule_id4 rule_id5 Total ; cards; 123 emp1 2150 4703 15005 5102 . . 4 456 emp2 19000 2876 4703 . . . 1 789 emp1 19000 4709 4703 5102 . . 3 ; run; proc sort data = table1; by EVAL_RL_ID; run; proc sort data = table2; by rule_id1; run; data merge_both; merge table1 (in = aa rename = (EVAL_RL_ID = rule_id1)) table2 ( in = bb); by rule_id1; if aa = 1; run; sunil

sunilzood · ‎06-18-2013

Try below code : Will get the same result as required. data tourrevenue; input Country :$ 1-11 LandCost Vendor $ customer; cards; France 575 Express 10 Spain 510 World 12 Brazil 540 World 6 Japan 720 Express 10 Greece 698 Express 20 Venezuela 425 World 8 Italy 468 Express 9 Russia 924 World 6 Switzerland 734 World 20 Ireland 558 Express 9 ; Run; Proc sort data = tourrevenue ;by vendor; run; data Percen; input Vendor $ Customer Percentages; cards; Express 58 0.52727 World 52 0.47273 ; run; proc sort data = percen; by vendor; run; data merge_both; merge tourrevenue(in=aa) percen(In=bb); by Vendor; if aa = 1; New_Landcost = LandCost*Percentages; run;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

Re: How to export from SAS to Excel?

Re: how to validate datetime column?

Re: how to validate datetime column?

Re: SAS Certified Clinical Trials Programmer Using SAS 9

Re: Raw data for practice

Re: Call data using Cards/dataline option

Re: 6-ways of removing duplicate

Re: Call data using Cards/dataline option

Re: Call data using Cards/dataline option

Call data using Cards/dataline option

Re: How to extract string from a character variable?

Re: 6-ways of removing duplicate

Re: How to export from SAS to Excel?

Re: how to validate datetime column?

Re: how to validate datetime column?

Re: SAS Certified Clinical Trials Programmer Using SAS 9

Re: Raw data for practice

Re: Call data using Cards/dataline option

Re: 6-ways of removing duplicate

Re: Call data using Cards/dataline option

Re: Call data using Cards/dataline option

Call data using Cards/dataline option

Re: Raw data for practice

Re: How to extract string from a character variable?

Re: Handling two files at the same time

Re: Merge

Re: Calculating percentage