It looks like a student homework or a interview question? %let n=3; data nth_occurence; string="abc12abc56abc" ; p=0; do n=1 to &n.; p=find(string,'abc','i',p+1); end; drop n; run; ... View more

As @StatDave said , delete option NOINT , you would get the same result from PROC FREQ . ... View more

I got no problem with your code. But you could also try this alternative code . options parmcards=x; filename x temp; parmcards; 1 A text here text here 2 B text here text here text here text here text here text here 3 C text here text here text here text here text here text here text here text here text here text here text here text here text here text here text here text here text here text here xx 4 D text here ; data test; infile x lrecl=32767 truncover; input ord 1-2 _NAME_ $ 4-5 PARAMETER $ 7-200; run; ... View more

Of course, You can. /* Yes. You can. You need to save these positions firstly. */ data sheet1; input a $; cards; 123 234 AAA ; data sheet2; input a b c d $; cards; 1 2 3 AAA 1 2 3 910 1 2 3 123 1 2 3 234 ; data _null_; set sheet2; call symputx(cats('_',d),_n_+1); run; ods excel file='c:\temp\temp.xlsx'; ods excel options(sheet_name='Sheet1'); proc report data=sheet1 nowd; define a/display; compute a; urlstring= cats("#Sheet2!D",symget(cats('_',a))); call define(_col_,'URL',urlstring); call define(_col_,'style','style={textdecoration=underline color=blue}'); endcomp; run; ods excel options(sheet_name='Sheet2'); proc report data=sheet2 nowd; run; ods excel close;   ... View more

If you are using JOURNAL style,you could pad some white blanks to mimic this kind of style .   options nonumber nodate; ods rtf file='c:\temp\temp.rtf' style=journal; title; ods escapechar='~'; proc report data=sashelp.class nowd style={outputwidth=100%}; columns name ('~S={borderbottomcolor=black borderbottomwidth=2}(N=41) (N=44)' ('~S={borderbottomcolor=black borderbottomwidth=2}Overall Post-Baseline' sex age height weight)) ; run; ods rtf close;     ... View more

You need to use ANCHOR= option to produce URL in PDF . LIke : ods pdf anchor="AdverseEvent" startpage=now ; ods proclabel="AdverseEvent"; title j=l "AdverseEvent"; proc report ........ ... View more

Of course.you can. proc sql; create table report as select 1 as id1,'GENDER' as a length=40,Clinic, 1 as id2,put(Gender,$gender.) as b length=40, 1 as id3,(select count(distinct id) from have where Clinic=a.Clinic and Gender=a.Gender and cost>0) as c format=comma20., 1 as id4,calculated c/(select count(distinct id) from have where Clinic=a.Clinic and cost>0) as d format=percent8.2, 1 as id5,sum(cost) as e format=dollar20., 1 as id6,sum(cost)/(select sum(cost) from have where Clinic=a.Clinic) as f format=percent8.2 from have as a group by Clinic,Gender union all select 2 as id1,'ETHNICITY' as a,Clinic, 2 as id2,put(Hispanic,$eth.) as b, 2 as id3,(select count(distinct id) from have where Clinic=a.Clinic and Hispanic=a.Hispanic and cost>0) as c, 2 as id4,calculated c/(select count(distinct id) from have where Clinic=a.Clinic and cost>0) as d format=percent8.2, 2 as id5,sum(cost) as e format=dollar20., 2 as id6,sum(cost)/(select sum(cost) from have where Clinic=a.Clinic) as f format=percent8.2 from have as a group by Clinic,Hispanic ; quit; ... View more

Another way is using PROC CORRESP,but it is more suited to non-Likert scale. Check its example . ... View more

Yes. It is a XML file ,not CSV file. Using XMLV2 engine to import it.   %LET reporter=IN; data _null_; start="2019"; end="2024"; reporter="&reporter"; length urltest $5000 ; urltest = cats ('http://dataservices.imf.org/REST/SDMX_xml.svc/CompactData/IFS/M.' ,reporter ,'.PCPI_IX.?startPeriod=' ,start ,'&endPeriod=' ,end ,''); call symputx('urltest',quote(trim(urltest),"'")); put urltest $char.; run; filename out5 "c:\temp\cpi.xml"; proc http url=&urltest method="get" out=out5; run; filename x temp; libname x xmlv2 "c:\temp\cpi.xml" xmlmap=x automap=replace; proc copy in=x out=work;run;   ... View more

Answer is Yes. Did you check PROC PRINQUAL and its examples ?       ... View more

https://blogs.sas.com/content/iml/2014/11/07/distribution-of-blood-types.html ... View more

Check PROC PRINQUAL and its examples in DOC . ... View more

data example; input SEGM_DATE datetime18. CLIENT_ID :$9. AVG_WEIGHT; format SEGM_DATE datetime20.; datalines; 01MAR2012:00:00:00 1-ET-1500 8 01APR2012:00:00:00 1-ET-1500 10 01JUN2012:00:00:00 1-ET-1500 13 01JAN2012:00:00:00 2-ET-1500 12 01JUN2012:00:00:00 2-ET-1500 18 ; proc summary data=example nway; class CLIENT_ID; var SEGM_DATE; output out=temp min=min max=max; run; data temp2; set temp; do i=0 to intck('dtmonth',min,max); SEGM_DATE=intnx('dtmonth',min,i);output; end; drop i; keep CLIENT_ID SEGM_DATE; format SEGM_DATE datetime20.; run; proc sql; create table want1 as select a.*,b.AVG_WEIGHT from temp2 as a natural left join example as b order by CLIENT_ID,SEGM_DATE; quit; data want2; set want1; AVG_WEIGHT_month_ago =lag(AVG_WEIGHT); if CLIENT_ID ne lag(CLIENT_ID) then call missing(AVG_WEIGHT_month_ago); AVG_WEIGHT_2month_ago=lag2(AVG_WEIGHT); if CLIENT_ID ne lag2(CLIENT_ID) then call missing(AVG_WEIGHT_2month_ago); run; ... View more

You need to point the START and END position by PRX. Like: data want; set have; new_dx1 = prxmatch('/^(F[0-9]{2,4}|T[0-9]{4,5}|R[0-9]{5}|G312)$/', strip(dx1)); run; ... View more