About Vish33

Vish33 · ‎04-14-2015

It's .txt sample file. I am not sure on this..sample has been provided by IT team....they might calculate in excel.

Vish33 · ‎04-14-2015

I have a raw file which is having header, data and trailer records. In trailer i have this value as roconcile value.So need to get this value to match with the reconcile field.

Vish33 · ‎04-14-2015

Hi ALL, i have a variable with julian date format,. when i tried to calculate sum of the field it's not giving the actual result.ANy help would be appriciated. Here is the sample code: Actual result should be 586625, but am getting 40609. data chk; informat dat date9.; format dat julian5. ; input dat ; cards; 23-Nov-73 26-Nov-73 23-Nov-73 23-Nov-73 23-Nov-73 23-Nov-73 26-Nov-73 26-Nov-73 ; run; proc sql; select sum(dat) from chk; quit;

Vish33 · ‎03-24-2015

Can you provide us a sample data which you are trying to transpose, then i can able to check the code.

Vish33 · ‎03-24-2015

try this code: data inpt (drop=tran_date); set input; new_var=put(intnx('month',tran_date,0),monname3.)||put(year(tran_date),4.); run; proc sort data=inpt ; by desc new_var ; run; proc tabulate data=inpt ; class desc new_var; var cnt amt; tables desc='',new_var='' *(cnt amt)*sum=''/Box=Desc; run;

Vish33 · ‎03-24-2015

As you enter into debugging , you can see the iterations step by step which does by PDV. But i think you can't able to see the output data as the data set is incompleted. Each iteration will give you one output record, once these iterations completed then you can able to see the data.

Vish33 · ‎03-17-2015

use round function ex: round(variable_name,2) else use formats.

Vish33 · ‎03-02-2015

I am not sure that we can match two variables and do color coding over it in proc tabulate. I do use proc report.

Vish33 · ‎03-02-2015

Are you doing it in proc report or something else

Vish33 · ‎03-02-2015

try using CSV as dbms. If this doesn't work , i think you need to check the data and why its getting truncated. proc import datafile="D:\sample.txt" out=ds dbms=csv replace; delimiter='09'X; run;

Vish33 · ‎02-22-2015

when you define next macro , clear titles and footnotes an then give titles an footnotes. title; footnote; title1 "..........."; footnote1 "............"; i didnt test it....

Vish33 · ‎02-22-2015

or if you can provide sample data and output (how you want) , that could be helpful in answering your question.

Vish33 · ‎02-22-2015

i think merge / update will work.

Vish33 · ‎12-07-2014

Hi, Below is the proc sql code. proc sql; select num,max(maths,phys,chemis) as max from a1; quit;

Vish33 · ‎08-19-2014

Try IN instead of or . (not tested) %if &dsn. = pavan and %substr("&ym.",6,2) in (02,03,05,06,08,09,11,12) %then %do;

Online Status	Offline
Date Last Visited	‎11-27-2019 12:34 PM

Re: Merging two datasets with alternating variables

Re: Merging two datasets with alternating variables

Re: appending .csv files onto a dataset daily

Re: Make macro variable for values of a variable

Re: How to combine two proc sql table and then export them as ods html...

Re: proc report summarize

Re: Dynamic Parameters

Re: Dynamic Parameters

Re: How to add quarters in SAS?

Re: Proc Means and output statement

Re: export dataset rows into multiples files .txt

Re: Make macro variable for values of a variable

Re: SAS Output help

Re: SAS Output help

Re: How to add quarters in SAS?

Re: Merging two datasets with alternating variables

Re: Help in my sql code

Re: Create new variables based on observations to statistics

Re: Create new variables based on observations to statistics

Re: How to create 3d clustered column chart in sas

Re: Incorrect sum of julian date

Re: Incorrect sum of julian date

Incorrect sum of julian date

Re: proc transpose with columns out of order

Re: summing up data into months

Re: how to see data going to ouput while debugging?

Re: How to truncate values after decimal ?

Re: How to change the color of value in one column in the Summary tabl...

Re: How to change the color of value in one column in the Summary tabl...

Re: how to import txt file

Re: excelxp title width defining

Re: Replacing observations

Re: Replacing observations

Re: Compute maximum and minimum values for rows

Re: sas macro

SAS Global Forum 2016