I'm trying to consolidate some code. Currently, I have:   For group X: PROC  SQL; select Var_A, Var_B, Var_C from mytable;   For group Y: Proc SQL; Select Var_A, Var_C, Var_D from mytable;   is there a way to say; Proc SQL; Select [variables contingent on group] from mytable;   FYI-using SAS EG 7.15 with connection to Hadoop data. My actual data has 50 groups and over 100 variables, so I'd like to make this as dynamic as possible. The key point is I don't want all of my variables for all of my groups. Thanks.   ... View more

I want to refresh the data that exists on the LASR to support my visualizations. Using SAS I can import a SAS dataset using the "Add data source" on the data pane. I can delete the data set by navigating through the folder structure and deleting the file. My understanding is that the "refresh data source" on the data tab, syncs my visualization with the latest data on the LASR.  My question is if the dataset outside the LASR is updated, is there a way to refresh the dataset on the LASR?   I'm running SAS VA 7.4 and SAS EG on separate servers, requiring the output from EG to be uploaded to the LASR for VA. Thanks. ... View more