%let sex=F; %macro &sex; Proc print data=sashelp.class; Run; %mend; %&sex; I wrote one application but i am getting error . Please help to fix this ... View more

%let X=1; %let y=2; %let z=3; %let Asia=Harish; %let Asia1=bulli; %let bulli2=India; %let india3=Bharat; %put &&Asia&I;------- it gives bulli %put &&Asia&I&y;----- it doesn't give India How resolve above macro variable &&Asia&I&y ... View more

data ex1 ; input id $; cards ; 101 102 103 ; data ex2 ; input id $ ; cards ; 101 104 ;   proc compare data=ex1 compare=ex2  out=diff; run;   I wrote proc compare . How to create dataset for different values like dataset1: 101 103   data set2: 104 ... View more

%let name=ABCD efgh,ijkl mnop,qrst; %put. %scan(&name,1, ,); How to derive first delimiter string see below.. ABCD efgh ... View more

Ods html file="D:\class.html"; Proc report data=sashelp.class ; Run; Ods html close; If I run above program the html file will form . How to set password for that html file Note: If any other person wants to see that html file it sholud be asked password ... View more

%macro test1; data ex1 ; set sashelp.class; where sex='F' run; %mend ; %macro test2; data ex2 ; set sashelp.class; where sex='M' ; run; %mend ; %test1; %test2;   I wrote two macro applications If i run the 2 macro applications don't run second application because there is one syntax error in the first macro application. Note: If any error in the step don't run the next step ... View more

 i have sashelp.class    1 Alfred M 14 69.0 112.5 2 Alice F 13 56.5 84.0 3 Barbara F 13 65.3 98.0 4 Carol F 14 62.8 102.5 5 Henry M 14 63.5 102.5 6 James M 12 57.3 83.0 7 Jane F 12 59.8 84.5 8 Janet F 15 62.5 112.5 9 Jeffrey M 13 62.5 84.0 10 John M 12 59.0 99.5 11 Joyce F 11 51.3 50.5 12 Judy F 14 64.3 90.0 13 Louise F 12 56.3 77.0 14 Mary F 15 66.5 112.0 15 Philip M 16 72.0 150.0 16 Robert M 12 64.8 128.0  17 Ronald M 15 67.0 133.0 18 Thomas M 11 57.5 85.0 19 William M 15 66.5 112.0   but to keep every 3rd record sex variable keep in samll letter like see below dataset   1 Alfred M 14 69.0 112.5 2 Alice F 13 56.5 84.0 3 Barbara F 13 65.3 98.0 4 Carol f 14 62.8 102.5 5 Henry m 14 63.5 102.5 6 James m 12 57.3 83.0 7 Jane F 12 59.8 84.5 8 Janet F 15 62.5 112.5 9 Jeffrey M 13 62.5 84.0 10 John m12 59.0 99.5 11 Joyce f 11 51.3 50.5 12 Judy f 14 64.3 90.0 13 Louise F 12 56.3 77.0 14 Mary F 15 66.5 112.0 15 Philip M 16 72.0 150.0 16 Robert m 12 64.8 128.0 17 Ronald m 15 67.0 133.0 18 Thomas m 11 57.5 85.0 19 William M 15 66.5 112.0 ... View more

Data ex; Set sashelp.class; A=put(age,6.); B=put(age,best6.); Run; What is difference between A and B variable. Different between 6. And best6. ... View more