cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DartRodrigo
‎06-01-2022
  • 223 Posts
  • 69 Likes Given
  • 7 Solutions
  • 21 Likes Received
About
SAS Base Programmer Certified SAS Platform Administrator Certified SAS Visual Analytics SAS DI SAS RTDM SAS Macro Linguage (Mean)

Groups of Data

by Lapis Lazuli | Level 10 in SAS Programming
‎11-23-2015 11:32 AM
‎11-23-2015 11:32 AM
Hi,  I need a way to show just like the freq procedure the table below: ID VALUE 1   10 2   10 3   10 4   30   I'd like to establish, if value is lower than 20 then it will represent a percentage, and so on. I know there is a proc step to do this, i don't remember the name.   You guys have any idea ?   Thanks     ... View more

Create 6 numbers random

by Lapis Lazuli | Level 10 in SAS Programming
‎11-13-2015 11:23 AM
‎11-13-2015 11:23 AM
Hi,   I need to create 6 number between 01 to 60; Just like: 45,04,10,54,11,48; And change each time i run the code.   Any numbers, but without repeating them.   Tks ... View more

Re: SAS Certitification Exam

by Lapis Lazuli | Level 10 in SAS Programming
‎11-05-2015 10:16 AM
‎11-05-2015 10:16 AM
Hey,   I think you can only download the programs from the exercises of the certification course, not the test. Or if you work at SAS, there are some people that has a program called MANAGER that, simulates the certification test.   Hope this helps ... View more

Re: SAS Certitification Exam

by Lapis Lazuli | Level 10 in SAS Programming
‎11-05-2015 10:01 AM
‎11-05-2015 10:01 AM
Hi mate,   These links may help you: Exam Practice, SAS Certification Assignments, SAS Certification Ex   Hope this helps, good look    ... View more

Re: Separating first name and last name

by Lapis Lazuli | Level 10 in SAS Programming
‎11-05-2015 08:51 AM
‎11-05-2015 08:51 AM
Hi mate,   For this small table you can use multiple IFs and substr function to separate what you need. But if your table is very large and there is no patterns, then you need a new way to get this table   I agree with Kiwi.   But for this small table you can do this:   %macro name(name,pos,len,pos1,len1); data want_&name(where=(last_name ne "")); set sample; if substr(name,1,1) = "&name." then do; last_name = substr(name,&pos. ,&len.); first_name = substr(name,&pos1.,&len1.); end; run; %mend; %name(g,9,6 ,1,8); %name(a,5,6 ,1,4); %name(d,7,10,1,9); %name(m,6,10,1,5); %name(s,7,10,1,6);  And then append.   Hope this helps ... View more

Re: convertion to sas dates

by Lapis Lazuli | Level 10 in SAS Programming
‎11-04-2015 10:56 AM
‎11-04-2015 10:56 AM
Hi mate,   Can you post your code as an example to work on it ?   Thanks ... View more

Re: Convert SQL DateTime to SAS Date

by Lapis Lazuli | Level 10 in SAS Programming
‎11-04-2015 08:09 AM
‎11-04-2015 08:09 AM
Hi mate, You can use both, datepart() function or apply a format of date9.:   %global Recent_Load; proc sql noprint; select max(datepart(Trans_Date)) as max_date format=date9. into :Recent_Load from tbl_All_Trans; quit; SAS Date, Time, and Datetime Values   Hope this helps ... View more

Re: inverse transpose

by Lapis Lazuli | Level 10 in SAS Procedures
‎11-04-2015 07:59 AM
‎11-04-2015 07:59 AM
Hi mate,   Try do the same thing in the following code:   data have; input Id (Prod1 Prod2 Prod3)($); cards; 1 A B C 2 D E F ;;;; run; proc transpose name = NewVar1 data = have out = need(rename=(col1=NewVar2)) ; by id; var prod:; run; Hope this helps ... View more

Re: Number of months between testdate and birthdate?

by Lapis Lazuli | Level 10 in SAS Programming
‎11-04-2015 06:48 AM
‎11-04-2015 06:48 AM
Hi Alopex, try using:   month_from=intck('month',intnx('month',testdate_sas,0,'b'),intnx('month',fodtdate_sas,0,'b'));   Hope this helps ... View more

Re: Number of months between testdate and birthdate?

by Lapis Lazuli | Level 10 in SAS Programming
‎11-04-2015 06:34 AM
‎11-04-2015 06:34 AM
Hi mate,   First of all check out this SAS Date, Time, and Datetime Values. There are some tricks to do this in Calculate number of years, months, and days between two dates Or try YRDIF Function   Or you can test this program using intck function to get what you need:   data have; length date_1 $18 date_2 $8; infile datalines delimiter=','; input date_1 $ date_2 $; datalines; 10FEB2010:00:00:00,02/07/08 10FEB2010:00:00:00,03/10/08 10FEB2010:00:00:00,04/07/08 24MAY2010:00:00:00,05/09/08 24MAY2010:00:00:00,06/11/08 24MAY2010:00:00:00,07/11/08 ; data want (drop=date_1 date_2 dt); set have; dt=input(date_1,datetime.); date1=datepart(dt); date2=input(date_2,mmddyy10.); month_from=intck('month',intnx('month',date1,0,'b'),intnx('month',date2,0,'b')); format date1 date2 mmddyy10.; run; Hope this helps   ... View more

Re: Question on using SFTP to rename a file at remote SFTP server afte...

by Lapis Lazuli | Level 10 in SAS Programming
‎11-04-2015 05:54 AM
‎11-04-2015 05:54 AM
Hi mate, Once you are in the enviroment of this host you don't need to use these options. Your SAS is connected in this host, or it is another server ?   These are the questions that you might answer to select the option that you have to use. Pipe is used to the server you are connected.   Maybe you should use instead of pipe use sftp and do the same.   Try this: FILENAME Statement, SFTP Access Method   Hope this helps ... View more

Re: Joining two datasets on date that's true as of the date in the sec...

by Lapis Lazuli | Level 10 in SAS Programming
‎11-03-2015 02:51 PM
‎11-03-2015 02:51 PM
Hi mate,   If you need simply join these tables where the dataset2  remains only the last dates of each id you can simply do this:     proc sort data=dataset1(rename=id1=id date1=date); by id date; run; proc sort data=dataset2(rename=id2=id date2=date); by id date; run; data dt1; set dataset1; by id date; if last.date then flg = 1; else flg = 0; run; data dt2; set dataset2; by id date; if last.date then flg = 1; else flg = 0; run data merge; merge dt1(in=a) dt2(in=b); by id; if a; where flg = 1; run; Maybe this helps   ... View more

Re: Macro and proc sql help

by Lapis Lazuli | Level 10 in SAS Programming
‎11-03-2015 02:35 PM
‎11-03-2015 02:35 PM
Hi mate,   I think it is simply you add a max and min function into your SQL and use then in the having clause.   data test; format date date9.; input date :date9.; cards; 01jan2015 02jan2015 30jan2015 ; run; proc sql; select date, max(date) as max_date format=date9., min(date) as min format=date9. from test having date between min(date) and max(date); quit; Try this. Having clause can use summary functions.   Hope this helps. ... View more

Re: Question on using SFTP to rename a file at remote SFTP server afte...

by Lapis Lazuli | Level 10 in SAS Programming
‎11-03-2015 01:49 PM
‎11-03-2015 01:49 PM
Hi mate.   You can use the filename statement to rename the file using a shell script command "mv".   you can use the following sintax:   filename myfile pipe "mv myfile.txt newfile.txt"; /*or you can use the X command*/ x "mv myfile.txt newfile.txt"; Once you have permission to execute shell scripts you can use filename, call system, or x command to execute Shell scripts from SAS.   Check out some Shell commands or Executing Operating System Commands from Your SAS Session;   Hope this helps ... View more

Re: Reading raw files

by Lapis Lazuli | Level 10 in SAS Programming
‎10-30-2015 04:26 PM
‎10-30-2015 04:26 PM
Art, thanks this kind i solved, but when use infile "with my txt file", there are some lines that i don't need to read. Check out the attachment to see what i'm talking about.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-01-2022 09:35 AM
  • Contact User via MSN
  • Contact User via AIM
Likes given to
Quick links