About V_27

ChrisNZ · ‎02-25-2021

Surely that was explained by your teacher?

andreas_lds · ‎02-27-2020

Please post the data as data step using datalines statement. In many companies downloading office-files is not allowed.

ed_sas_member · ‎02-26-2020

Hi @harveysarah0 There is no need to specify ascending, as it is the default sorting: proc sort data=Bbq; by Price; run;

jeremylevinson · ‎02-06-2020

You can produce quick results with IHD, but you have less control. You have to think a little differently in your approach. You still have to understand the underlying data, but some decisions have been made for you in the mapping of the data into their proprietary format. Some iterative results are more tedious to produce than could be achieved with clever use of the SAS macro language. The process involves defining cohorts and layers of dependent measures instead of coding.

Ksharp · ‎10-17-2018

data have; input ID Flag; datalines; 1000 2 1000 1 1000 9 1000 1 1000 5 1000 1 1000 1 1000 1 1000 1 2000 11 2000 12 2000 4 2000 1 2000 1 2000 3 2000 1 2000 1 2000 1 ; run; data want; do until(last.flag); set have; by id flag notsorted; if last.id then found=1; end; do until(last.flag); set have; by id flag notsorted; if found and flag=1 then output; end; drop found; run;

Kurt_Bremser · ‎10-16-2018

@Terekhin wrote: HI! SAS 9.4 i'm trying to merge 2 datasets. When i merges this tables i want to change column "name" with condition "st = "POMPLE" and DATE < "01MAR2017"d" , but program changes all observation. Why it's happen? I know that if i do it in a new data step, everything will be executed correctly. I want to undenstand how SAS creating PDV in merging. data first_data; input st $ date date9. ; attrib date format=date9.; datalines; POMPLE 28FEB2017 POMPLE 28FEB2017 POMPLE 01MAR2017 POMPLE 01MAR2017 POMPLE 02MAR2017 POMPLE 02MAR2017 MINR 28FEB2017 MINR 02MAR2017 ; run; data sec_data; input st $ name $; datalines; POMPLE ANNA MINR GERRY ; run; proc sort data=first_data; by st; run; proc sort data=sec_data; by st; run; data merges_clon; merge first_data(in=a) sec_data(in=b); by st; run; data merges; merge first_data(in=a) sec_data(in=b); by st; IF st = "POMPLE" and DATE < "01MAR2017"d THEN name = "MOLLY"; run; This is part of the mechanics of the data step. Variables from input datasets are always retained (not set to missing), so what happens is this: In the first iteration of the data step, both datasets are read, the condition is found to be true, and name is set to MOLLY. From the second iteration on, no further observations for st = 'POMPLE' are present in the second dataset, so the value 'MOLLY' is retained and ends up in all output rows.

V_27 · ‎10-16-2018

You are most welcome @dera

AMMAN · ‎10-15-2018

I forgot the data set! Here it is.

V_27 · ‎10-15-2018

Hi @shadab044, I agree with Reeza. You need to invoke the library you created every-time when you start you sas code in VM. Also can you please provide your code and error.

altijani · ‎10-15-2018

Here is the code I am trying to use: proc sql; CREATE TABLE WANT AS SELECT DISTINCT Customer, Item1, Item2, Item3, (CATX (" ", Item1, ", ", Item2, ", ", Item3)) AS Items FROM Have;

novinosrin · ‎10-09-2018

I am glad, you got it to work. Feel free to open up any number of threads/questions. We(you included) are all part of the SAS family. Don't ever hesitate. The pleasure would all me mine to help. Of course, this is the best platform for all us to share and learn. I try to get here almost everyday. 🙂 PS IF anything urgent, besides your open thread here, PM me. I will try to look into it for sure. Nevertheless, on the open thread you are bound to get responses from champs like John King, Pierre Gagnon, Tom, Paul Dorfman, Xia keshan, Mkeintz, Art T etc with their super answers. These people are synonymous with this gorgeous language of SAS. I tend to copy theirs. haha

Online Status	Offline
Date Last Visited	‎11-19-2021 07:13 PM

Randomly selected matched controls

Re: Sorting Error

SAS program-Connect event in given period

Instant Health Data (IHD)

Re: SAS - Filter

Re: merging

Re: PROC Transpose with missing value

Re: PROC Transpose with missing value

Re: Need help with what PROC to use group Items per Tranaction

Re: library does not exist when I am running the code

Re: Need help with what PROC to use group Items per Tranaction

Re: Randomly selected matched controls

Re: SAS program-Connect event in given period

Re: Sorting Error

Re: Instant Health Data (IHD)

Re: SAS - Filter

Re: merging

Re: PROC Transpose with missing value

Re: Need help with what PROC to use group Items per Tranaction

Re: library does not exist when I am running the code

Re: Concatenate with Some Missing Vars

Re: Arrays