Diff=intck('week','31dec2018'd,'01jan2019'd,'c'); Diff1=intck('week','31dec2018'd,'01jan2019'd,'d'); If I use above code I am getting '0' for both variables . Can you explain? ... View more

country date amount ind 01MAR2019 345 ind 02MAR2019 . ind 03MAR2019 463 aus 01MAR2019 . aus 02MAR2019 357 aus 03MAR2019 500 usa 01MAR2019 345 usa 02MAR2019 222 usa 03MAR2019 463 I have above dataset like 3 groups one groups has first record value is missing so in that place value should be like last record value in that group and one group has somewhere values missing so assign first occurence value like see below dataset    country date amount ind 01MAR2019 345 ind 02MAR2019 345 ind 03MAR2019 463 aus 01MAR2019 500 aus 02MAR2019 357 aus 03MAR2019 500 usa 01MAR2019 345 usa 02MAR2019 222 usa 03MAR2019 463 ... View more

data ex1; name='aaa234bbb$&#^#*abrrtbbrtbbb'; output; name='harbbdgetbb' ; output; run;     I have one dataset like see above dataset so how to extract 'bb' wherever the string has only 'bb' word(onlu two letters) pick that position like see below dataset   name                                                   position aaa234bbb$&#^#*abrrtbbrtbbb             21 harbbdgetbb                                         4   ... View more

industry ashok industries pvt ltd sai industries limited a&b&c  industries Ltd. x&y&z industries ltd chaitinya industries Pvt. Ltd. (sathya sai industries) Co.Ltd sai harsha industries (Pvt.Ltd)   if you observe above dataset every record has one extenstion name like 'pvt ltd', 'ltd','limited' so  how can we remove that extenstion name and '%' like see beow dataset    industry ashok industries% sai industries% a&b&c  industries% x&y&z industries% chaitinya industries% (sathya sai industries)% sai harsha industries% ... View more

how to sum all numeric variables in sashelp.class write do loop in sql    ... View more

proc contents data=sashelp.class noprint out=s(keep=name type) ;run; proc sort data=s;by type ;run; proc sql ; select strip(name)||'1',name into:ne1-:ne5,:n1-:n5 from s ; quit; %put &n1 &n2 &n3 &n4 &n5 &ne1 &ne2 &ne3 &ne4 &ne5; %macro copy1; %do i=1 %to 5 ; data ex1 ; set sashelp.class ; &&ne&i.=&&n&i.; run; %end; %mend; %copy1 ;     i want to create 5 new variables like age1,name1,sex1,height1,weight1 so  i wrote one applications but i am getting only one variable  what is the issue in that application ... View more

Obs Name Sex Age Height Weight 1 Alfred M 14 69.0 . 2 Alice F 13 56.5 . 3 Barbara F 13 65.3 . 4 Carol F 14 62.8 . 5 Henry M 14 63.5 . 6 James M 12 57.3 . 7 Jane F 12 59.8 . 8 Janet F 15 62.5 . 9 Jeffrey M 13 62.5 . 10 John M 12 59.0 . 11 Joyce F 11 . . 12 Judy F 14 64.3 . 13 Louise F 12 56.3 . 14 Mary F 15 66.5 . 15 Philip M 16 72.0 . 16 Robert M 12 64.8 . 17 Ronald M 15 67.0 . 18 Thomas M 11 . . 19 William M 15 66.5 .   i want to make list out the missing variables list like  if you take weight variable all row are missing so that type of missing varibles i want to make out (dont height sex varibles) ... View more

Name Sex Age Height Weight seq Alice F 13 56.5 84 1 Barbara F 13 65.3 98 2 Carol F 14 62.8 102.5 3 Jane F 12 59.8 84.5 4 Janet F 15 62.5 112.5 5 Joyce F 11 51.3 50.5 6 Judy F 14 64.3 90 7 Louise F 12 56.3 77 8 Mary F 15 66.5 112 9 Alfred M 14 69 112.5 1 Henry M 14 63.5 102.5 2 James M 12 57.3 83 3 Jeffrey M 13 62.5 84 4 John M 12 59 99.5 5 Philip M 16 72 150 6 Robert M 12 64.8 128 7 Ronald M 15 67 133 8 Thomas M 11 57.5 85 9 William M 15 66.5 112 10     how to generate seq number in sql sex group wise ... View more