Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


I need to find the numeric field which contains blank in
between..Ex:123 456...there is blank in between the 123
456..I need to know if there is any SAS function to find a
field..


Please suggest...

Answers were Sorted based on User's Feedback



I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in b..

Answer / kalyan

we can use index function to find any specific string.

test=index('123 456',' ') it will give 4, the position of blank. is this helpful?

Is This Answer Correct ?    8 Yes 0 No

I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in b..

Answer / mahesh babu

data test;
a="123 456";
b=anyspace(a);
run;

Is This Answer Correct ?    2 Yes 0 No

I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in b..

Answer / amaranuswathi

Please suggest if any function is there to find to find the
particular field...

Is This Answer Correct ?    0 Yes 0 No

I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in b..

Answer / akhil

If I am having a data set c
data test;
input c $ 20.;

cards;
123 456
217 236
456235
225 5665
55
77 85
46556
4588 56
;
run;
proc print;
run;

Now I am going to fetch observation having space in between,

data e(drop=e t);
set test;
e=length(c);
t=find(c,'');
if e>t;
run;
proc print data=e;
run;

Is This Answer Correct ?    0 Yes 0 No

I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in b..

Answer / akhil126

data test;
input c $ 20.;

cards;
123 456
217 236
456235
225 5665
55
77 85
46556
4588 56
;
run;
proc print;
run;

data e(drop=e t);
set test;
e=length(c);
t=find(c,'');
if e>t;
run;
proc print data=e;
run;

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SAS Interview Questions

% let A=3+4 what is result

4 Answers   Satyam,


1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.

1 Answers  


Are you involved in writing the inferential analysis plan? Tables specfications?

0 Answers   Wipro,


What will calendar procedure do?

0 Answers  


How many missing values are available? When might you use them?

1 Answers   Quintiles,


Tell e how how dealt with..

0 Answers  


how to generate the test data in sas without input data? : Sas-administrator

0 Answers  


it will become easy if uuu provide website linkssss and list of consultanciessssss

0 Answers  


In which case u go for libname and in which case u go for proc sql pass thru facilit diff?

1 Answers  


Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)

4 Answers  


where will go the observations that were deleted by delete statement?

2 Answers  


What is the difference between nodupkey and nodup options?

0 Answers  


Categories