topic prompt manager to prompt for data in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/prompt-manager-to-prompt-for-data/m-p/42249#M4988 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp; I'm new to sas,trying to create user prompt to enter date value...so that it will create<BR />&nbsp; dataset for that period.</P><P>&nbsp; ex:if i enter 2010Q1...it has to pull all records for that period.</P><P><BR />&nbsp; And then i have to create new dataset.Here is the sample dataset.</P><P>&nbsp; one more dataset for duplicate records....from that i have to get<BR />&nbsp; duplicates for that account.</P><P>&nbsp; Account&nbsp; raw_total count_ missing_ date&nbsp; count_missing_type&nbsp; duplicates</P><P>&nbsp; abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; xyz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P><BR />&nbsp; Can someone please guide me.</P><P></P><P>Thanks,<BR />reddy.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Thu, 04 Aug 2011 04:10:43 GMT reddy19 2011-08-04T04:10:43Z prompt manager to prompt for data https://communities.sas.com/t5/SAS-Enterprise-Guide/prompt-manager-to-prompt-for-data/m-p/42249#M4988 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp; I'm new to sas,trying to create user prompt to enter date value...so that it will create<BR />&nbsp; dataset for that period.</P><P>&nbsp; ex:if i enter 2010Q1...it has to pull all records for that period.</P><P><BR />&nbsp; And then i have to create new dataset.Here is the sample dataset.</P><P>&nbsp; one more dataset for duplicate records....from that i have to get<BR />&nbsp; duplicates for that account.</P><P>&nbsp; Account&nbsp; raw_total count_ missing_ date&nbsp; count_missing_type&nbsp; duplicates</P><P>&nbsp; abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; xyz&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P><BR />&nbsp; Can someone please guide me.</P><P></P><P>Thanks,<BR />reddy.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Thu, 04 Aug 2011 04:10:43 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/prompt-manager-to-prompt-for-data/m-p/42249#M4988 reddy19 2011-08-04T04:10:43Z