Hi,
I've started a Recoded Column in SAS EG 7.1 & I'm naming a new Column 'SalesRanges' to use to create ranges of $ of sales.
Sales could be anything from $0 - $2000, So I ;'ve created $0-$10 , $11-$20, $21-$30 etc to organise the sales.
As there are many ranges to add in, I've tried to go to the Querys 'Submitted Code' but I can't add to it because it is 'Read Only'.
SAS EG offers to create a new Program but it not suitable as it doesn't connect like a normal Query Builder.
Is there a way to add to an existing queries code to save time manually creating these ranges?
Thanks
If you open the preview window while specifying your query, you can see exactly the code that will run. You can even watch how the code changes while you are working on the query.
Ctrl-A, Ctrl-C and paste the whole thing into a new program window. Works like a charm.
You are asking for the ability to change the Query Builder generated code manually but still somehow be automatically generated / updated when you change the Query Builder definition.
If you could manually change the code then it would no longer agree with your Query Builder definition and trying to maintain automatically generated code with manual overrides would be problematic, hence SAS does not allow it.
If you want to change it then copy it outside and modify it there. You can get SAS programs to "connect" just like the Query Builder.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.