About jffeudo86

jffeudo86 · ‎05-27-2022

Thank you! That makes sense although using a variable from outside the subquery is basically returning the number of rows of the subquery.

jffeudo86 · ‎05-27-2022

Is there a know bug and what's the fix? proc sql; create tableC as select * from tableA where accountid in (select accountid from tableB); quit; if accountid is not a column in tableB it seems SAS takes the value of accountid from tableA. Anyone has encountered this, and what's the fix?

jffeudo86 · ‎05-11-2022

Thank you! I tried your second suggestion just right after I posted my question: .. where code in &list.; .. %generate_data(test, (‘a’, ‘b’, ‘c’)); I learned more from your reply such as the us of %str and %dequote

jffeudo86 · ‎05-10-2022

Hello everyone, How do I pass a quoted delimited argument to a macro? Below is a sample code to show the issue: %macro generate_data(ds, list); proc sql; create table &ds. as select * from some_table where code in (&list.); quit; %mend generate_data; %generate_data(test, "'a', 'b', 'c'"); How do I pass/format the 2nd argument 'a', 'b', 'c'? if I pass it without the double quotes at either ends, it will be treated as more than 1 argument. Basically the proc sql in side the macro would resolve to: proc sql; create table test as select * from some_table where code in ('a', 'b', 'c'); quit;

jffeudo86 · ‎12-02-2019

Thank you for your reply! I found the solution. Been looking for some time now.

jffeudo86 · ‎12-02-2019

I found it, "MDYAMPM22."

jffeudo86 · ‎12-02-2019

how do I convert the following character to SAS date, what informat should I use: "10/11/2018 10:11:31 PM" Thank you!

jffeudo86 · ‎10-03-2019

Thank you!

jffeudo86 · ‎10-03-2019

Hello all, So I have the following code below. dataset sample1 is sorted by id and priority. What does "if obs=1; drop obs;" mean and why would it drop obs? Does it also mean that if obs>1, the obs is still there? Help please. data sample; set sample1; by id priority; if first.id then obs=0; obs+1; if obs=1; drop obs; run;

jffeudo86 · ‎09-24-2019

Thank you! It is merely as a learning exercise. I'm using macro since I would most likely use it, pass a date to a macro and use that date inside the macro.

jffeudo86 · ‎09-24-2019

I'm using macro because that's where I would likely use it. Pass a date to a macro and perform transformation and use it.

jffeudo86 · ‎09-24-2019

I got it now through further reading. I've been used to dealing with dates with implied time 00:00:00. "THE PROBLEM Dates stored on databases and even EXCEL spreadsheets are typically stored as datetime values. It is quite often the case that minutes and seconds are not relevant or useful as they are often stored as a default value of midnight. (Something to do with glass slippers and carriages, no doubt.) Like SAS date values, EXCEL date values are stored as numbers. However, SAS dates are the number of days elapsed since Jan 1, 1960, and Excel dates are the number of days starting at Jan 1, 1900. For example, Day 1 in SAS is Jan 2, 1960, Day 0 is Jan1, 1960. Day 1 in Excel is Jan 1, 19001" So there is also a time value in SAS. I don't see yet why would i use/store only time it it's not tied to a date.

jffeudo86 · ‎09-24-2019

I am reading about SAS dates. So SAS dates are stored as numbers, that I understand. My initial thoughts also is that those stored values include time. So if I have a date '31DEC1996'd, I was expecting a stored value of '31DEC1996 00:00:00'dt, time 00:00:00 being implied. It seems that is not the case. It seems it only stores the date itself '31DEC1996'd. When I try to show the whole datetime value, it shows 01JAN1960 <time>. So is SAS storing 2 values now, one for date and one for time, the time is the correct time of the present day with the date being 01JAN1960? I am just trying to understand. Below is my code: %let mdate = '31DEC1996'd; %let yymm = %sysfunc(putn(%sysevalf(&mdate), datetime.)); %put &=yymm; The output is: YYMM=01JAN60:03:45:14 I used mdate to show datetime, so why is it 01JAN1960? Thank you!

jffeudo86 · ‎09-19-2019

Thank you!

jffeudo86 · ‎09-19-2019

I don't know as the data is large so I can't tell if it stopped or not.

Online Status	Offline
Date Last Visited	‎05-27-2022 03:24 PM

Re: SAS bug in select subquery?

SAS bug in select subquery?

Re: quoted comma delimeted are argument

quoted comma delimeted are argument

Re: character to date (length=22)

Re: character to date (length=22)

character to date (length=22)

Re: What does this code do?

What does this code do?

Re: How are dates stored in SAS?

Re: converting all character variables to numeric except for one

Re: Percentages in SAS

SAS bug in select subquery?

Re: Filtering by date proc sql

Re: SAS bug in select subquery?

SAS bug in select subquery?

Re: quoted comma delimeted are argument

quoted comma delimeted are argument

Re: character to date (length=22)

Re: character to date (length=22)

character to date (length=22)

Re: What does this code do?

What does this code do?

Re: How are dates stored in SAS?

Re: How are dates stored in SAS?

Re: How are dates stored in SAS?

How are dates stored in SAS?

Re: Invalid (or missing) arguments to the DATEPART function have cause...

Re: Invalid (or missing) arguments to the DATEPART function have cause...