Please try   data Namen ; input Name &$35.; position=prxmatch('m/und|oder/i',strip(name)); name2=substr(strip(name),1,position-1); datalines; Name1 und Name2 und Name3 und Name4 oder ; run; ... View more

May be if you post the sample data and expected output it would help to get better responses. However I will try   You can derive the continent based on the country something as below , alternatively you can use the format if we can know all countries and respective continents   If country='Germany' then continent='Europe'; else if country='China' then continent='Asia'; etc.,   ... View more

Ideally it should not give error, could you please check the if the macro variable first_id is having the values Please execute below code and check if it resolves to any value   %put &first_id; ... View more

Please try   data T1; input ID dischargeDT:mmddyy10.; format dischargeDT date9.; cards; 101 08/01/2019 ; data T2; input ID DATE:mmddyy10.; format DATE date9.; cards; 101 06/16/2019 101 07/25/2019 101 08/01/2019 101 09/05/2019 ; proc sql; create table want as select a.*,b.dischargeDT from t2 as a right join t1 as b on a.id=b.id and a.date>=b.dischargeDT or (a.date)>=(b.dischargeDT-7); quit;   ... View more

Please try the below code as an example   proc gplot data=sashelp.class; plot height*weight; run; ... View more

We can use the proc sql to pull the variables into a macro variable as below ad then use this macro variable in place of the variables in array   proc sql; select name into :vars separated by ' ' from dictionary.columns where libname='WORK' and memname='HAVE'; quit;   ... View more

Please try this untested code   data want; set have; array vars(*) A B C D F ; do i = 1 to dim(vars); if vars(i) ne . and vars(i)>0.8 output; end; run; ... View more

You have posted the sample data but did not post what you are expecting the output as, the two methods data along with the count is there with this data want you want to do is not clear to me ... View more

Could you please let us know what you want output with this data. ... View more

Please try the below code proc format; value gen 1='Male' 2='Female'; value $ses 'L'='Low' 'M'='Medium' 'H'='High'; value age low-20='<=20' 21-40='21-40' 41-high='41 and older'; run; data ques2; input id$ gender ses$ drug$ age; format gender gen. ses $ses.; if drug in ('A' 'B' 'C' 'F' ) then COST='LOW '; else COST='HIGH'; label ses='Socioeconomic Status' drug='Drug Group' age='Age of Subject'; cards; 001 1 L B 15 002 2 M Z 35 003 2 H F 76 004 1 L C 21 005 2 H . 58 ; proc print data=ques2; run; proc freq data=ques2; table ses; run; proc freq data=ques2; table cost; run; proc freq data=ques2; table age; format age age.; run; ... View more

Please try the below code   data have; input text&$200.; string=tranwrd(lowcase(text),'data','#'); cards; Sports data is sufficient Basketball Players Data is listed on the Olympic data Soccer data and swimming data are not found in the Olympic data starting in the next month ; proc sort data=have; by string; run; data want(where=(count(string,'#')=i)); length new $100.; set have; by string; do i = 1 to count(string,'#'); new=catx(' ', new, scan(scan(string,i,'#'),-1,' ')); output; end; run; ... View more