About sh0e

sh0e · ‎07-13-2016

The N statistic on a numeric variable like date should give you what you need. Try something like this: title1 "&month Enrollment Report"; proc report data=assessedkids3 nowd headline; where &start_date <= dateeval <= &end_date; columns dateeval counselor childid CaseDispositionDesc eligibilitycriteriaid AssessmentDate_HW ProgramTypeID Neighborhoods ; define CaseDispositionDesc /'Referral Status'; define counselor /'Counselor' group format=$counselor.; define childid / 'Child ID'; define AssessmentDate_HW / 'Assessment Date'; define eligibilitycriteriaid / 'Referral Source'; define ProgramTypeID / 'Program'; define dateeval / n noprint; define Neighborhoods / 'Neighborhoods'; compute after counselor; count = dateeval.N; line count; endcomp; run;

sh0e · ‎07-12-2016

Use PROC PRINTTO to redirect the LISTING to a file.

sh0e · ‎07-12-2016

Try using MMDDYY10. as teh INFORMAT in the INPUT function. In general, the INFORMAT must match the format of the data you wish to convert. I suggest reviewing the details of the ANYDATE informat as well. HTH - Jack

sh0e · ‎07-12-2016

The INPUT function is expecting a string. So, try this: %let ID=1000 ; PROC SQL; SELECT * FROM TABLE WHERE FORMULARY_ID = INPUT("&ID". ,8.); QUIT; Of course, you don't need to do that. This should work as well. %let ID=1000 ; PROC SQL; SELECT * FROM TABLE WHERE FORMULARY_ID = &ID.; QUIT; HTH

sh0e · ‎07-12-2016

Embedded spaces are the bane of every coder's existance. I don't recommend against variable names with embedded spaces; I don't allow it!

sh0e · ‎07-12-2016

Puzzling. The value of 60 is external in my example. You can't use FACTOR_MONTH in the SEED data set because that column is not available. You could use a macro symbol to hold the value of 60. I guess I really don't understand your question.

sh0e · ‎07-12-2016

You can use an SQL join to make the data set have proper rank. For example, data seed; date = '11FEB2015'D; do month = 1 to 60; output; end; run; proc sql; create table full as select * from seed left join raw on raw.date = seed.date & raw.month = seed.month; quit; run; data full; set full; if amount = . then amount = 0; run;

sh0e · ‎07-07-2016

This is a job for PROC SUMMARY. proc summary data = in missing nway; class president secession party; var quantity; output out = reduced( drop = _type_ _freq_ ) sum=; run;

sh0e · ‎07-06-2016

Sorry about that. I'm a PROC REPORT guy. Here is a snippet using PROC FREQ instead. proc freq data = report; format display_value display.; table display_value / missing list order=internal; run;

sh0e · ‎07-06-2016

Sounds like you want CDL in the sort. For example, proc sort data = in; by year GVKEY CDL date;run; data out; set in; by year GVKEY CDL; if last.CDL; run;

sh0e · ‎07-06-2016

Consider this code snippet data report; set raw; if raw_value = 'Y' then display_value = 0; else display_value = 1; run; proc format; value display 0 = 'YES' 1 = 'NO'; run; proc report data = report missing; column <your-columns>; ... define display_value / order = internal format = display.; ... run;

sh0e · ‎07-06-2016

Will this work for you? proc sort data = in; by year GVKEY date; run; data out; set in; by year GVKEY; if last.GVKEY; run;

sh0e · ‎07-06-2016

Although writing out the full INPUT statement may seem 'inefficient', it is really best practice because it gives you full control. Also, you may be able to generate the INPUT statement if you have the field names available in electronic form. The lazy, er, efficient approach will be to use PROC IMPORT as 'CSV' is one of the available DBMS options. Hope this sends you on the right solution path.

sh0e · ‎07-06-2016

This is DEFINITELY a task for PROC SUMMARY as @ballardw notes.

sh0e · ‎07-05-2016

Here is a technique that uses PROC SUMMARY to reduce the data. proc summary data = in nway missing; class id var2; var var1 date; output out = reduced( drop = _type_ _freq_ ) min=; run; data deltaDays; set reduced( where = ( var2 = 'X' ) ); deltaDays = date - var1; run;

Online Status	Offline
Date Last Visited	‎10-13-2016 10:55 AM

Re: Adding counts to proc report

Re: sas query

Re: convert variable of Char and numeric to date

Re: Convert macro variable to numeric

Re: Macro : Repeative Case statement into a Do Loop

Re: Expand on Loop query

Re: Expand on Loop query

Re: How do I collapse/combine identical observations using a Quantity ...

Re: proc freq how to change the order of yes no

Re: Report the latest date if two consecutive primary IDs are the same

Re: Question on dollar format

Re: How to add an additional column

Re: Add to add date suffix to dataset name

Re: How to one variable value into many variables

Re: proc sql sum several variables and group by

Re: Convert macro variable to numeric

Re: How do I collapse/combine identical observations using a Quantity ...

Re: Weekday text to value

Re: Define optional argument to function (FCMP)

Re: Adding counts to proc report

Re: sas query

Re: convert variable of Char and numeric to date

Re: Convert macro variable to numeric

Re: Macro : Repeative Case statement into a Do Loop

Re: Expand on Loop query

Re: Expand on Loop query

Re: How do I collapse/combine identical observations using a Quantity ...

Re: proc freq how to change the order of yes no

Re: Report the latest date if two consecutive primary IDs are the same

Re: proc freq how to change the order of yes no

Re: Report the latest date if two consecutive primary IDs are the same

Re: Append several csv files with many variables

Re: proc sql sum several variables and group by

Re: How do I measure days between two different observations?