About katkarparam

katkarparam · ‎06-28-2018

yaa

katkarparam · ‎06-12-2018

thank you.. I will refer it

katkarparam · ‎06-12-2018

for this dataset I have 37 distinct values.

katkarparam · ‎06-11-2018

sir, can you give little bit hint how I can achieve these with Hash Table thanks in advance..

katkarparam · ‎06-11-2018

thanks @Kurt_Bremser your valuable time.

katkarparam · ‎06-09-2018

i have create new macro variable for each distinct value. #This is challenge for me from my colleague but I am not able to do

katkarparam · ‎06-09-2018

for. example purpose I have use the sas default dataset proc sql noprint; select distinct origin into :list- from sashelp.cars; quit; WARNING: INTO Clause :list through : does not specify a valid sequence of macro variables.

katkarparam · ‎06-08-2018

I agree with you. But my requirement is i have create new macro variable for each distinct value.

katkarparam · ‎06-08-2018

I have one dataset(country) with one column(state), dataset contain 10000 of record, all are duplicate. i want to find out distinct record using proc SQL and store all distinct record in separate macro variable. i.e each distinct record stored in separete macro variable.

katkarparam · ‎06-08-2018

Do you have another solution to change observation value at one shot for all rather than one by one. suppose i have billions of record...

katkarparam · ‎06-08-2018

I will let you know..

katkarparam · ‎06-08-2018

Yes, you are right. data test; x1 = '01jan2018xxxxxxxxxxx'd; format x1 yymmddd10.; run; Output dataset contain Obs x1 1 2018-01-01

katkarparam · ‎06-08-2018

we can use Year() fun to extract the year from sas date value. Data Demo; Var1='21feb2002:22:23:00'd; var2=year( var1); run;

katkarparam · ‎06-06-2018

Can I use ROWNUM Pseudo column in proc sql? like other database statement? eg. PROC SQL; SELECT * FROM employees WHERE ROWNUM < 11; QUIT;

katkarparam · ‎06-04-2018

thank u..sir..

Online Status	Offline
Date Last Visited	‎09-01-2020 04:10 PM

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Proc sql

Re: How to extract year and month from date in SAS?

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Re: Proc sql

Proc sql

Re: How to extract year and month from date in SAS?

Re: To get only Year from DATETIME20. format

Re: To get only Year from DATETIME20. format

Re: To get only Year from DATETIME20. format

PROC SQL.

Re: importing data