data have; input claimnumber code; cards; 101 0260 101 0261 101 0262 101 0865 102 0260 102 0261 102 0560 ; proc sql; create table want as select * from have where claimnumber not in (select claimnumber from have where code=0560); quit; ... View more

alternatively   Data ds2; Input id reading; Cards; 101 98 101 99 101 . 101 97 101 . 102 95 102 . 102 97 102 . 102 98 ; data want; set ds2(rename=(reading=reading2)); retain reading; by id; if first.id then reading=.; if reading2 ne . then reading=reading2; run; ... View more

try the below code   Data ds1; Input empid salary1 Salary2; Cards; 101 45000 65000 102 56000 54333 103 43000 67777 104 43000 65000 105 45000 56000 106 56000 56788 ; Run; proc sql; create table want as select * from ds1 union all select . as id , sum(salary1) as salary1, sum(salary2) as salary2 from ds1; quit; ... View more

do you have any character format for param that you can use   you need to create a format for param and use that as $sample.   Something like   proc format ; value sample 'Body Weight (kg)'='Body Weight (kg)'; run;   compute before gpxpage; line @3 param $sample.; endcomp; ... View more

I don't think there is any tool to convert the sas code to SQL we need to do that manually by coding in sql. ... View more

I updated the code as below, please try   compute before gpxpage; line @3 param; endcomp;   proc Report data=report split='^' missing nowd spanrows headline headskip ; column gpxpage paramn param avisitn col1 gpx2 col2 col3 col4 col5 col6 col7 ; define gpxpage /order order=internal "" noprint; define paramn /group noprint; define param /group noprint; define avisitn /group noprint; define gpx2 /group noprint; define col1 /&Header. order order=internal style(column)=[cellwidth=2.in font_face=&fontf font_size=&fontsz just=l asis=on] style(hdr)=[just=l asis=on] flow; define col2 /"Parameter" order order=data style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=l asis=on] style(hdr)=[just=l asis=on] flow; define col3 /"Statistics" order order=data style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=l asis=on] style(hdr)=[just=l asis=on] flow; define col4 /&Header1. order style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=c asis=on] style(hdr)=[just=c asis=on]; define col5 /&Header2. order style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=c asis=on] style(hdr)=[just=c asis=on]; define col6 /&Header3. order style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=c asis=on] style(hdr)=[just=c asis=on]; define col7 /&Header7. order style(column)=[cellwidth=1in font_face=&fontf font_size=&fontsz just=c asis=on] style(hdr)=[just=c asis=on]; break after gpxpage / page; compute before gpxpage; line @3 param; endcomp; compute after gpx2; line " "; endcomp; run; ... View more

I believe you are referring to global variables (Global Parameters) Please check the link below and refer to page 45 where there are steps to see the Global variables   https://support.sas.com/documentation/onlinedoc/ds/6.3/rtdmag.pdf      ... View more

Hi Aditya,   Please check my code below where I derived two new flags , flag1 and flag2 , flag1 is populated as 1 when there is a spelling mistake and flag2 is populated when there is no complete text like missing ADITYA, so please check and let me know if it meets your requirement.   data have; input text &:$200.; cards; ADTYA SASUSR EG SASUSER EG ; data want; set have; if prxmatch('m/ADITYA|SASUSER|EG/oi',text)=0 then flag1=1; if prxmatch('m/ADITYA SASUSER EG/oi',text)=0 then flag2=1; run; ... View more

yes we can do it. ... View more

Could you please try the below code   proc sort data=test; by treatment_group AgeGroup; run; proc freq data=test ; table group1*group2/missing; by treatment_group AgeGroup; run; ... View more