I’m trying to accomplished this task using SAS.

I’m developing a process that will cycle through a file of about 1+ million rows to find the earliest record for my key value. My Plan is to use global macro variables to share across 4 macros. One macro will be the master that calls the other 3. So depending on which macro was called, the global macro variables will be updated.

i have a sas dataset which is large in size(90+GB). To keep only recent data i created a new dataset where the latest data is present. now the older dataset has an composite index on it. Is there any way to point the index from older dataset to new one.

I have a dataset (data1) where there are some missing values. I have the imputed values stored in another dataset (samples2), where the variable AVAL_x represents the row number x in data1. What I want to do is loop through each row in samples2 (each row represents a simulation), in each loop, check each observation if flag=1, if true, extract the row number of that observation, say x, and replace aval with AVAL_x in samples2. I also attached my code sample, I don’t know why it doesn’t work. Please help, thank you!!

For each observation in Data1, if Flag=1, replace the Val with values in another dataset Data2. For example, if an observation in Data1 has Flag=1, suppose it has Visit=Week2 and Group=2, then I want to replace that Val with the “Week2_2” value in Data2. This process loop through each row in Data2 to have N new datasets.

I have to do a condition in SAS Guide if the SYSERRORTEXT is blank or not, but the code that I created is giving me only the value 0, indicating that the code is not good, even I received the e-mail. I’ve tried everything for days, but anything is working. I’ve tried IS MISSING, IS NULL, ” “, LIKE something etc. I’ve tried the variable SYSERR too, prxmatch(‘/ERRORd+/’, text) > 0, anything, but it’s getting me crazy. How can I get the best code of it? Thank you very much!