About qoit

pkm_edu · ‎05-02-2023

Thank you so much for explaining the code.

dscastelino · ‎05-11-2021

Is there a way to include a macro for multiple HAVE datasets.

qoit · ‎05-01-2021

Thanks @SASKiwi , I don't have access to the Management Console but below statement did the job. LIST DEFINED SERVERS OUT=TEST;

ChrisNZ · ‎04-27-2021

Good on you for reporting it.

Leo9 · ‎04-26-2021

Thank you all who responded, appreciate it.

qoit · ‎04-08-2021

Below should do it: data have; input Old_var_character $; if find(Old_var_character,"-") then New_var_numeric = input(substr(Old_var_character,3,3),best12.); else New_var_numeric = input(Old_var_character,best12.); datalines; .5 1 5.5 10 10.5 100 300 1-2 2-4 2-8 4-8 ; run;

Khalid2015 · ‎04-04-2021

hi qoit, I do not think this would solve. I need to compare surgical vs Endovacular. the "where" statemnt restricts one of the groups from the analysis

mounikag · ‎04-02-2021

Thank you so much. solution worked

ResoluteCarbon · ‎04-02-2021

OMG, disaster! Thank you @japelin . I just notice the character and numeric and forget the syntax error. ....

Akter · ‎04-01-2021

Hi andrease, I liked your program😊. However i want to add additional sex column and want the output with additional 4 columns by Girls and Boys as written in Data 'Want 'below. data have; input q1-q5 Sex; datalines; 200 200 200 200 200 B 200 100 . 200 200 G 200 200 100 100 200 B 100 100 200 200 200 G ; run; data want; Ques total success Girl_tot Girl_Sucess Boy_tot Boy_Sucess q1 4 3 2 1 2 2 q2 4 2 2 0 2 2 q3 3 2 1 1 2 1 q4 4 4 2 2 2 2 Thank you in advance for your help.

ballardw · ‎03-31-2021

@Phil_NZ wrote: Hi @qoit Thank you for your point, I just checked and yes, it is correct. Just wondering why SAS execute the code and resulted in the worksheet storm_final inside the workbook storm but also another csv storm_final outside the workbook storm as the picture above? Warm regards. Update: Maybe I created the csv file "storm_final" in advance that tricked my eyes. I try to delete the file csv storm_final, and rerun the code and it is good that the csv file storm_final no longer been created. I was going to mention that the timestamp on the CSV in the picture you show is 15 minutes before the one on the Storm.Xlsx file. So likely an artifact of prior code you aren't showing.

Tom · ‎03-29-2021

The example data step you show for reading in the IRIS data is use DATALINES (aka in-line data) because that is how they decided to do it. Most likely because it is easier than having to distribute two files, one with the program and one with the data. But it looks like you already have a text file with the data, so you can write a data step that does not need to include in-line data since you can have the data step read from the text file. If you know the structure of your CSV file just write your own data step to read it. data PARKDAT; infile '/home/wkmustahs210/sasuser.v94/ParkNGendSAS.csv' dsd firstobs=2 truncover ; input .... ; run; If you don't know what are the names to use for your 50 variables just open the CSV file in any text editor (such as the SAS program editor) and copy the first line. If you cannot tell if the variables are intended to be numbers or character strings from the names then look at some of the 80 lines of data and figure it out. It will not take you very long and you will definitely do a better job of figuring out how to define the variables than PROC IMPORT could even hope to do.

Tom · ‎03-26-2021

It would be easier with a CSV file instead of an XSLX file. Then you could write a data step to read it.

Phil_NZ · ‎03-24-2021

@ballardw An amazing suggestion and explanation for me, which really benefits me in the future because I am keen on something that I can play with like that. Warmest rergards.

ballardw · ‎03-24-2021

A random variable name on the OUTPUT statement is going to throw an error if not used properly. In your picture the variable name underlined has no context. All those "expected" are Statistics or the option specifier / . Statistics, associated variables and variable names are expected. But at name without context in one of those places is invalid. If you are creating a statistic for a specific variable you use statistic(variablename(s))= <name of new variable(s) if desired

Online Status	Offline
Date Last Visited	‎05-04-2023 07:04 AM

Re: Creating variables using PRXMATCH() and SCAN()

Re: PROC IOMOPERATE to list SAS active Sessions

PROC IOMOPERATE to list SAS active Sessions

Re: Resolving a macro name in same data step up

Re: Character to numeric variable

Re: code for chi square test from cards input

Re: Character length cannot be used with numeric variable?

Re: Transposing columns into row and counting total values and specifi...

Re: Date Imputation

Re: Why I exported by usinhg xlsx engine but the result apeared under ...

Re: how to change character values

Re: SAS 9.4 Migration

Re: How to find all observations after first.

Re: Character functions

Re: ODS HTML Errors - No body file

Re: Character to numeric variable

Re: code for chi square test from cards input

Re: Date Imputation

Re: Character length cannot be used with numeric variable?

Re: Creating variables using PRXMATCH() and SCAN()

Re: Fill missing values in all variables of a dataset

Re: PROC IOMOPERATE to list SAS active Sessions

Re: Why is FedSql ineffective with dates?

Re: Resolving a macro name in same data step up

Re: Character to numeric variable

Re: code for chi square test from cards input

Re: Date Imputation

Re: Character length cannot be used with numeric variable?

Re: Transposing columns into row and counting total values and specifi...

Re: Why I exported by using xlsx engine but the result appeared under ...

Re: How to input large dataset without typing as datalines?

Re: Reading xlsx data

Re: Creating a subsample based on after date condition

Re: Group by sum in proc summary