Please post what SAS code you are working with and sample data that will assist in explaining what you want to achieve.
You can search the communities for regression models is that if what your question is and there should be many examples.
But if you provide samples and a clear statement of what you have (sample data) and what you expect possible sample data we can assist you faster because we will not be guessing.
... View more
you could use:
for a number
retain Relgp 0.
or for a character
retain Relgp '';
it could be intitialized by the input statement like this
input @1 name $25.
or
input @1 a_number 8.
the list go on and on. Need your sample data and how you are accessing the data to tell clearly.
hope this helps
Please when posting help us by helping yourself with full details explaining the request including sample data and code you are trying to get to work. It is hard to tell with such little information it becomes a guessing game.
... View more
Your original question did not include sample data. When you submit a question it helps the community by suppling a small set of sample data and the code you are having an issue with. I can not answer your question without more detailed information such as SAS code, sample data that represents your question and the SAS code your are providing and what you are trying to archive in the final outcome.
/* * *If your question has been solved then you * should mark the those answers as approved solutions for the * answer that solved your original question. That would give * credit to the individual that solved your question and it * closes unanswered question in the SAS communities Q. */
... View more
Try this
if RELIG=0 then RELGP= 1; /*NOR*/
if RELIG=1 then RELGP= 2; /*CH*/
if RELIG=2 then RELGP= 3; /*MU*/
if RELIG=3 then RELGP= 4; /*JE*/
if RELIG in (4, 5..6 9, 10) then RELGP= 5; /*HIN, SIK, ZAS, ALH, BAH*/
i
... View more
If your question has been solved then you and your classmates should mark the those answers as approved solutions for the answer that solved your original question. That would give credit to the individual that solved your question and it closes unanswered question in the SAS communities Q.
... View more
those are all very good questions to ask.
Research and prior understanding of SAS tools you are requesting answers to would answer these basics questions like the space in the deptdescirption for deptid 4.
Know your data, have a basic understanding of the tools you are trying to use.
... View more
Here is a link that explains how to merge.
https://stats.idre.ucla.edu/sas/modules/match-merging-data-files-in-sas/
Another user has a question much like the one you have
https://communities.sas.com/t5/SAS-Data-Management/Merging-two-datasets-by-ID-and-date/m-p/318404#M9151
... View more
this link may assist you in finding what your looking for.
https://communities.sas.com/t5/New-SAS-User/Good-SAS-Course-in-Coursera/m-p/507864#M1531
also could search SAS on Demand
... View more
understood. Have one on me and I will pay for it in the next life if we get one and if not then at least you had another reason to have one. Bottoms
... View more
@novinosrin hats off to you.
I was having an issue with calculating the days and keep getting over the expected number of days in my output.
Your code is great and if you don't mind I would like to keep it and use for other to learn from in future demonstrations.
... View more
You should have noted those requirements. If you were the manager of a shop you would be calling someone back to work or having them redo their work because of poorly defined request.
... View more
Why did you start a new post for the same question. refer to your last post and follow through with your issue that is the same topic same question in the same post please.
@blowsnow__ prior post same question
https://communities.sas.com/t5/SAS-Programming/Creating-variables-from-existing-variables/m-p/510186#M137286
Note you also don't have all of the original requirements listed for the same question listed here.
https://communities.sas.com/t5/SAS-Programming/How-to-output-the-last-part-data-programming/m-p/510172
... View more
given your sample data @blowsnow__ this should work.
data testing;
infile datalines firstobs=2;
input name $ 1-15 latest_sales_date date11. person_total_sales 28-32;
format latest_sales_date date11.;
/*1234567890123456789012345678901234567890*/
datalines;
David Wong 1/Aug/2018 13200
Brian Leung 15/Sep/2018 23450
10/Sep/2018 33000
Mary Chan 3/Jul/2018 45600
20/Aug/2018 37800
1/Sep/2018 21500
30/Aug/2018 42000
John Tam 12/Sep/2018 35000
run;
data temp;
set testing;
retain holder;
if not missing(name) then holder=name;
run;
proc sort data=temp out=temp;
by holder latest_sales_date;
run;
data want(drop=holder hdate person_sales_total);
retain days person_sales_total 0 hdate ;
set temp;
by holder latest_sales_date;
running_total + person_total_sales;
Person_sales_total + person_total_sales;
if first.holder then hdate = latest_sales_date;
if last.holder then days = (latest_sales_date - hdate);
name=holder;
person_total_sales = person_sales_total;
if last.holder then
do;
output;
person_total_sales = 0;
end;
run;
... View more
