Follow Our FB Page << >> 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


You can use the SUBSTRN function to Read the Character

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