About fatemeh

fatemeh · ‎01-06-2021

Hello, How to customize format of some variables when importing CSV file inside PROC IMPORT ? Appreciate for any help.

fatemeh · ‎12-20-2020

Thanks for your response. I changes the datarow to 2 but still the issue is not solved. w2 and w3 are not under body_weight_different_time and also the same issue for L2 and L3 that they are not under body_length_different_time. I attached the CSV data and the result in pdf . Appreciate for any help. options VALIDVARNAME=V7; proc import datafile="mypath/Book1.csv" out= myoutput dbms=csv replace; guessingrows=max; getnames=yes; datarow=2; run; proc print data=myoutput; run;

fatemeh · ‎12-19-2020

Hello, how to import the csv data in to sas that having variables' name and variables w1, w2 and w3 be under body_weight_different_time and variables L1, L2 and L3 be under body_length_different_time. Appreciate you helping me solve the issue. Bellow are my code and data set. options VALIDVARNAME=V7; proc import datafile="path/mydata.csv" out= myoutput dbms=csv replace; guessingrows=max; getnames=yes; datarow=1; run; proc print data=myoutput; run;

fatemeh · ‎10-12-2019

Hi, I working through the SAS Programming 1: Essentials training. I am using SAS University Edition. I am trying to set up my practice files. I am using the instructions provided for instructions for free software from SAS using SAS University Edition: SAS Studio. I replaced the FILEPATH with the actual path for the folder. When I run the program, I get this error "Library PG1 does not exist.". I have seen answers for similar posts for SAS Enterprise Guide but I am unable to figure out for SAS University Edition. Please see the code below. I would really appreciate if someone can help with this. %let path=C:\\Users\FATEMEH\Desktop\SASUniversityEdition\myfolders\coursedata\EPG194;

fatemeh · ‎04-07-2018

Hello all, My question is that why when i execute the bellow code it gives me no output and the log says ' DATA STEP stopped due to looping'? I attached the raw data file bellow. Appreciate for any help. data people (drop=type); infile 'C:\Users\myuser\Desktop\census.txt'; retain address ; if type='H' then input @3 address $15. ; if type='P'; input @3 name $10. @13 age $3. @16gender $1. ; proc print data=people; run;

fatemeh · ‎03-09-2018

hello all, I want to read this raw data ,that i attached here, in sas.But there is a problem in my coding i can not find the right start point for each variable when using @ in the input statement, also the length of each variable is not clear for me.Bellow is my code. Any help is appreciated ! data tempy; infile "C:\Users\FATEMEH\Desktop\summer2017work\temp.txt"; input @1 dept$5. @7 wagecat$1. @8 wagerate 7.2 @16manager$7. @23 jobtype 3.; proc print data=tempy;run;

fatemeh · ‎02-15-2018

do you mean i should replace validvarname with validMEMname? below is my sas code still giving me error options validMEMname=any; data '2$adc2_'n; infile datalines; input score1 score2 score3; datalines; 90 80 9878 8865 66 6992 94 96 ; proc print data='2$adc2_'n; run;

fatemeh · ‎02-15-2018

thanks for your reply. I just copied the codes you corrected and pasted it in sas and executed that!

fatemeh · ‎02-15-2018

options validvarname=any; 56 data '2$adc2_'n;infile datalines;input score1 score2 score3;datalines; ERROR: The value '2$ADC2_'n is not a valid SAS name. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 56 ! 90 80 9878 8865 66 6992 -- 180 56 ! 94 96;proc print data='2$adc2_'n;run; ERROR 180-322: Statement is not valid or it is used out of proper order. ERROR: The value '2$ADC2_'n is not a valid SAS name. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 58 proc print data=2$adc2_;run; - 22 200 ERROR: File WORK.ADC2_.DATA does not exist. ERROR 22-322: Expecting a name. ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

fatemeh · ‎02-15-2018

thanks for your reply .still sas is giving me error for both validvarname=any and validvarname=extend

fatemeh · ‎02-15-2018

Hello all, sas variable name length is 32 character,however sas says that character variables can be up to 32,767 bytes long.it is confusing for me .character length is 32 or 32,767? I appreciate if anyone enlighten me.

fatemeh · ‎02-15-2018

Hello all, As in sas, names begin with letter(lowe or upercase) or (_) but I want to use 2$adc2_ as my data set name and using (validvarname=any) .Where validvarname=any should be placed in a data step to make this name(2$adc2_) valid?below is my sas code. any help is appreciated. data 2$adc2_ ; validvarname=any; infile datalines; input score1 score2 score3; datalines; 90 80 98 78 88 65 66 69 92 94 96 ; run; proc print data=2$adc2_;run;

fatemeh · ‎01-26-2018

Hello all.I want to use qtr function but the date d that is shown in result is 01/01/1960 which is different from the date that i want as i put in my sas code.Any help is appreciated to correct my mistake. data nn; d = '05/19/2016' ; p = qtr (d); format d ddmmyy10. ; run;

fatemeh · ‎01-22-2018

Hello all, thanks for the previous replies.The following statements of trim function are from sas Help and Documentation example in sas9.4, but it gives me error any help is appreciated to remove the errors. data afewords; input Word1$ Word2$ ; cards; *some/ WHERE *every* THING *no* BODY ; proc print data=afewords;run; proc sql; select trim(both '*' from word1) from afewords; quit; proc sql; select trim(leading '*' from word1) from afewords; quit; proc sql; select trim(trailing '*' from word1) from afewords; quit;

fatemeh · ‎01-21-2018

Hello all. i want to use trim function in statement but it gives me error.Bellow is my code. any help to solve the error is appreciated. data afewwords; input Word1$ Word2$ ; cards; *some/ WHERE *every* THING *no* BODY ; select trim(word1) from afewwords ; proc print ;run;

Online Status	Offline
Date Last Visited	‎04-04-2023 05:53 PM

How sas can read sas dataset that is saved as data.sas in sas studio

sas base

Re: ods rtf

ods rtf

Re: proc mixed assumption

Re: generalized linear mixed model 'proc glimmix'

generalized linear mixed model 'proc glimmix'

Re: proc mixed assumption

proc mixed assumption

intercept in random statement in proc mixed

Re: How sas can read sas dataset that is saved as data.sas in sas stud...

Re: sas base

Re: sas base

Re: ods rtf

Re: ods rtf

Re: ods rtf

customizing format of some variables when importing CSV file inside PR...

Re: import csv data with all variable names in differet category

import csv data with all variable names in differet category

Library PG1 does not exist

creating one observation per detail record

Reading raw file

Re: validvarname

Re: validvarname

Re: validvarname

Re: validvarname

sas variable name length

validvarname

date format

trim function

trim function