PROC FORMAT IN SAS | SAS GLOBAL OPTIONS SAS TUTORIAL FOR BEGINNERS VIDEO 4
Vložit
- čas přidán 25. 05. 2020
- Informats and formats tell SAS the data's type (character or numeric) and form (such as how many bytes it occupies; decimal placement for numbers; how to handle leading, trailing, or embedded blanks and zeros; and so on). SAS provides informats and formats for reading and writing variables. For a thorough description of informats and formats that SAS provides, see SAS Formats and Informats: Reference.
With informats, you can do the following:
Convert a number to a character string (for example, convert 1 to YES).
Convert a character string to a different character string (for example, convert 'YES' to 'OUI').
Convert a character string to a number (for example, convert YES to 1).
Convert a number to another number (for example, convert 0-9 to 1, 10-100 to 2, and so on).
Note: User-defined informats read-only character data. They can convert character values into real numeric values, but they cannot convert real numbers into characters.
With formats, you can do the following:
Print numeric values as character values (for example, print 1 as MALE and 2 as FEMALE).
Print one character string as a different character string (for example, print YES as OUI).
Print numeric values using a template (for example, print 9458763450 as 945-876-3450).
YOUR TEACHING IS SUPERB MADAM
PLEASE TELL MAKE A DETAIL VIDEO ON DICTIONARY .TABLES AND INDEXES VIEWS
if permanent libarary how to deactivate global options
and how delete or remove lable statements in datastep and proc sql
Mam do u provide training on credit risk modelling retail loans and ifrs 9 cecl implementation
medam yours teaching is super how can i reach u for u r live classes
Can you create a playlist according to lecture 1 -2 and so on
Dear Rajat it's already there SAS Programming Tutorials: czcams.com/play/PLCKKfofE2XYGPF9i2vkAgzY1fOwDMyK20.html
okk ,, thank you
Hii mam what is the use of var function and how to use
It helps you to compute the variance.
Are you discuss the var function in any class
Mam instead of format we can use if conditions?
Format and if both are having different use case.
When I'm using the same format $gender. For sex here it's not converting them and the length of sex is showing only 1... How to do it???
Please share the code snippet to review.
i have one doubt ,,, how can i set permission for SASUSER library in SAS university edition ? i am getting an error "ERROR: Write access to member SASUSER.FORMATS.CATALOG is denied."
also i am not able to locate Catalogs in folder section of left side in university edition
is there any way i can contact you ? i have few more doubts regarding permanent library is disappearing when i restarting sas session.
@@RajatMadaanmaddy bro when you create library by right click in the top right corner you will see one check box jst check it.so that you can view your libraries when you open freshly
@@rajashekar5755 can you send a screenshot...it will help
@@RajatMadaanmaddy sorry bro, i thought in sas environmental software
Bro can you share sas software
Dear Raja
No need to download any software you can register below and directly access sas via web link
www.sas.com/en_in/software/on-demand-for-academics.html
HI CAN YOU TELL ME YOUR INSTITUTE NAME ALONG WITH THE WEBSITE PLEASE
Our Website is trenovision.com
data missing_data;
input name : $15. age department : $30. sal;
cards;
Saikat 16 Physics 1000
Debasmita 20 Chemistry 2000
Maya 23 BiologicalScience 3000
Razia Math 4000
Kushal 25 Geography 5000
;
run;
Can you please help me how to read this data? Here in the row no 4, age is missing, but I am not providing any period(.). I am just making a mistake. is there any way to read?
Here you have to use period while importing data from an external file you can use missover option to handle missing values.
@@Trenovision yes correct. If we use missover option, it can handle missing values at the end or consecutive missing values till the end. I am not providing any value in the middle of the data. For that reason, I will have to provide a period? Or is there any option in SAS, we can use?