<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gd="http://schemas.google.com/g/2005"><id>tag:blogger.com,1999:blog-7958828565254404797.post819211436983772753..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: SAS Macros Made Easy</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://www.listendata.com/feeds/comments/default'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><link rel='next' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default?start-index=26&amp;max-results=25'/><author><name>Deepanshu Bhalla</name><uri>http://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>35</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2079429676145880865</id><published>2023-03-14T03:21:50.868-07:00</published><updated>2023-03-14T03:21:50.868-07:00</updated><title type='text'>%MACRO ABC;&#xa;PROC SQL;&#xa;CREATE TABLE PAV AS&#xa;SELECT D...</title><content type='html'>&lt;br /&gt;%MACRO ABC;&lt;br /&gt;PROC SQL;&lt;br /&gt;CREATE TABLE PAV AS&lt;br /&gt;SELECT DISTINCT (MAKE)FROM SASHELP.CARS&lt;br /&gt;QUIT;&lt;br /&gt;%MEND;&lt;br /&gt;&lt;br /&gt;%ABC;&lt;br /&gt;&lt;br /&gt;%LET A=%SYSEVALF(&amp;amp;ABC*&amp;amp;2.5);&lt;br /&gt;&lt;br /&gt;ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand&lt;br /&gt;       is required. The condition was: &amp;amp;ABC*&amp;amp;2.5&lt;br /&gt;&lt;br /&gt;THERE ARE CHARACTER VALUES IN CARS DATASET SO CALCULATIONS R NOT POSSIBLE&lt;br /&gt;&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2079429676145880865'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2079429676145880865'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1678789310868#c2079429676145880865' title=''/><author><name>Pavankalyangoud</name><uri>https://www.blogger.com/profile/17273243959040160359</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-766455118"/><gd:extendedProperty name="blogger.displayTime" value="March 14, 2023 at 3:21 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5842030832800266157</id><published>2023-01-20T12:05:22.878-08:00</published><updated>2023-01-20T12:05:22.878-08:00</updated><title type='text'>No</title><content type='html'>No</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/5842030832800266157'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/5842030832800266157'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1674245122878#c5842030832800266157' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/8739422887487611495'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="January 20, 2023 at 12:05 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8739422887487611495</id><published>2023-01-20T11:53:16.477-08:00</published><updated>2023-01-20T11:53:16.477-08:00</updated><title type='text'>@Deepanshu Do you know Amit Kumar/Sir? </title><content type='html'>@Deepanshu Do you know Amit Kumar/Sir? </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/8739422887487611495'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/8739422887487611495'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1674244396477#c8739422887487611495' title=''/><author><name>pankaj ray</name><uri>https://www.blogger.com/profile/13663539711388871327</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='24' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjR9A257l1VZDpF5Gu2Erj6lVNRtHvPDqhUqSc0mV7bu6v0PX35o7ucynPyyZ_FuR7atXaCRcVegVmk2tPTQfA6w9fu5VQSCGiOkWSjBvNg4SFqLsjpbFLg_Ft_EFKxZsk/s220/335576_256791454361571_100000921558247_770833_892666505_o.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1392300290"/><gd:extendedProperty name="blogger.displayTime" value="January 20, 2023 at 11:53 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5917083352454606666</id><published>2021-07-20T23:37:17.127-07:00</published><updated>2021-07-20T23:37:17.127-07:00</updated><title type='text'>PROC sql;&#xa;create table made as&#xa;select distinct(cou...</title><content type='html'>PROC sql;&lt;br /&gt;create table made as&lt;br /&gt;select distinct(count(*)) as make &lt;br /&gt;from sashelp.cars;&lt;br /&gt;quit;&lt;br /&gt;&lt;br /&gt;data _null_;&lt;br /&gt;set made;&lt;br /&gt;call symput(&amp;quot;make&amp;quot;, make);&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;%put &amp;amp;make;&lt;br /&gt;&lt;br /&gt;data new;&lt;br /&gt;newmake=%sysevalf(&amp;amp;make*2.5);&lt;br /&gt;run;&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/5917083352454606666'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/5917083352454606666'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1626849437127#c5917083352454606666' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="July 20, 2021 at 11:37 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3562057365712583367</id><published>2021-06-28T23:03:40.837-07:00</published><updated>2021-06-28T23:03:40.837-07:00</updated><title type='text'>Hi Everyone can anyone help me where from I can le...</title><content type='html'>Hi Everyone can anyone help me where from I can learn SAS Base/Advanced programming?&lt;br /&gt;I need to work on macros as well aslo...it is required in current work.&lt;br /&gt;&lt;br /&gt;If anyone have pdf of sas advance book please share with me.&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/3562057365712583367'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/3562057365712583367'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1624946620837#c3562057365712583367' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/02434815936016308021</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-918501452"/><gd:extendedProperty name="blogger.displayTime" value="June 28, 2021 at 11:03 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-919835980112159634</id><published>2020-11-22T07:10:06.773-08:00</published><updated>2020-11-22T07:10:06.773-08:00</updated><title type='text'>proc sql;&#xa; Select count(distinct make) into: make&#xa;...</title><content type='html'>proc sql;&lt;br /&gt; Select count(distinct make) into: make&lt;br /&gt; From sashelp.cars;&lt;br /&gt;quit;&lt;br /&gt;run;&lt;br /&gt;option symbolgen;&lt;br /&gt;%let make2 = %sysevalf(&amp;amp;make * 2.5);&lt;br /&gt;%put &amp;amp;make &amp;amp;make2;&lt;br /&gt;38 95&lt;br /&gt;Thank you for detailed article with macro details not found in other resources. Kudos on your site filled with information on SAS, R, and Python. Will be a frequent visitor here.&lt;br /&gt;&lt;br /&gt;Vladimir</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/919835980112159634'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/919835980112159634'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1606057806773#c919835980112159634' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/08665926431769810146</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1386170948"/><gd:extendedProperty name="blogger.displayTime" value="November 22, 2020 at 7:10 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-694492229585664579</id><published>2019-11-07T23:41:16.211-08:00</published><updated>2019-11-07T23:41:16.211-08:00</updated><title type='text'>you&amp;#39;re doing such a great job Deepanshu. your ...</title><content type='html'>you&amp;#39;re doing such a great job Deepanshu. your whole material is better than any other source that is available online.This blog helped me get a job. Forever greatfull!! Thank you</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/694492229585664579'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/694492229585664579'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1573198876211#c694492229585664579' title=''/><author><name>Bharat Matakijai</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="November 7, 2019 at 11:41 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2482913091681704818</id><published>2019-10-01T02:35:56.979-07:00</published><updated>2019-10-01T02:35:56.979-07:00</updated><title type='text'>When you are creating macros mac1 to mac&amp;amp;mx1 y...</title><content type='html'>When you are creating macros mac1 to mac&amp;amp;mx1 you need to sort based on sequence so that you will get the required output.&lt;br /&gt;please replace the below code after creating the &amp;amp;mx1 macro variable&lt;br /&gt;&lt;br /&gt;select distinct(macroname) into :mac1 - :mac&amp;amp;mx1 from imptbase.data_manipulation where filename = &amp;quot;&amp;amp;&amp;amp;file&amp;amp;i&amp;quot; order by sequence;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2482913091681704818'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2482913091681704818'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1569922556979#c2482913091681704818' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/7371413751195105159'/><author><name>Anvesh Venishetty</name><uri>https://www.blogger.com/profile/11719096093810528721</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1476367663"/><gd:extendedProperty name="blogger.displayTime" value="October 1, 2019 at 2:35 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1897022445496602604</id><published>2019-08-13T06:01:42.366-07:00</published><updated>2019-08-13T06:01:42.366-07:00</updated><title type='text'>By simply putting d after quotation mark in the wh...</title><content type='html'>By simply putting d after quotation mark in the where clause.&lt;br /&gt;E.g. where saledate = “&amp;amp;date”d ;&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/1897022445496602604'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/1897022445496602604'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1565701302366#c1897022445496602604' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/8161833467781876396'/><author><name>Arjun Singh Bisht</name><uri>https://www.blogger.com/profile/05227876560520743125</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1030561258"/><gd:extendedProperty name="blogger.displayTime" value="August 13, 2019 at 6:01 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2478290630153406000</id><published>2019-07-30T09:26:00.513-07:00</published><updated>2019-07-30T09:26:00.513-07:00</updated><title type='text'>what rubbish !! program for iterative %do not work...</title><content type='html'>what rubbish !! program for iterative %do not working</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2478290630153406000'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2478290630153406000'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1564503960513#c2478290630153406000' title=''/><author><name>karan</name><uri>https://www.blogger.com/profile/01782021056385623652</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1547704750"/><gd:extendedProperty name="blogger.displayTime" value="July 30, 2019 at 9:26 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8859622998920533184</id><published>2019-05-21T14:58:21.490-07:00</published><updated>2019-05-21T14:58:21.490-07:00</updated><title type='text'>proc sort data=abcd nodup out=pp;&#xa;by _all_; &#xa;run;&#xa;...</title><content type='html'>proc sort data=abcd nodup out=pp;&lt;br /&gt;by _all_; &lt;br /&gt;run;&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/8859622998920533184'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/8859622998920533184'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1558475901490#c8859622998920533184' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/7506450133908027556'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/16795565839020970116</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-462745044"/><gd:extendedProperty name="blogger.displayTime" value="May 21, 2019 at 2:58 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2439012995122891988</id><published>2019-05-02T23:10:25.220-07:00</published><updated>2019-05-02T23:10:25.220-07:00</updated><title type='text'>&amp;quot;Calculate distinct number of categories (lev...</title><content type='html'>&amp;quot;Calculate distinct number of categories (levels) in variable make in dataset sashelp.cars and store it in a macro variable and later multiply the macro variable by 2.5&amp;quot; please check code below&lt;br /&gt;&lt;br /&gt;proc sql noprint;&lt;br /&gt;select count(distinct make) into:makecnt from sashelp.cars;&lt;br /&gt;quit;&lt;br /&gt;&lt;br /&gt;%put %sysevalf(&amp;amp;makecnt*2.5);&lt;br /&gt;&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2439012995122891988'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2439012995122891988'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1556863825220#c2439012995122891988' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="May 2, 2019 at 11:10 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4485594322889372181</id><published>2019-01-14T07:21:40.694-08:00</published><updated>2019-01-14T07:21:40.694-08:00</updated><title type='text'>hi..i&amp;#39;am unable to run macros in SAS studio..c...</title><content type='html'>hi..i&amp;#39;am unable to run macros in SAS studio..can any one help?? </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/4485594322889372181'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/4485594322889372181'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1547479300694#c4485594322889372181' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/07046998794738111851</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1247493842"/><gd:extendedProperty name="blogger.displayTime" value="January 14, 2019 at 7:21 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1979481186006573347</id><published>2018-08-15T06:17:07.599-07:00</published><updated>2018-08-15T06:17:07.599-07:00</updated><title type='text'>proc sql;&#xa;select distinct make into :k1 from sashe...</title><content type='html'>proc sql;&lt;br /&gt;select distinct make into :k1 from sashelp.cars;&lt;br /&gt;quit;&lt;br /&gt;%put &amp;amp;k1*2.5;&lt;br /&gt;&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/1979481186006573347'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/1979481186006573347'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1534339027599#c1979481186006573347' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2053795780365089502'/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/13796183407496450098</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-226644061"/><gd:extendedProperty name="blogger.displayTime" value="August 15, 2018 at 6:17 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2053795780365089502</id><published>2018-08-15T06:14:28.904-07:00</published><updated>2018-08-15T06:14:28.904-07:00</updated><title type='text'>select distinct make into :k1 from sashelp.cars;&#xa;%...</title><content type='html'>select distinct make into :k1 from sashelp.cars;&lt;br /&gt;%put &amp;amp;k1*2.5;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2053795780365089502'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2053795780365089502'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1534338868904#c2053795780365089502' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/13796183407496450098</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-226644061"/><gd:extendedProperty name="blogger.displayTime" value="August 15, 2018 at 6:14 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6326497785941821391</id><published>2018-08-04T11:07:40.236-07:00</published><updated>2018-08-04T11:07:40.236-07:00</updated><title type='text'>Good Job. Very useful blog :)</title><content type='html'>Good Job. Very useful blog :)</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/6326497785941821391'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/6326497785941821391'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1533406060236#c6326497785941821391' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/02495398171844750868</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1143885175"/><gd:extendedProperty name="blogger.displayTime" value="August 4, 2018 at 11:07 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1906195165204225257</id><published>2018-04-08T14:23:22.641-07:00</published><updated>2018-04-08T14:23:22.641-07:00</updated><title type='text'>i have a question,&#xa;&#xa;suppose we have a data set con...</title><content type='html'>i have a question,&lt;br /&gt;&lt;br /&gt;suppose we have a data set consisting of the monthly income of a group of people over the years and we have to extract the income data of every third month of the people. how it could be done using macros?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/1906195165204225257'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/1906195165204225257'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1523222602641#c1906195165204225257' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/02229864074863255316</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1275077914"/><gd:extendedProperty name="blogger.displayTime" value="April 8, 2018 at 2:23 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2227531603488766392</id><published>2018-01-03T21:13:13.103-08:00</published><updated>2018-01-03T21:13:13.103-08:00</updated><title type='text'>It is very helpful. Thank you so much!&#xa;&#xa;/* 1. crea...</title><content type='html'>It is very helpful. Thank you so much!&lt;br /&gt;&lt;br /&gt;/* 1. create macro test */&lt;br /&gt;&lt;br /&gt;%macro test (input=, ivar=, out=);&lt;br /&gt;proc sort data=&amp;amp;input out=sort;&lt;br /&gt;by &amp;amp;ivar;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;data c;&lt;br /&gt;set sort;&lt;br /&gt;by &amp;amp;ivar;&lt;br /&gt;if first.&amp;amp;ivar;&lt;br /&gt;run;&lt;br /&gt;&lt;br /&gt;proc means data=c;&lt;br /&gt;output out=&amp;amp;out N=num;&lt;br /&gt;run;&lt;br /&gt;%mend;&lt;br /&gt;&lt;br /&gt;/* 2. call macro test */&lt;br /&gt;&lt;br /&gt;%test(input=sashelp.cars, ivar=make, out=m);&lt;br /&gt;&lt;br /&gt;/* 3. proc sql */&lt;br /&gt;&lt;br /&gt;proc sql;&lt;br /&gt;select num into: var1 separated by &amp;#39;,&amp;#39;&lt;br /&gt;from m;&lt;br /&gt;quit;&lt;br /&gt;&lt;br /&gt;%put &amp;amp;var1;&lt;br /&gt;&lt;br /&gt;/* It shows:38 */&lt;br /&gt;&lt;br /&gt;%let x=&amp;amp;var1*2.5;&lt;br /&gt;&lt;br /&gt;%let y=%sysevalf(&amp;amp;x);&lt;br /&gt;&lt;br /&gt;%put &amp;amp;y;&lt;br /&gt;&lt;br /&gt;/* It shows: 95 */&lt;br /&gt;&lt;br /&gt;/* End */</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2227531603488766392'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/2227531603488766392'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1515042793103#c2227531603488766392' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/11776278708435715601</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1822139923"/><gd:extendedProperty name="blogger.displayTime" value="January 3, 2018 at 9:13 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7506450133908027556</id><published>2017-10-15T04:39:09.963-07:00</published><updated>2017-10-15T04:39:09.963-07:00</updated><title type='text'>data abcd;&#xa;input Acct CU_IND TRNS_CNT TRNS_AMT SUM...</title><content type='html'>data abcd;&lt;br /&gt;input Acct CU_IND TRNS_CNT TRNS_AMT SUM;&lt;br /&gt;cards;&lt;br /&gt;1 0 0 0 0 &lt;br /&gt;1 1 5 50 55&lt;br /&gt;1 1 5 50 55&lt;br /&gt;1 0 0 0 0 &lt;br /&gt;1 1 2 100 102&lt;br /&gt;1 1 2 100 102&lt;br /&gt;2 0 0 0 0&lt;br /&gt;2 0 0 0 0&lt;br /&gt;2 0 0 0 0&lt;br /&gt;2 1 1 250 251&lt;br /&gt;2 1 1 250 251&lt;br /&gt;2 1 1 250 251&lt;br /&gt;3 1 2 250 252&lt;br /&gt;3 1 2 200 202&lt;br /&gt;3 0 0 0 0&lt;br /&gt;3 0 0 0 0&lt;br /&gt;3 1 1 850 851&lt;br /&gt;3 1 1 850 851&lt;br /&gt;3 1 1 850 851&lt;br /&gt;4 1 1 90 91&lt;br /&gt;4 1 1 90 91&lt;br /&gt;;&lt;br /&gt;run;&lt;br /&gt;required output is&lt;br /&gt;1 1 5 50 55&lt;br /&gt;1 1 2 100 102&lt;br /&gt;2 1 1 250 251&lt;br /&gt;3 1 1 850 851&lt;br /&gt;4 1 1 90 91</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/7506450133908027556'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/7506450133908027556'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1508067549963#c7506450133908027556' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="October 15, 2017 at 4:39 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1407163357341598590</id><published>2017-09-14T05:39:38.829-07:00</published><updated>2017-09-14T05:39:38.829-07:00</updated><title type='text'>The count is 95.</title><content type='html'>The count is 95.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/1407163357341598590'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/1407163357341598590'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1505392778829#c1407163357341598590' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="September 14, 2017 at 5:39 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4461475199832897305</id><published>2017-08-20T21:11:00.775-07:00</published><updated>2017-08-20T21:11:00.775-07:00</updated><title type='text'>the code which you have written must be like this ...</title><content type='html'>the code which you have written must be like this : &lt;br /&gt;&lt;br /&gt;%macro Subset (Dset1=,Dset= ,var= );&lt;br /&gt;data &amp;amp;Dset1;&lt;br /&gt;set &amp;amp;Dset;&lt;br /&gt;where Location=&amp;quot;&amp;amp;var&amp;quot;;&lt;br /&gt;run;&lt;br /&gt;%mend;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;%Subset(Dset1=BANK1,Dset=Test,var=Bank);</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/4461475199832897305'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/4461475199832897305'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1503288660775#c4461475199832897305' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/4756959764291987023'/><author><name>Karan</name><uri>https://www.blogger.com/profile/01473246377228396390</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1870916039"/><gd:extendedProperty name="blogger.displayTime" value="August 20, 2017 at 9:11 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4437472673600477655</id><published>2017-08-20T21:08:13.908-07:00</published><updated>2017-08-20T21:08:13.908-07:00</updated><title type='text'>YOU CAN ALSO USE THE FOLLOWING CODE : &#xa;&#xa;PROC SQL N...</title><content type='html'>YOU CAN ALSO USE THE FOLLOWING CODE : &lt;br /&gt;&lt;br /&gt;PROC SQL NOPRINT;&lt;br /&gt;SELECT DISTINCT LOCATION INTO: LOC SEPARATED BY &amp;#39; &amp;#39; &lt;br /&gt;FROM TEST;&lt;br /&gt;QUIT;&lt;br /&gt;&lt;br /&gt;DATA &amp;amp;LOC;&lt;br /&gt;SET TEST;&lt;br /&gt;IF Location=&amp;quot;%SCAN(&amp;amp;LOC,1,&amp;#39; &amp;#39;)&amp;quot; THEN OUTPUT %SCAN(&amp;amp;LOC,1,&amp;#39; &amp;#39;);&lt;br /&gt;ELSE IF Location =&amp;quot;%SCAN(&amp;amp;LOC,2,&amp;#39; &amp;#39;)&amp;quot; THEN OUTPUT %SCAN(&amp;amp;LOC,2,&amp;#39; &amp;#39;);&lt;br /&gt;ELSE IF Location=&amp;quot;%SCAN(&amp;amp;LOC,3,&amp;#39; &amp;#39;)&amp;quot; THEN OUTPUT %SCAN(&amp;amp;LOC,3,&amp;#39; &amp;#39;);&lt;br /&gt;RUN;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/4437472673600477655'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/4437472673600477655'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1503288493908#c4437472673600477655' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/4756959764291987023'/><author><name>Karan</name><uri>https://www.blogger.com/profile/01473246377228396390</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1870916039"/><gd:extendedProperty name="blogger.displayTime" value="August 20, 2017 at 9:08 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8161833467781876396</id><published>2017-06-13T21:54:02.033-07:00</published><updated>2017-06-13T21:54:02.033-07:00</updated><title type='text'>HI ALl,&#xa; i have below mentioned data.&#xa;data tab1;&#xa;i...</title><content type='html'>HI ALl,&lt;br /&gt; i have below mentioned data.&lt;br /&gt;data tab1;&lt;br /&gt;input custid$ @6 saledate mmddyy10. @17 variety $9. @26 quantity ;&lt;br /&gt;format saledate mmddyy10.;&lt;br /&gt;datalines;&lt;br /&gt;240w 02-07-2003 ginger    120&lt;br /&gt;240w 02-07-2003 protea    180&lt;br /&gt;356w 02-08-2003 heliconia 60&lt;br /&gt;356w 02-08-2003 anthurium 300&lt;br /&gt;188r 02-11-2003 ginger    24&lt;br /&gt;188r 02-11-2003 anthurium 24&lt;br /&gt;240w 02-12-2003 heliconia 48&lt;br /&gt;240w 02-12-2003 protea    48&lt;br /&gt;356w 02-12-2003 &amp;#39;ginger&amp;#39;  240&lt;br /&gt;;&lt;br /&gt;run;&lt;br /&gt;i made below macro for same.&lt;br /&gt;%macro new (flowertype=);&lt;br /&gt;proc print data=tab1;&lt;br /&gt;where variety =&amp;quot;&amp;amp;flowertype&amp;quot; &amp;amp; custid=&amp;quot;&amp;amp;id&amp;quot;;&lt;br /&gt;run;&lt;br /&gt;%mend;&lt;br /&gt;%new (flowertype=ginger);&lt;br /&gt;&lt;br /&gt;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.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/8161833467781876396'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/8161833467781876396'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1497416042033#c8161833467781876396' title=''/><author><name>Anonymous</name><uri>https://www.blogger.com/profile/01015215335266688502</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1194548234"/><gd:extendedProperty name="blogger.displayTime" value="June 13, 2017 at 9:54 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6093372294414844382</id><published>2017-04-29T05:05:06.142-07:00</published><updated>2017-04-29T05:05:06.142-07:00</updated><title type='text'>awesome blog man! keep it up!</title><content type='html'>awesome blog man! keep it up!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/6093372294414844382'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/6093372294414844382'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1493467506142#c6093372294414844382' title=''/><author><name>Swati</name><uri>https://www.blogger.com/profile/00180586696765172388</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1312823418"/><gd:extendedProperty name="blogger.displayTime" value="April 29, 2017 at 5:05 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-727214571319313746</id><published>2017-03-25T01:45:14.457-07:00</published><updated>2017-03-25T01:45:14.457-07:00</updated><title type='text'>Answer to exercise:&#xa;proc sql;&#xa;select count(distinc...</title><content type='html'>Answer to exercise:&lt;br /&gt;proc sql;&lt;br /&gt;select count(distinct make) into :mk from sashelp.cars;&lt;br /&gt;quit;&lt;br /&gt;%put &amp;amp;mk.;&lt;br /&gt;%put %sysevalf(&amp;amp;mk.*2.5);</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/727214571319313746'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/819211436983772753/comments/default/727214571319313746'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html?showComment=1490431514457#c727214571319313746' title=''/><author><name>Anonymous</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/blank.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2015/12/sas-macros-made-easy.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-819211436983772753' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/819211436983772753' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-6939909"/><gd:extendedProperty name="blogger.displayTime" value="March 25, 2017 at 1:45 AM"/></entry></feed>