About Cho8

Cho8 · ‎12-10-2020

X Y Q320 Q420 59.7006504 0 49.7784597 0 6103.478 6733.755 3.63574724 0 14.9677104 0 359.6202 571.4418 27.8748853 0 66.2676187 0 324.0891 363.2533 58.185401 0 3.06299373 0 38.69756 0 18.7158174 0 55.9166339 0 0 0 5.14737594 0 363.253294 0 112.9771 126.4904 The last records of every column to be added. Quarter and year are changing everytime(for every input spreadsheet,but not x,y). For instance %let Q1=Q320,Q2=Q420

Cho8 · ‎12-10-2020

everytime Quarter and year changes in Excel, i have to pickup the latest one.. if i give %let Q=Q320, then i have to pickup last record in that column and add it to another variable..instance X=18456.35..

Cho8 · ‎12-10-2020

Q420 6733.755169 . 571.4417845 . 363.2532938 . 0 . 0 . 126.4904378 . 18.189424 x=13857.20 I want to extract last in the Quarter, Quarter and year are changing dynamically. (i.e.Q320,Q420,Q120,Q220) extract last record and add it to x.

Cho8 · ‎11-26-2020

Cho8 · ‎11-26-2020

i have to store it in datset alongside other variables,to use it for further calculations. i have to use FORMAT stmt.. but while using FORMAT it still showing Enotation.. is there a way to display using FORMAT..stmt.

Cho8 · ‎11-26-2020

Thanks.. its not converting ENotation into $M Format.. its giving Enotation value..

Cho8 · ‎11-26-2020

-64684149.4007373 the negative number to be displayed like ($ 64,684,149). it should not take Million format.

Cho8 · ‎11-26-2020

proc format; picture bigm (ROUND) low - high = '000,000,000,000 M' (prefix="$ " mult=0.000001) ; run; I have defined format like the above.. but iam not able to dispaly the below number in Million format. Please advise 2.047219393619E-09

Cho8 · ‎11-26-2020

I need only million format and if is negative ('-') then it should display ($6354466...) if its 629777257.72 it should give $ 630 Million if its 3063114.557 it should give $3M. i have to store it in dataset and use the dataset for further calculations.. if it is between 0 and 1..it should give 1 Million FYI: the values are being imported from EXCEL..

Cho8 · ‎11-25-2020

Need below data in Million Dollar format. Data: 629777257.7 3063114.557 47687382.31 31371401.09 548907467.6 7475029.274 30882553.57 26616491.86 Expected Format; $ 630 MM $ 3 MM $ 48 MM $ 31 MM $ 549 MM $ 7 MM $ 31 MM $ 27 MM

Cho8 · ‎11-13-2020

X A B C X1 4 5 6 X2 10 11 13 X3 5 9 10 FirstQtr 1 8 5 LTV 6 4 2 I want to pickup the last value of column 'C' (Marked in Color). and assign it to variable New_var. Desired O/p New_var=2 ; I need it in dataset.

Cho8 · ‎11-10-2020

where do u print the vertical average for each variable

Cho8 · ‎11-10-2020

its giving 0 for all sum ,counter and mean. missing value for Col1.. when i use mean=sum/12

Cho8 · ‎11-09-2020

Average of first 12 non-missing values vertically. X Y0 Y1 Y2 Y3 Y4 Y5 Y6 Y7 Y8 Y9 Y10 201201 1% 0% 1% 0% 0% (0%) . . . . . 201202 3% (1%) 2% 1% 0% 0% 1% . . . . 201203 1% 0% 1% 0% (0%) 0% 0% 0% . . . 201204 2% 1% 0% 1% 2% 0% (0%) (0%) 1% . . 201205 1% 0% 0% 2% (0%) 0% 1% 0% 3% 1% . 201206 0% 1% 1% 2% 0% (0%) 0% (0%) 1% 3% 2% 201207 1% 2% (0%) (0%) 0% 0% 3% 0% 2% (0%) 0% 201208 1% (0%) 0% 1% 1% 0% 2% 2% (0%) 1% 3% 201209 1% 1% (0%) 3% 0% 2% 1% (0%) 2% 3% 2% 201210 2% (0%) (0%) 1% 4% 3% 2% 1% 4% 4% 0% 201211 1% 2% 1% (0%) 0% (0%) 0% 3% 0% 0% 6% 201212 2% 0% 1% (0%) 1% 6% 0% 2% 3% (0%) (0%) 201301 2% 2% 0% (0%) 0% 0% 0% (0%) 2% (0%) 1% 201302 0% 0% 1% 0% 0% 1% (0%) 1% 5% (1%) 1% 201303 1% 1% 0% 1% 0% 1% 0% 1% (0%) 1% 4% 201304 0% 4% 1% 1% 1% 3% 2% 4% (1%) 1% 4% AVG 0.012921 0.004853 0.005452 0.008107 0.006915 0.009627 0.008207 0.007293 0.018898 0.011633

Cho8 · ‎11-09-2020

X Y0 Y1 Y2 Y3 Y4 Y5 Y6 Y7 Y8 Y9 201201 1% 0% 1% 0% 0% (0%) . . . . 201202 3% (1%) 2% 1% 0% 0% 1% . . . 201203 1% 0% 1% 0% (0%) 0% 0% 0% . . 201204 2% 1% 0% 1% 2% 0% (0%) (0%) 1% . 201205 1% 0% 0% 2% (0%) 0% 1% 0% 3% 1% 201206 0% 1% 1% 2% 0% (0%) 0% (0%) 1% 3% 201207 1% 2% (0%) (0%) 0% 0% 3% 0% 2% (0%) 201208 1% (0%) 0% 1% 1% 0% 2% 2% (0%) 1% 201209 1% 1% (0%) 3% 0% 2% 1% (0%) 2% 3% 201210 2% (0%) (0%) 1% 4% 3% 2% 1% 4% 4% 201211 1% 2% 1% (0%) 0% (0%) 0% 3% 0% 0% 201212 2% 0% 1% (0%) 1% 6% 0% 2% 3% (0%) 201301 2% 2% 0% (0%) 0% 0% 0% (0%) 2% (0%) 201302 0% 0% 1% 0% 0% 1% (0%) 1% 5% (1%) 201303 1% 1% 0% 1% 0% 1% 0% 1% (0%) 1% 201304 0% 4% 1% 1% 1% 3% 2% 4% (1%) 1% AVG 0.012921 0.004853 0.005452 0.008107 0.006915 0.009627 0.008207 0.007293 0.018898 0.011633

Online Status	Offline
Date Last Visited	‎06-03-2022 02:29 PM

Re: extract string from columns

Re: extract string from columns

Re: extract string from columns

Re: extract string from columns

Re: extract string from columns

Re: extract string from columns

Re: extract string from columns

extract string from columns

Re: Need count by monthyear

Re: Need count by monthyear

Re: extract last record from Quarter and add it to another variable to...

Re: extract last record from Quarter and add it to another variable to...

extract last record from Quarter and add it to another variable to fin...

Re: Million Dollar format

Re: Million Dollar format

Re: Million Dollar format

Re: Million Dollar format

Re: Million Dollar format

Re: Million Dollar format

Million Dollar format

Picking last value and assign it to variable

Re: Vertical Average by condition

Re: Vertical Average by condition

Vertical Average by condition

Re: Vertical Average of first 12 non-missing values