np_info.xlsx is an Excel file A libname statement creates a reference to a directory on the OS to access SAS Data Files A quick search and Using the Import Data Utility in SAS Studio Of course this assumes you are using SAS Studio, there are other methods Personally I'd export the Excel file as CSV and then read it in that way, as reading raw data is what I know best, hence the quickest solution for me. ... View more

PROC FREQ DATA=sashelp.class; TABLES sex*age / OUTPCT out=OUTPCT; RUN; You mean like that? ... View more

I think you are going to need to explain this more clearly    /*if birthnum 2 and 3 or 2 and 6*/ How can a single observation (row) have a variable (birthnum) with values 2 and 3    ... View more

You might want to consider using PROC FORMAT and PROC FREQ to do this     /* Create some sample data */ data bulk ; set sashelp.class ; do i=1 to 5 ; output ; end ; run ; /* Creatge a custom format */ /* https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p1xidhqypi0fnwn1if8opjpqpbmn.htm */ proc format ; value age 11-12 = "11-12" 13-14 = "13-14" 15-high = "Over 14" ; run ; proc sql ; /* counts unformatted */ create table counts as select age, count(*) from bulk group by age ; ; /* counts formatted */ create table countsF as select putn(age,"age.") as ageF , count(*) from bulk group by ageF ; ; run ; /* If you just want counts, then PROC FREQ might be a better option */ /* https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/procstat/procstat_freq_toc.htm */ proc freq data=bulk noprint ; format age age. ; table age / out=freqOut ; run ;   ... View more

Here's another Perl Regular Expression example, I basically hacked this example in the documentation   data have; length id $10 dcode $48; input id$ dcode$ &; datalines; 1 I410 J332 2 C450 I412 3 I413 R789 I412 I4123 4 R281 I519 I413 I51698 5 O603 C351 ; run; data want ; retain re 0 ; if _n_=1 then do ; re=prxparse('/I41\w*|I51\w*/') ; end ; set have ; x=prxmatch(re,dcode) ; start=1 ; stop=length(dcode) ; call prxnext(re,start,stop,dcode,position,length) ; do while(position>0) ; found=substr(dcode,position,length) ; call prxnext(re,start,stop,dcode,position,length) ; put found= ; output ; end ; run ; ... View more

If you treat the variables as numeric then it is simple enough   data mydata; input v1 v2 ; if mod(v1,10)=mod(v2,10)+1 then sems=1 ; else sems=0 ; datalines; 131 341 214 322 364 112 114 215 213 236 226 114 237 934 995 994 ; run ; I did notice you didn't have a records where the 3rd digit of v2 + 1 is equal to the 3rd digit of v1 so I added the last data line: 995 994  3rd digit of v2 is 4 adding 1 gives you 5 which is the 3rd digit of v1 I have questions like what happens when the 3rd digit of v2 is 9?   ... View more

IP_Admit shouldn't be a missing value (. in SAS for numeric)  it can only be 0 or 1   See following example log 1078 data _null_ ; 1079 do vd = "05", "06", "07" ; 1080 1081 ipa=0 ; 1082 if vd in:("06","07") then ipa=1 ; 1083 put _all_ ; 1084 end ; 1085 run ; vd=05 ipa=0 _ERROR_=0 _N_=1 vd=06 ipa=1 _ERROR_=0 _N_=1 vd=07 ipa=1 _ERROR_=0 _N_=1 NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds It is difficult to debug based on 2 lines of code, no data and no log Can you provide a fuller explanation of the issue ... View more

Is this what you are attempting to do? Note I changed your xx dataset, as I suspect you want a count of the distinct values  ie Alpha count = 5 _blank_ count = 3 in my example   data have;data xx; do i=1 to 5 ; name= "alpha"; output; end ; do i=1 to 3 ; name=" "; output; end ; run; proc sql; create table xx1 as select distinct name, count(*) from xx group by name ; quit;   If this isn't want you are looking for can you provide an example with a have and want dataset (ie what you have, and what you want after processing) Also provide more detailed explanation of what you are attempting to do  ... View more