HI All, i have below mentioned data. data tab1; input custid$ @6 saledate mmddyy10. @17 variety $9. @26 quantity ; format saledate mmddyy10.; datalines; 240w 02-07-2003 ginger 120 240w 02-07-2003 protea 180 356w 02-08-2003 heliconia 60 356w 02-08-2003 anthurium 300 188r 02-11-2003 ginger 24 188r 02-11-2003 anthurium 24 240w 02-12-2003 heliconia 48 240w 02-12-2003 protea 48 356w 02-12-2003 'ginger' 240 ; run; i made below macro for same. %macro new (flowertype=); proc print data=tab1; where variety ="&flowertype" & custid="&id"; run; %mend; %new (flowertype=ginger); Can anyone tell me how to make macro of dates. Like i make flowertype and its ginger when i will mention any flowertype in macro then it will give me print. Same way i want to make macro of Date. if i will mention particular date then macro will show me the result of that date only. ... View more

Hi Team, Can anyone tell me how to save data of proc append. Like i have below mentioned data  data app; input amt name $ age; cards; 1000 abc 21 2000 def 22 3000 ghi 23 4000 jkl 24 ; run; data app1; input name $ age bonus; cards; jkl 24 1000 mno 25 2000 ; run;   then i run proc appned function like below.   proc append base=app data=app1 force; run; proc print; run;   i want to save the output in my library or in work library. Its not for proc append only. if i have querires of proc tabulate then how can i save the data for these procedures. ... View more

Hi, I have huge data with variable name HighPrice. How can i find highest and lowest number from the data. Have data like given below   HighPrice 568.45 571 604.3 619.35 612.7 629 651 650.7 652 678.9 689.9 665 664.4 666.8 627.5 619.4 627.25 650.8 663.95 642 631.9 ... View more