For Example: vend_net 406,800,802,803,8010 406,800,802,803,8010 Pract_net 406,800,802,803 406,800,803,8010 Expected ANS: DIFF 8010 802 So how to find difference value between two column. Can you help me?
... View more
I have a date format like below example. If i want to convert in MMDDYY10. Using DATEPART function it is not working date='March 29, 2019 5:00:00 AM GMT+01:00'; Do we have any alternate way to convert character date to date format?
... View more
Please find the below link. In this file page no 01, below mentioned SAS code. Where we have pulse.csv file. I just wanted in ask communities members, if incase possible can we get it few sample records doe same. Can I get it to do for Basic Statistical calculation? It seems I am be beginner in Stat. data pulse; infile "pulse.csv" firstobs=2 delimiter="," missover; input pulse1 pulse2 ran smokes sex height weight activity; label pulse1 = "Resting pulse, rate per minute" pulse2 = "Second pulse, rate per minute"; run; http://www-personal.umich.edu/~kwelch/b600/2015/B600_Statistical_Procedures_2015.pdf
... View more
I have referred the context document. wanted to ask if I can get, at least I could understand from data prospective. where I can get al least minimum sample records?
... View more
These are all the legacy programs. If I changed to .xlsx I could not open the files in the directory. No where else I have mentioned .xlm I checked it. I checked the file name it looks good to me. The same filename also pulling the information in SAS datasets. Don't know what is the cause.
... View more
This is my requirements. If MAX NEW_Sequence_Number >= 100, For records with NEW_Sequence_Number between 0 and 99, populate '01' in For records with NEW_Sequence_Number >=100, populate '02' in NEW_Provider_Number_Suffix and add 1 to NEW_Sequence_Number. data test2;
set test1;
if MAX_NEW_SEQ >=100 then do;
if NEW_LOC_SEQ >=0 and NEW_LOC_SEQ =< 99 then
NEW_PROVIDER_NUMBER_SUFFIX='01';
end;
else
if NEW_LOC_SEQ >=100 then do;
NEW_PROVIDER_NUMBER_SUFFIX='02';
NEW_LOC_SEQ_N=input(NEW_LOC_SEQ,8.) +1;
end;
run;
... View more
