About Q1983

Q1983 · ‎10-23-2018

data have; length Group $50; input Group $ _NAME_ $ Value date $; datalines; wwww AARP 50 1jun2018 2fff BBRP 123 5may2015 ; run; data have1; set have; date1 = input(date,anydtdte11.); format date1 date9.; run; I am attempting to change the date format to read as a DDMMMYYYY format. I tried several combinations including format date1 ddmmmyyyy10.

Q1983 · ‎10-14-2018

data HAVE; input Group $ _NAME_ $ mth_28FEB2013 mth_31MAR2013; datalines; Central AAPP 1000 2500 Pacific BBER 1 100 PACIFIC BRMM 2 150 ; run; Group _NAME_ mth_28FEB2013 mth_31MAR2013 Central AAPP 1000 2500 Pacific BBER 1 100 PACIFIC BRMM 2 150 I want to transpose based on the month entry(current a character. I would also need to define a new variable called value to "house" the number from the date I need to read it as a date9 as follows Group _NAME_ Month Value Central AAPP 28FEB2013 1000 Central AAPP 31MAR2013 2500 Pacific BBER 28FEB2013 1 Pacific BBER 31MAR2013 100 Pacific BRMM 28FEB2013 2 Pacific BRMM 31MAR2013 150

Q1983 · ‎09-25-2018

data have; input ln_no $ state $ loans amt; datalines; 1123 AL 1 100 1123 AL 1 100 1123 AL 2 150 1233 AL 2 150 CA 3 50 ; run; data want; /*if last. then delete;run;*/ end = last; if not last then output; run; I have tried several methods to delete the last row of the datastep. How would I delete the last observation

Q1983 · ‎09-25-2018

data have; input Type $ State $ No; datalines; Failed AR 10 Failed AR 5 Passed MD 25 Failed MD 8 Passed MO 22 Passed MO 22 Failed NY 2 ; run; Type State No Failed AR 10 Failed AR 5 Passed MD 25 Failed MD 8 Passed MO 22 Passed MO 22 Failed NY 2 desired results is Type State No Failed AR 15 Passed MD 25 Failed MD 8 Passed MO 44 Failed NY 2 TOTAL Affected 94 How can I get TOTAL in Type field, Affected in State field and the grand total at the end of No

Q1983 · ‎09-06-2018

proc freq data=mytable; tables PROD_KEY_2/missing; run; produces this in the Results section PROD_KEY_2 PROD_KEY_2 Frequency Percent Cumulative Frequency Cumulative Percent 3112 1 0.14 1 0.14 3501 3 0.42 4 0.56 4101 2 0.28 6 0.83 5112 315 43.75 321 44.58 5122 337 46.81 658 91.39 5300 7 0.97 665 92.36 5400 55 7.64 720 100.00 When I use proc print mytable it produces the detail dataset. I want to reproduce the above table output for ODS output

Q1983 · ‎07-25-2018

data have; num = 3298056; pct = 46.51644; avg = 1.2555 run; What is the best way to format the numbers to capture proper commas and to capture the numbers up to 2 decimal places only So num = 3,298,056 pct = 46.52 avg = 1.25

Q1983 · ‎07-19-2018

I received a dataset that needs to be imported into sas. One of the fields 383_appr_mod begins with a numeric instead of a char. I recall a process where you could use the variable with a 'n however is it possible to demonstrate how to rename this so it can be accepted as an input

Q1983 · ‎05-15-2018

data junk; input ln_no $ state $ loans amt; datalines; 1123 AL 1 100 1123 AL 1 100 1123 AL 2 150 1233 AL 2 150 CA 3 50 ; run; My customer wants a tab added with a set of instructions and a picture (will call it pic_1). I told the customer that I may have to offer a link in the email message that accompanies the report (based on the code) that directs the customers to a site that has the picture and instructions page. I wanted to reach out to this thread to see if sas allows for embedded objects to display at runtime.

Q1983 · ‎04-10-2018

data have; input state $ amt; datalines; AL 250 AL 500 CA 200 DE 1000 ; run; proc sort = have out= have1; by state ;run; proc print = have1 noobs; by state; run; Lets say I want to proc export, I want each state to have its own tab without the byline so AL, CA and DE would output to its own tab. I do not want to have to name each state because I may have to do this for all 50 states.

Q1983 · ‎04-04-2018

data have; format stop_date date9.; input ln_no $ stop_date date9. ; datalines; 1123 16jun2014 1124 28dec2017 ; run; data have2; set have; months = intck('Month',stop_date,"4apr2018"d); run; Output ID Date months 1123 6jun2014 46 1124 28dec2017 4 I received code that asks for a rounding of the above numbers round(months_between("&today."d, stop_date),2) I have not heard of a months_between function so I used the intck function. The code received yields these results Output ID Date months 1123 6jun2014 45.61 1124 28dec2017 3.23 It appears the above code rounds down and sends two decimal places. I am attempting to determine how to replicate these exact numbers. The analyst that prepared this code is no longer available

Q1983 · ‎04-03-2018

data have; format mydate date9.; input ln_no $ state $ mydate date9.; datalines; 1123 AL 1jun2018 1123 AZ ; run; data have2; set have; format date_yr_mth yymmd7.; date_yr_mth = mydate; date_yr_mth1 = put(date_yr_mth,yymmd7.); run; PROC EXPORT Outfile= "\\MyDrive\have3.xlsb" DATA= have2 DBMS= EXCELCS REPLACE; SHEET='Details'; SERVER='server1'; Note the second value AZ has no date it is a blank. When it exports it somehow gets a . When it runs through our sharepoint server it is assigned a "0" I tried something like this in the datastep if date_yr_mth = '0' or date_yr_mth = . then date_yr_mth = ' '; Yet it still assigns a . or '0' when it runs. Is there a way in the proc export itself to assign all null values as a true null. I do not want it to display anything in the field.

Q1983 · ‎04-02-2018

data have; input ln_no $ state $ loans amt; datalines; 1123 AL 1 100 1123 AL 1 100 1123 AL 2 150 1233 AL 2 150 CA 3 50 ; run; ods listing close; options missing=' ' topmargin=0.30in bottommargin=0.01in rightmargin=0.25in leftmargin=0.25in; ODS TAGSETS.ExcelXP file="&ReportOut..xls" Path="&OutDir" style=&dors_style; %macro Final(final,sheet_nm); ODS TAGSETS.ExcelXP options(sheet_interval='none' absolute_column_width='8' sheet_name=&sheet_nm. center_horizontal="no" frozen_headers = "Yes" Orientation='Landscape' embedded_titles='No' fittopage="No" blackandwhite="No" Embedded_Footnotes='Yes' autofit_height="Yes"); %NoAccountLogic(&final.,&ReportName); PROC REPORT DATA=&final. headskip split='*' wrap nowd style(report)=[background=black cellspacing=9 just=center font_size=10pt font_face="Calibri" bordercolor=black borderwidth=1] style(column)=[background=white font_size=9pt bordercolor=black borderwidth=1] ; COLUMNS _all_; run; %mend final; %Final(have,"population"); ODS TAGSETS.ExcelXP close; ods listing; quit; The data displays without issue. I want to be able to add sortable dropdown columns. The user should be able to view drilldown on each column using a dropdown aarow. If it cannot be down in ODS is there a way to accomplish this using a straight proc export statement ???

Q1983 · ‎03-31-2018

data have; format app_date mmddyy10.; date_mth = month(app_date); date_mth1 = put(date_mth,Z2.); run: output ID app_date date_mth 12 12/09/2018 12 65 06/15/2018 06 This works ok in the datastep proc export outfile = "\\myserver\have.xlsb" data= have label DBMS = excelcs replace; Sheet = "Data"; Server = "myserver" Output LOAN_ID APPLICATION DATE DATE MONTH run; output example ID app_date date_mth 12 12/9/2018 12 65 6/15/2018 6 The exported output correctly eliminates the leading zeroes in the app_date however I want to retain the leading zero in date_mth just as I did in the datastep using the put statement. So 6 should be 06 however it truncates during export. How do I get it back?

Q1983 · ‎03-29-2018

data want (keep= ID mydate); set want1; run; OUTPUT ID mydate 12 09/16/2015 15 06/02/2013 16 10/06/2016 ODS TAGSETS.ExcelXP file= "c:/want,xml"; PROC REPORT DATA= want headskip split='*' wrap nowd COLUMNS _all_; DEFINE mydate / Display style(column)= { cellwidth=80pt just=right} "mydate"; run I want to remove any leading zeros that may exist. The desired output would be OUTPUT ID mydate 12 9/16/2015 15 6/02/2013 16 10/6/2016 Would tagattr be required for something like this??

Q1983 · ‎03-13-2018

data mydate (keep=ln_no mydate); set date1; run; output is ln_no mydate 011 09JUN2015:00:00:00.000 I tried using this newdt = datepart(mydate); format newdt mmddyy10. For some reason the newdt turns into a numeric and looses its date datatype. I want to extract the 09JUN2015 since the datepart function on this particular field does not convert to a date.

Online Status	Offline
Date Last Visited	‎05-08-2023 02:16 PM

Date will not change to Character

Date reading as 1960 after conversion

YYYMMDD where the field reads as a date

Change decimal number to a character

Suppress fields based on dataset in ods output

Proc report conditional fields

Re: Import CSV issue

Import CSV issue

Datetime format question

Date not displaying from database properly

Re: Date will not change to Character

Re: Date reading as 1960 after conversion

Re: YYYMMDD where the field reads as a date

Re: Suppress fields based on dataset in ods output

Re: Headers on first two rows of csv for export

output based on variable in dataset

Defined variable for file extension

Re: Headers on first two rows of csv for export

Date format assistance

Transpose data and date format

Delete last row datastep

Grand total in datastep or proc sql

proc freq to proc print ods

Numeric formatting issue help

Renaming variable starting with a numeric

Embedded object in sas program

Output individual tabs

Rounding issue in datastep

PROC EXPORT produces "0" for blank or null values

Drop column in ODS

loosing leading zeros during proc export

Remove leading zeros ODS output

Extract date only from datetime format