Extract left part of the string in SAS?

sas proc-sql
staq picture staq · Oct 14, 2014 · Viewed 29.8k times · Source

Is there a function SAS proc SQL which i can use to extract left part of the string.it is something similar to LEFT function sql server. in SQL I have left(11111111, 4) * 9 = 9999, I would like to something similar in SAS proc SQL. Any help will be appreciated.

Answer

vasja picture vasja · Oct 14, 2014

Had an impression you want to repeat the substring instead of multiply, so I'm adding REPEAT function just for the curiosity.

proc sql;
select 
  INPUT(SUBSTR('11111111', 1, 4), 4.) * 9            /* if source is char */
, INPUT(SUBSTR(PUT(11111111, 16. -L), 1, 4), 4.) * 9  /* if source is number */
, REPEAT(SUBSTR(PUT(11111111, 16. -L), 1, 4), 9)      /* repeat instead of multiply */
FROM SASHELP.CLASS (obs=1)
;
quit;

Related questions

Limiting results in PROC SQL

I am trying to use PROC SQL to query a DB2 table with hundreds of millions of records. During the development stage, I want to run my query on an arbitrarily small subset of those records (say, 1000). I've tried using …

Read More
How to convert date in SAS to YYYYMMDD number format

In test_1 table, the my_date field is a "DATE9." format. I would like to convert it to a pure numeric format (number length 8) which is of the form YYYYMMDD. I would also like to do this in a proc …

Read More
convert datetime to date in proc-sql sas

I'm trying to convert datetime22.3 variable to ddmmmyy10. in proc sql, this is giving me ****** in the output column. How can I get the correct values in the output column?

Read More