About sam369

sam369 · ‎01-22-2021

proc sql; create table want as select a.* from temp as a left join (select *,count(imput) as cnt from temp where imput='toto' group by class ) as b on (a.class=b.class & a.siren=b.siren) having missing(b.cnt) or b.cnt>=2 order by a.siren,a.class; quit;

dg19 · ‎10-24-2019

🙂

sam369 · ‎04-30-2018

Thank you all!!!

Aleixo · ‎02-28-2018

Thank you all answers people. I try with that task but the table is repeated 2 times. The columns are repeated(2x) with Date, and the goal is one time only. I will continue try to understand where is the problem. Regards, Aleixo

sam369 · ‎07-13-2017

Hi Ballardw, Thank you for the response!!! Apologies for not providing full information. as my sample data shown, my data as only 3 visn (1,24,45). Need to flag 0 to below conditions: VISN: non missing (val) 1 : subj with non-missing visn 1 and (visn 24 or visn 45) 24 : subj with non-missing visn 1 and visn 24 45: subj with non-missing visn 1 and visn 45 Thanks Sam

modsoul1 · ‎05-17-2017

you'd have to sort the data first though before proc summary. Is there a way around that?

sam369 · ‎07-18-2016

Hi Astounding, Intially i did not look that part, later i checked and it worked !!! thank you so much for the help Thanks Sam

sam369 · ‎06-02-2016

Thank you Astounding!!! Worked perfect!!!. Thanks to hentipdp,PGStat!!! your apporach also works !!!! Thanks FreelanceReinha rd, yes my sample data for ord varaible is liite bit odd.. my real data is different !!! i just made some sample. from next time i will keep your points in my mind Thanks!!!!

sam369 · ‎03-07-2016

Thank you so Much ballardw work like a champ Sam

Reeza · ‎02-16-2016

Post your code and define doesn't work.

LetourneauKent · ‎02-05-2016

I have been using the PROC COPY method to create sas v5 XPT transport files for years to transfer data to the FDA. It has recently been pointed out the the https://support.sas.com/techsup/technote/ts140.pdf tech notes for this format state that the INTRODUCTION All transport data set records are 80 bytes in length. If there is not sufficient data to reach 80 bytes, then a record is padded with ASCII blanks to 80 bytes. All character data are stored in ASCII, regardless of the operating system. I am working in a SAS environment with wlatin1 encoding and often my data contains characters that are not part of the ascii character set. When I create my XPT files with the PROC COPY method described in this thread I get SAS v5 XPT files but these files still contain my wlatin1 encoding. Is it possible that the SAS logic to create a SAS v5 XPT files creates files that are not fully compliant with their own technotes or am I misunderstanding something? thanks in advance for hte responses. KL

Reeza · ‎01-12-2016

In SQL it would work as well but it would be (2*(grp-1))+fl as net If the NET variable already exists in the dataset, as your warning indicates that something to be cautious of, do you really want to overwrite the other variable called net. In a data step it would overwrite it without any warning.

Tom · ‎11-11-2015

Your array definition is fine. You do not need to tell SAS in two places how many elements are in your array. So these are all equivalent definitions. array dy_all dy1-dy100 ; array dy_all (100) dy1-dy100; %let n=100; array dy_all dy1-dy&n ; array dy_all (&n) dy1-dy&n ; The error message is talking about how the array is REFERENCED, not how it is defined. You can use the "implicit" array reference of the DO OVER statement if you always reference the array that way. Once you start using explicit references using an index value like DY_ALL(i) then you need to use it everywhere. So you would need to replace: do over dy_all ; dy_all = .... end; with do i=1 to dim(dy_all); dy_all(i)= ... end;

Tom · ‎09-08-2015

Apostrophes like in your example data should be read as part of the character variables value. What type of problem are you having? The only problem I see is that you do not want the quotes around the yes in the GETNAMES=yes ; statement part of the PROC IMPORT procedure call.

sam369 · ‎08-18-2015

Thank you All Sam

Online Status	Offline
Date Last Visited	‎01-10-2023 02:21 PM

Re: How to delete some observations in some groups based on a conditio...

Re: retain previous missing visits

retain previous missing visits

Re: How to add duplicates in a new column

Re: flag

flag

Re: pick the closest prior date

Re: pick the closest prior date

Re: pick the closest prior date

pick the closest prior date

Re: pick the closest prior date

Re: if else macro loop

Re: pick the closet value aginst time period

Re: pick the closet value aginst time period

Re: prxmatch

Re: How to add missing data

Re: Fill in the blanks with the previous value

Re: Help with expression or subquery in an SQL JOIN

Re: identifying maximum investment among ??

Re: pick 0 and 1

Re: How to delete some observations in some groups based on a conditio...

Re: Proc Export for large files

Re: retain previous missing visits

Re: How to add duplicates in a new column

Re: flag

Re: How to add missing data

Re: pick the closest prior date

Re: flag the dup records

Re: proc sgplot tickmarks negativ to postive with 0 on yaxis?

Re: all dates between range

Re: How To create .XPT files? How to Convert .xpt files to Sas Dataset

Re: if else macro loop

Re: assign the closet value

Re: import columns

Re: check dates