About Akshaya_1397

Akshaya_1397 · ‎12-14-2023

Hi everyone, I have on and off worked on SAS. Now I'm eager to lear more about base sas programming to get strong knowledge about it for my career growth. Any suggestions from where to start preparing or any route map for preparation of interviews for 3years experienced. Please feel free to give 1.book suggestions 2.tutorials suggestions Thanks, Akshaya.

Akshaya_1397 · ‎07-03-2023

PROC SQL; CREATE TABLE FIN AS SELECT *, RANK() OVER(partition by rel_number order by exception_reason)as rn from test; quit; can anyone please helpme what is the syntax error in the above code. i got a error message as

Akshaya_1397 · ‎06-30-2023

data have ; infile cards dsd truncover ; input Id $ name :$20. function :$5. status :$20. reason :$20. department :$20.; cards; 123,flowers-gift,nw,onboard,blank SLS,human resource 123,flowers-gifts,nw,onboard,missing country,Human resource 123,onboard gift,nw,onboard,missing country, 124,flowers-gift,nw,onboard,blank SLS,human resource 124,flowers-gifts,nw,onboard,missing country,Human resource 124,onboard gift,nw,onboard,missing country, 125,flowers-gift,nw,onboard,blank SLS,human resource 126,flowers-gifts,nw,onboard,missing country,Human resource 126,onboard gift,nw,onboard,missing country, ; proc sort data= have; by reason; run; data haveuniq; set have; by reason; if first.reason then output; run; the output which im expecting is shown below: 123,flowers-gift,nw,onboard,blank SLS,human resource 123,flowers-gifts,nw,onboard,missing country,Human resource 124,flowers-gift,nw,onboard,blank SLS,human resource 124,flowers-gifts,nw,onboard,missing country,Human resource 125,flowers-gift,nw,onboard,blank SLS,human resource 126,flowers-gifts,nw,onboard,missing country,Human resource the output im getting is this is what is confusing me.

Akshaya_1397 · ‎06-30-2023

Thanks for ur reply tom. But we have exact same reasons for other I'd too that's why I used first.id and first.reason. Is there any other way to do it?

Akshaya_1397 · ‎06-30-2023

i have dataset name merged file as shown below: i wrote a code to obtain unique rows: DATA fin; set Merged_file; by ID dep status reason; if first.id and first.dep and first.status and first.reason then output; run; the output which im getiing is only the first row.but the output im expecting is the first two rows as the reason is different can anyone please help me on this

Akshaya_1397 · ‎06-30-2023

Sorry for that. I have now edited the it properly

Akshaya_1397 · ‎06-30-2023

Hi, I have a datset final in which there are columns like Id,name,function,status,reason, department and has values 123,flowers-gift,nw,onboard,blank SLS,human resource 123,flowers-gifts,nw,onboard,missing country,Human resource 123,onboard gift,nw,onboard,missing country, I need to take unique rows so I performed first. In the dataset Data new; Set final; If first.id and first.name and first.department then output; Run; The output I'm getting is only the first row that is with the reason blank SSL but I also need the second row with missing country. Could anyone please help me on this

Akshaya_1397 · ‎06-27-2023

Thankyou for ur reply. just now I have edited my post if you can see for create_date I have formatted ro date9. And in newfile I have used the datepart(create_date) too but still getting those as difference.

Akshaya_1397 · ‎06-27-2023

Hi, I have two datasets oldfile and newfile and it has two date variables exp_date and create_date Oldfile -exp_date has value 12/31/9999 and create_date has values 03/01/2022 Newfile-expdate has value 31dec9999:00:00:00 and create_date has value 01mar2022:00:00:00 I need to compare both the values so I changed all the date values to date9. Format Data oldf; Set oldfile; Format create_date date9.; Run; Data newf; Set newfile; Create_date1=dhms(create_date,0,0,0); Format create _date1 datetime19.; Create_date1=datepart(create_date); Format create_date1 date9.; Drop create_date; Rename create_date1=create_date; Run; Even though it is showing as difference in the proc compare as shown below is there any other reason behind it.

Akshaya_1397 · ‎06-27-2023

Thankyou for the explanation it worked

Akshaya_1397 · ‎06-27-2023

Hi I have a variable call splr_name which is a character variable and has alphanumeric values as shown in the picture and I need to extract only the numeric value and store it in a new variable called splr_number. Attached the picture for reference. I tried to use Compress(splr_name,'kd'); But I got the output as blank. Can anyone help me on this

Akshaya_1397 · ‎06-23-2023

Hi all, I have two completely different datasets. Dataset1 -clm has variables counterparty,id,name Dataset2-gsl has variable splr_name,relid,phn Now I need to compare the counterparty name in clm and splr_name in gsl in New dataset and report the not matching ones. Can anyone please help me on this. Can I simply use proc compare or is there any other way .

Akshaya_1397 · ‎05-13-2023

I need to compare two datasets A & B A has a variable action_comments =length 8000 character variable B has variable action_commebts=length 8000 character variable While doing proc compare something gets wrong with the variable even though The data is same in both. Can anyone tell me help me getting wrong?

Akshaya_1397 · ‎05-13-2023

Thanks for the detailed explanation

Akshaya_1397 · ‎05-13-2023

This method Worked out.thanks much!

Online Status	Offline
Date Last Visited	‎12-20-2023 04:57 AM

Where to start for becoming expert in Base sas ?

syntax error in sas programming

Re: First. And last .

Re: first dot in base sas

first dot in base sas

Re: First. And last .

First. And last .

Re: Proc compare for dates

Proc compare for dates

Re: Compress function in sas

Re: Where to start for becoming expert in Base sas ?

Re: Where to start for becoming expert in Base sas ?

Re: First. And last .

Re: Compress function in sas

Re: Compress function in sas

Where to start for becoming expert in Base sas ?

syntax error in sas programming

Re: First. And last .

Re: first dot in base sas

first dot in base sas

Re: First. And last .

First. And last .

Re: Proc compare for dates

Proc compare for dates

Re: Compress function in sas

Compress function in sas

Variable comparison in two different datasets

Compare proc

Re: Date part

Re: Date part