About Zacc

Zacc · ‎04-06-2022

@ballardw, Thank you so very much.

Zacc · ‎04-05-2022

First, I do have a variable, year of birth (i.e. without days and months of births). Second, I would like to derive age from the stated variable based on today’s date. I’ve attempted the derivation using the following code but I’ve been unsuccessful. Data myage; set suvdata; AGE=floor(YRDIF(RB080, today(),"AGE")); run; I shall be most grateful for your help.

Zacc · ‎04-03-2022

Thank you so very @ Kurt_Bremser.

Zacc · ‎04-03-2022

The names of each variable in the dataset are the same (i.e. "complete list of variable/format pairs") as the specified VALUE names in the PROC FORMAT .

Zacc · ‎04-02-2022

@ kurt_Bremser, thanks for your response. Indeed, I would different formats for all 549 variables.

Zacc · ‎04-02-2022

@Sas Community, I do have a dataset with about 594 variables which I am preparing for analyses. I have added variable labels using the right procedure. To add the corresponding values to few variables, I used PROC FORMAT: proc format; VALUE HNCO1K 1="Very good" 2="Good"; VALUE HTM50L 0="V" 1="G"; RUN; I would like to add the analogous values which I defined, using PROC FORMAT, to each of the 594 variables. Using the data step, I know I could apply the format as such to few variables: DATA help_formatted2; SET help; FORMAT Rate HNCO1K. Code HTM50L.; RUN; However, I am struggling to find the most efficient way to add the values to all 594 variables in one attempt. I shall be most grateful for your help.

Zacc · ‎04-27-2021

Thank you so very much @Mark2010 for your insight. Indeed, the input data sets which I used were the culprit. After a new upload, I finally obtained the same answers as those provided in the practice key. once again, thanks.

Zacc · ‎04-26-2021

My apologies, here are the corresponding links: Link to the exam question: https://vle.sas.com/mod/quiz/attempt.php?attempt=282358&cmid=82041&page=6 "Write a program that will use a SAS DATA Step to: Combine data sets cert.input08a and cert.input08b by matching values of the ID variable. Write only observations that are in both data sets to a new data set named results.match08. Write all other non-matching observations from either data set to a new data set named results.nomatch08. Exclude all variables that begin with "ex" from results.nomatch08. Run the program and use the results to answer the next 4 questions." Link to the corresponding solutions as provided by SAS: Answer: 1200 SAS code that could be used to solve this project: proc sort data=cert.input08a out=work.input08a; by ID; run; proc sort data=cert.input08b out=work.input08b; by ID; run; data results.match08 results.nomatch08 (drop=ex: ); merge work.input08a (in=a) work.input08b (in=b); by ID; if a and b then output results.match08; else output results.nomatch08; run; proc contents data=results.match08; run; proc contents data=results.nomatch08; run;

Zacc · ‎04-26-2021

Dear all, Regarding "SAS 9.4 Base Programming Performance-Based Exam" practice examination, I have the following code which produces the same result as the solution code which SAS provided: libname results "....../Cert/output"; Proc sort data=cert.input08a out=sorted_08a; by ID; run; Proc sort data=cert.input08b out=sorted_08b; by ID; run; Data results.match08 results.nomatch08(drop=ex: ); merge sorted_08a(in=a8) sorted_08b(in=b8); by ID; if a8 and b8 then output results.match08; else output results.nomatch08; run; However, to answer question 3 ("How many observations (rows) are in results.match08?") and 5 ("How many observations (rows) are in results.nomatch08?"), I got 51 for the former, and for the later, 1151. More so, the provided solution gave the same results as the referenced figures. However, 1200 and a 2 where given in the solutions as the right answers. I have read through the log and the contents which resulted from the proc procedure but couldn't deduce how the figures where derived. I should be most grateful for your insights.

Re: Deriving AGE from YEAR of BIRTH

Deriving AGE from YEAR of BIRTH

Re: Adding Multiple Values to a Dataset Using PROC FORMAT

Re: Adding Multiple Values to a Dataset Using PROC FORMAT

Re: Adding Multiple Values to a Dataset Using PROC FORMAT

Adding Multiple Values to a Dataset Using PROC FORMAT

Re: SAS 9.4 Base Programming trial examination (Question 3 & 5)

Re: SAS 9.4 Base Programming trial examination (Question 3 & 5)

SAS 9.4 Base Programming trial examination (Question 3 & 5)