About Konkordanz

Konkordanz · ‎08-01-2023

Hi, I want to import a text-file that has 5 variables (gs, zbz, regs, rpara, wertn). Result with the Syntax1: Its importing the variables, but their content was cut off. Its strange, because I thought, thats not possible with DELIMITER=';'. Do you know how to fix that? Thank you! (The result of syntax2: SAs imports 5 variables, but without content) Sntax1: proc import datafile="[...].txt" out=rkf replace; GETNAMES=yes; DELIMITER=';'; run; Syntax2: data want; infile "[...].txt" dlm=";" dsd truncover; input gs $100 zbz $100 regs $100 Rpara $100 wertn $100; run;

Konkordanz · ‎07-27-2023

Hi, with the following proc-tabulate-step I create the dataset "mz2022_ergebnis" (screenshot). The variables names are pretty cryptic. Is there a option to define the output-names within the proc-tabulate-step? proc tabulate data=mz2022 out=mz2022_ergebnis (drop=_:); class PET_ArbZeit_neu / mlf; var HRF; tables PET_ArbZeit_neu="" all="Gesamt",HRF=""*sum="sum_2022" HRF=""*COLPCTSUM="rel_2022"; where PET_StiB3 = "2_abhBesch" and P_erwtyp3= "1_ET" and BevHH_HW=1; format PET_ArbZeit_neu $PET_ArbZeit_neu_fmt.; run;

Konkordanz · ‎07-14-2023

Ah okay, so, I tried it: %let varname = DF0900P; data result; variable = "&varname"; length fname fn $200; infile "[...]\syntax2021.sas" filename=fn; input; if findw(_infile_,variable) then do; fname = fn; output; end; run; The var-name DF0900P is definitly part of the syntax " syntax2021.sas ". It looks like: [...] P_Kg=DF0900P; [...] But it didnt find it. Any idea why? The result of your code is:

Konkordanz · ‎07-14-2023

Hi, my sas-project has a lot of programms and I want to search all of these programms for specific variables. I want it to be automated. Means: 1. SAS shall use the column1 of the sas-dataset "variables". There are the variables it should search. Alternative: I would paste the list of variables into the syntax. 2. Search all programms (except the search-programm) of the current sas-session for the variables. For example: Is the variable1 from the "variables"-Dataset (reps. of the list within the syntax) part of any program of the running SAS session? 3. Pls write the result for every variable into the sas-dataset "result". Is this doable? I need it, because the codeplan of my companies dataset changes every year. And I have to know, if "my variables" are part of this changes. Thank you for help!

Konkordanz · ‎07-11-2023

Hi, I calculated a chi²-test by running proc freq with this code: proc freq data=sashelp.cars; table type*Origin /cellchi2 chisq expected deviation STDRES; where type <>"Hybrid" and type<>"Truck"; run; ...and got this result: The result shows: The differences are significant. Question 1: Now I want to know, where are the biggest/lowest differences between the expected and the observed values. There it would be helpful, to colorize all the values of the row "deviation". For example like in Excel "conditional formatting". For example, I want the numbers to become greener the larger the number. Is there a option for this? Question 2: Because I want to know, which cells are the reason for this chi²-result, Ive choosen the output incl "STDRES". With these standardized residuals, I want to find out which cells indicate particularly striking differences. But I cant find them in my result. Ive red, that I have to use "crosslist" like this: proc freq data=sashelp.cars; table type*Origin /crosslist cellchi2 chisq expected deviation STDRES; where type <>"Hybrid" and type<>"Truck"; run; The design is much different from the other I want. Therefore my question: How can I display the STDRES-Values as additional Row within the first output? Thank you for helping again!

Konkordanz · ‎07-11-2023

Okay, thank you for your help. To be honest: It sounds a bit cumbersome to me if you always have to think about the dataset and the syntax or catalog at the same time. But well, maybe I'll discover advantages from this (compared to SPSS or Stata for example).

Konkordanz · ‎07-10-2023

Hi, I have written a huge proc-format-code and used it for value-labeling a specific dataset. Afterwards I wanted to save the labled dataset in my companys network, so each colleague can use the final result. But within the dataset it didnt save the proc-format-definitions (value labels). How can I save them into the dataset? I red, that one can reuse proc-format-definitions, if they are saved in a sas-catalog; is that right? Does that mean, that the definitions are saved locally on my pc and not within the dataset? So I always have to share my dataset AND the proc-format-syntax?

Konkordanz · ‎07-10-2023

Wow, only the missing bracket was the reason.Thank you! But what is actually the difference between these two codes? proc tabulate data=have; class age ; weight w; classlev age / style=[cellwidth=11cm]; var weight; table (age ="" all),weight*(mean n); /*with bracket*/ run; proc tabulate data=have; class age ; weight w; classlev age / style=[cellwidth=11cm]; var weight; table (age ="" all),weight*mean n; /*without bracket*/ run; With the bracketing, the n refers only to "weight" and without brackets the n refers to all involved variables? That means...without parentheses, all cases that have a value in any specified variable are involved?

Konkordanz · ‎07-06-2023

Thx for answering! And right, I corrected it in the initial post. But it doesn't change the problem I described.

Konkordanz · ‎07-06-2023

Hi, i generate my results with proc-tabulate and a included weight-variable. Afterwards I compare my result with a friends result (made with another software) and I recognize a marginal difference. I researched a lot to find the reason for the difference and I found it: There is one person in my dataset that has no value in the weight-variable. Actually this person should not be part of the result, but it is. So I researched, how to avoid it and found the information: "Prior to Version 7 of SAS, the procedure did not exclude the observations with missing weights from the count of observations." http://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1hdr41psnyg4en137jaap5ia951.htm But my SAS-Version is 9.04.01M7P080520 (proc setinit; run;). So: What is the reason for it? I mean...sure, alternative I always could exclude this person with the where-command. But this isnt a intuitive and smart option. That would be error-prone because I would always have to think of exactly this case. correct result: proc tabulate data=mz2020_j; class wirtschaftsbereich ; weight HRF_P_Sn; classlev wirtschaftsbereich / style=[cellwidth=11cm]; var arbeitszeit_tats; table (wirtschaftsbereich ="" all), arbeitszeit_tats*mean n; format wirtschaftsbereich Sektor. where HRF_P_Sn is not null; run; wrong result: proc tabulate data=mz2020_j; class wirtschaftsbereich ; weight HRF_P_Sn; classlev wirtschaftsbereich / style=[cellwidth=11cm]; var arbeitszeit_tats; table (wirtschaftsbereich ="" all), arbeitszeit_tats*mean n; format wirtschaftsbereich Sektor.; run;

Konkordanz · ‎06-28-2023

Hi, is there any description of the logic of proc tabulate? I doesnt get it, how the logic is with all the brackets...how do I have to set them, where shall I set a Multiplication sign etc.? For hours I try to get a table like this: kreis A kreis B kreis C arbeit arbeit arbeit wirtschaftsbereich <32h >32h total <32h >32h total <32h >32h total A 40% 60% 100% 30% 70% 100% 50% 50% 100% B … … … … … … … … … C … … … … … … … … … But what I get is something like that: kreis A kreis B kreis C arbeit arbeit arbeit wirtschaftsbereich <32h >32h rowpctn <32h >32h rowpctn <32h >32h rowpctn A 0,06 0,26 1,64% 0,48 1,34 7,21% 0,34 2,35 9,84% B … … … … … … … … … C … … … … … … … … … I want all the data as percentage (per group; <32h, >32h, total). I just can't get the Total column to be 100% and each of the two columns ("work") before it. Thats my syntax - pls help me. Thank you! proc tabulate data=xy; class Wirtschaftsbereich Kreis_3st Arbeit; classlev Wirtschaftsbereich / style=[cellwidth=11cm]; var HRF; table (Wirtschaftsbereich All), HRF*Kreis_3st*(Arbeit RowPctN); format Wirtschaftsbereich Sektor. Arbeit Arbeit. Kreis_3st $Kreis_3st.; run;

Konkordanz · ‎06-20-2023

Oh, thank you for your effort and your responses! I will look at them in the coming days and get back to you. This will take a while because I need to get into your detailed answers and the many syntax steps that are new to me. Thanks!

Konkordanz · ‎06-16-2023

Thx for answering. I wouldnt say "wrong", because I dont calculate an default median. I have to calculate a median based on a formular of the institution Im working for. I have fleshed out my initial post above.

Konkordanz · ‎06-15-2023

The goal is to calculate a weigthed median, based on a formular from the institution Im working for. With the 11 steps I calculate each component of the formular: - Xmin_B and Xmin_H - b_B and b_H - n2_B and n2_H - Fx_1_B and Fx_1_H - fx_B and fx_H At the end, I put these components into the formula and calculate the median (step 11). That works pretty well. But with new variables I always have to manually adjust the syntax. And my hope is, that there is a solution like a loop...

Konkordanz · ‎06-14-2023

I have fleshed out my initial post above and added my syntax that works based on the current data set (but I have reformulated/anonymized the syntax a bit). I hope this doesn't make too much work. Thanks!

Online Status	Offline
Date Last Visited	‎08-03-2023 10:38 AM

import txt: variable width

proc tabulate: output dataset and define varnames

Re: Search all programs of the project for specific variables (Syntax)

Search all programs of the project for specific variables (Syntax)

Two questions about ChiSquare: get STDRES into the column and colorize...

Re: Save the proc-format definitions in the dataset

Save the proc-format definitions in the dataset

Re: proc tabulate: weight with missings?

Re: proc tabulate: weight with missings?

proc tabulate: weight with missings?

Re: import txt: variable width

Re: Two questions about ChiSquare: get STDRES into the column and colo...

Re: Two questions about ChiSquare: get STDRES into the column and colo...

Re: group labeled variable

Re: group labeled variable

Re: proc report: insert single row

import txt: variable width

proc tabulate: output dataset and define varnames

Re: Search all programs of the project for specific variables (Syntax)

Search all programs of the project for specific variables (Syntax)

Two questions about ChiSquare: get STDRES into the column and colorize...

Re: Save the proc-format definitions in the dataset

Save the proc-format definitions in the dataset

Re: proc tabulate: weight with missings?

Re: proc tabulate: weight with missings?

proc tabulate: weight with missings?

Proc Tabulate: percentage-problem

Re: loop for changing variables in changing datasets

Re: loop for changing variables in changing datasets

Re: loop for changing variables in changing datasets

Re: loop for changing variables in changing datasets