About ab97_cd

Krissy217 · ‎12-13-2020

You will need to use the DDMMYYS10. format. This tells SAS you want to have 10 characters (including the slashes) in your date and the "S" says to use slashes in the format. You will need a format statement before the datelines statement that looks like: Format date DDMMYYS10.;

Tom · ‎12-09-2019

@ab97_cd wrote: Hi, I want to import data with columns "shop", "id", "2019-01-01", "2019-02-01", "2019-03-01", "2019-04-01". I have problem with date because SAS read it as "42455" etc. How can I fix it? Variable names are character strings, not dates or numbers. So if you tried to read an Excel file where the variable names were entered into the cells as dates instead of as strings then SAS will convert them into strings. When SAS reads a date value from Excel as a string it gets the underlying number that Excel uses for that date converted into a character string. To convert back to a date first convert them to a number and then add the negative value that SAS uses for the base date that Excel uses for dates. Excel numbers from 1900 and SAS from 1960 but there is an additional 2 day difference because of difference in whether to count from zero or one and because Excel mistakenly treats 1900 as a leap year. date = input(date_string,32.)+'30DEC1899'd ; format date yymmdd10.;

tomrvincent · ‎12-09-2019

bad name for a variable...create it as year2019, for example, if possible. If not, refer to it as '2019'n.

Tom · ‎11-27-2019

If you have a complex weighting (sampling) design then you probably will need to use PROCSURVEYMEANS instead of UNIVARIATE or MEANS. https://documentation.sas.com/?docsetId=statug&docsetTarget=statug_surveymeans_toc.htm&docsetVersion=15.1&locale=en

Tom · ‎11-17-2019

The easiest way to read in multiple variables where some of the values can contain spaces is to use some other character as the delimiter. data want; length name $20 age weight 8; infile cards dsd dlm='|' truncover ; input name age weight ; cards; Joe Smith|50|200 Sam Jones|30|120 ; You can also make sure that there is as most one space in the middle of the value and at least two spaces after the value. Then you could use the & modifier on the INPUT statement. But that is usually harder to maintain. data want; length name $20 age weight 8; input name & age weight ; cards; Joe Smith 50 200 Sam Jones 30 120 ;

ChrisNZ · ‎11-12-2019

Something like this? proc sql; select SCHOOLS, OPINION, COUNTRY from AAA ,BBB where index(SCHOOLS, PLACE, 't' );

Online Status	Offline
Date Last Visited	‎12-09-2019 05:08 PM

Proc sort by date column

Date conversion when importing a file

Re: double weighted mean

double weighted mean

date format

Re: Creating dataset with long strings containing spaces

Creating dataset with long strings containing spaces

Error in macro statement

Re: date format

Re: Date conversion when importing a file

Re: Proc sort by date column

Re: double weighted mean

Re: Creating dataset with long strings containing spaces

Re: Error in macro statement