Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how to read character value without using substr function in
sas ?

Answers were Sorted based on User's Feedback



how to read character value without using substr function in sas ?..

Answer / smit

Scan function can be used

SCAN(string, count<,charlist <,modifiers>>)

Is This Answer Correct ?    2 Yes 0 No

how to read character value without using substr function in sas ?..

Answer / karthick_mrs

any answer will be appreciated.

Is This Answer Correct ?    3 Yes 4 No

how to read character value without using substr function in sas ?..

Answer / vaibhav wadhera

Hey

You can use the SUBSTRN function to Read the Character
Value.....


ALso it will be more clear that what you want to do after
reading character value...

Is This Answer Correct ?    1 Yes 4 No

Post New Answer



More SAS Interview Questions

Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX.

0 Answers  


Explain data_null_?

0 Answers  


How can I remove header from output data set?

0 Answers  


what are input dataset and output dataset options? : Sas programming

0 Answers  


Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190

3 Answers  






Could you please answers for this. 1.Code the tables statement for a single-level (most common) frequency. 2.Code the tables statement to produce a multi-level frequency.

2 Answers  


If a variable contains letters or special characters, can it be numeric data type?

0 Answers  


what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?

3 Answers  


Name statements that function at both compile and execution time.

7 Answers   Accenture,


How to get part of string form the source string without using sub string function in SAS?

3 Answers  


Difference b/n proc means and proc summary procedures?

3 Answers   Accenture,


What is difference between sas rename and lable?

4 Answers  






Categories