About EmilyAV

EmilyAV · ‎10-16-2023

Thank you.

EmilyAV · ‎09-11-2023

Works great, thank you! I have never used the union function before.

ballardw · ‎01-12-2022

@EmilyAV wrote: In a previous programming session, I wrote the following format: proc format; value class 1 = 'No tests' 2 = '1 to 3 tests' 3 = '4 or more tests'; run; Two questions: 1) How did this format get attached to the 8. general format? Now, when I create other variables and designate them as 8. format, I get the following error message: ERROR: The format CLASS was not found or could not be loaded 2) How can I search for the CLASS format I created to delete it? It doesn't appear in my permanent or work libraries? 3) How can I change 8. back to a general numeric format? Thank you. The error does not have anything to do with attempting to create other variables. Pretty much any use of data set with a format not currently defined with throw the error when option FMTERR is set. With NOFMTERR set you will often get something similar to Format XXXXX was not found or could not be loaded. where XXXXX is the name of the format in question. The default format for the variable type would then be used.

Reeza · ‎12-01-2021

You can create a format from a data set. An example and some basic details are here: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1e19y6lrektafn1kj6nbvhus59w.htm And if you're not sure how to structure your data set, make a small example using proc format and then have it saved to a data set using the CNTLOUT option.

PaigeMiller · ‎11-14-2021

Why use PROC FREQ at all, if you want sums? data original; input id concert1 concert2 concert3; datalines; 1 1 1 2 2 1 2 2 3 2 0 0 4 0 2 0 5 1 2 0 ; run; proc summary data=original; var concert1-concert3; output out=_sums_ sum=/autoname; run;

Astounding · ‎10-26-2021

It depends on your ultimate objective. If you just want to run PROC FREQ, that can be done easily: proc format; value $yes 'Yes' = '1' 'No', 'Missing', 'Unknown' = '0'; run; proc freq data=have; tables _character_; format _character_ $yes.; run;

EmilyAV · ‎10-15-2021

Thank you!

Patrick · ‎10-01-2021

If I understand right what you're trying to achieve then a merge is may-be simpler. I've used for your reclass table the same variable names than in the have table. That's not a must but makes things even simpler. IF in the step merging the tables there is a match with the reclass table then the values from this table will overwrite the ones in the have table. If the variable names would be different then you'd have to code for it. Also consider to not replace the key but to introduce some additional group_key or the like. data reclass; input key group_key var1 var2; datalines; 2 1 . 9 17 1 . 17 32 1 . 3 33 1 . 14 41 1 . 15 ; data have;; set reclass end=last; var1=888; var2=999; output; if last then do; key=10000; output; end; run; proc sort data=reclass; by key; run; proc sort data=have; by key; run; data want; merge have(in=ina) reclass; by key; if ina; run;

EmilyAV · ‎08-16-2021

Works great, thank you!

EmilyAV · ‎08-12-2021

Thank you!

Tom · ‎07-29-2021

SAS has two types of variables. Fixed length character strings and floating point numbers. So the first thing you need to check is whether your variable is numeric or character. Then if it is numeric whether it has a format attached that being used to specify how to display the floating point numbers as character strings. If the variable has date values then it has the number of days since 1960 storing in it. The format is what makes that number meaning full to humans. So if the date is the third of February in the year 2014 then the value stored is the number 19,757. If you display that number with the DATE9. format it will look like 03FEB2014. If you display it with the MMDDYYN8. it will look like 02032014. If you display it with MMDDYY10. format it will look like 02-03-2014. If you display it with the format you mentioned, MMDDYY8., then it will look like 02-03-14. If you want to type a date value into your program you can use a date literal. That is a quoted string with the letter d appended. The string inside the quotes needs to be something the DATE informat can interpret as a date. So use one of these values: '03FEB2014'd '3-feb-2014'd "03feb14"d

Online Status	Offline
Date Last Visited	‎01-17-2024 07:46 PM

Re: PROC SGPLOT ordering by category and group

Re: PROC SGPLOT ordering by category and group

Re: PROC SGPLOT ordering by category and group

PROC SGPLOT ordering by category and group

Re: Select single observation based on two unique dates

Re: Select single observation based on two unique dates

Select single observation based on two unique dates

Re: Find and delete a format

Find and delete a format

Applying a dataset of multiple format labels to another dataset

Re: PROC SGPLOT ordering by category and group

Re: Select single observation based on two unique dates

Re: Find and delete a format

Re: Applying a dataset of multiple format labels to another dataset

Re: Creating new variables using counts and multipliers

Re: Transforming a categorical variable into a binary variable

Re: Generating a data set that includes zero counts

Re: Using hash tables to replace multiple variables

Re: Efficiently organizing multiple levels of a categorical variable i...

Re: Importing a data labels from a tab delimited .dat file

Re: Selecting dates using where statement