@poojasv20 wrote: I have one dataset there is only one variable name. ... I want a full name in different variable. How to do that in SAS. This is impossible. Where should the names come from?   EDIT: Is the first name in the first obs and the last name in the next obs? ... View more

Good (code taken from the log): 28 %let a = 783; 29 %let b = 9828888223; 30 %let a_b = &a.&b.; 31 32 %put &a_b; 7839828888223 Note: there is no space inserted. ... View more

This problem has been discussed so many times .... the server your sas session is running on can't access your local drives. ... View more

I have merged your posts, please don't repost questions. ... View more

BCP? Never heard of it. Please explain. If those files are text-files, you must have documentation of the structure, if not ask for one. Guessing types, lengths and informats is the best way to create more work in the long-run. ... View more

Is it correct that both obs with id=3 have month=1? This seems to work, too: data want; if 0 then set have; length r_flag l_flag 8; do _n_ = 1 by 1 until (last.id); set have; by id; if first.id or (sum(l_flag, r_flag) = 0) then do; r_flag = Right > Left; l_flag = Left > Right; end; end; do _n_ = 1 by 1 until (last.id); set have; by id; output; end; run;   ... View more

@SASKiwi wrote: SAS/AF's biggest negative is that it requires a full Foundatation SAS 9.4 installation to run on. It's also a legacy product that will not see any further significant enhancements. SAS 9.4 itself only has full support from SAS until the end of 2025 although I suspect that could be extended. SAS Viya is the way forward and @AllanBowe 's recommendations make a lot of sense. Why only until 2025? I thought that with the release of 9.4m8 in October we get full five years again. ... View more

Data posted in usable form helps us to provide tested code. So here a just some hints to find the solution yourself. Thanks to missing dates, using min-function in a data step is not possible. proc transpose + proc summary will work, because summary ignores missing values by default. A data step with a loop seems to be a good idea, too. ... View more

Won't work with values like "111green222", but only @luvscandy27 knows whether values with multiple numbers exist. ... View more

Interesting, the whole table-header looks disgusting. The empty cell is cause by removing the label / variable name in the "define mrw" statement. It looks as if the number of empty cells for the status, sex and bp_status are calculated ignoring that mrw should not have a title. Sounds like a task for tech support. ... View more

Don't use Excel to transfer data. Just remove Excel for such task from the list of tools for ever. Using Excel will sooner then one can hope bring other fancy problems, caused by the nice number of "improvements" Excel uses to transform the data to what Excel things is what you may expect.   If you don't have a sas licence, you have to rely on third-party-tools. I recommend searching outside the sas community. ... View more

DLM = delimiter = char that separates variables termstr = separator between obs   Without having termstr in the infile-statement, sas uses the default depending on the os sas runs on.  It seems as if dlm = " '0D'x, '0A'x " is processed correctly, because in the background termstr=LF is still active. I think the only way to solve the problem is by adding a parameter to the macro that is used in termstr later on. One could, of course, try to read the file with one termstr-option active and check the number of lines read. Then change the option and re-read the file again. ... View more

An another one: data want; merge set1 set2(where=(type = 'B')) ; by pid; Var = not missing(type); drop type; run; ... View more

issue 2: The length of sheet-names is limited, see https://stackoverflow.com/questions/3681868/is-there-a-limit-on-an-excel-worksheets-name-length issue 3: Maybe possible to achieve by using Report Writing Interface, but i am not sure that placing the filters is possible.   hint: if you have issues with a report, posting data is necessary so that the community can actually use your code. ... View more