In this article, I am going to explain an example involving Modal Popup Extender and GridView Control. We fetch handful of products from the database. When the user clicks on the “Edit” button, we show the details of the product in a Modal Popup window. User can change the product attributes and click on Update […]
In this article, I am going to explain how to render radiobuttonlist and dropdownlist in a GridView row. I am going to use AdventureWorks for this example. Each product belongs to a subcategory and each subcategory belongs to a category. When user tries to edit a gridview row, we render available categories as radio buttons […]
This macro splits a dataset to multiple datasets vertically with a common primary key. For eg, a dataset has 400 fields and 20,000 records. If we can split the dataset into two, with 200 fields and 20,000 records in each dataset with a common field like loan number as primary key would be helpful to load the details for analysis.
Here is a macro to quickly cleanup the work directory programmatically… It uses Proc Datasets with KILL option to delete the datasets in the library… The valid values for the parameter memtype are ACCESS ALL CATALOG DATA FDB MDDB PROGRAM VIEW only…
In this article, I am going to explain the in and outs of adding controls to GridView row at runtime. I am going to use AdventureWorks for this example. Each product belongs to a subcategory and each subcategory belongs to a category. When user tries to edit a gridview row, we render available categories as […]
SAS has a macro that creates a delimited text file from a SAS dataset @ SAS Macro to Create a delimited text file from a SAS data set..
Often a times, we get a dataset with missing values for certain variables…And for reporting purposes we need to convert them some or all of those variable values to default values (for e.g 0 for numeric values or NULL for character values)..
Well…there are many ways of getting the observation count into a macro variable…but there a few pros and cons in those methods…